Hi all. Quick Question: Can I declare a variable that gathers some data in
Access and then use it in an Excel Macro? How do I do it?
Note: The Access Module calls the Excel Macro.

I am using Access 2000 and I am having trouble with an IsNull control box.
Could you please tell me what is wrong with this picture?
=DCount("[InitiateDate]","tbl_Main","[Office] = 'LO' and [TrackType]='CWQT'
and (IsNull([TransCompleteD])")

in a when I have a field that is definined as .. "fld"
I find that the statement fld.type  returns a number.  How can i return a
string that describes the field?  ie: "Number" or "Text"
thank you,

I've got a form that views single records in a table, and the navigation
buttons are turned off.  There's a subform with a datasheet view of a related
table, where there can be several records associated with the one record in
the main form.

            I didn't use acess forms for a while and I totally forgot how
to add records using the command button in a form. I would like to get that
code.
Any help really appreciated.

I have a problem with Run-time error number 2342.
I think my sqlCmd statement is correct, but I have on idea, how can I solve
this problem whe running application with statement below:
Dim tBatchNum As String

If anybody knows how to insert a new field in sql using vb , please let
me know. or mail me - d.vinothkumar@yahoo.co.in

I am starting to work on a database that will calculate the escalations on
contract prices.  For example, a contract my specify an aniversary date on
which the price can change by some kind of Price index.  The anniversary date
will fall within a range of dates that the Index ...

I'm trying to send a simple e-mail message when a button is pushed on a form.
Here's the code I'm using:
DoCmd.SendObject acSendNoObject, , , "ckrogers@tir.com", , , "8D " &
Me![LogNumber], "8D ready for management review", False

I need to delete the data in 10 tables prior to uploading new data. I would
like to have this as a button on a form. I have created the button and added
the click event. When I add the SQL statement I get lost in the syntax.
In looking at other help on this site – I found how to ...

All,
I have set up an Access database that I have sent out to various business
locations in different cities.  Then I need to consolidate the information
into one table.  Is there a way to set up the database in a Web environment

i write the module function to get the output of random numbers which
is as :
Sub MySecondConnection()
   Dim con1 As ADODB.Connection

I am getting the error message that my sub or function is not defined:
Private Sub Command8_Click()
   Dim objWord As Word.Document
   Select Case Me.lstNotices

I am new to access so any help would be greatly appreciated.
I created a database that keeps track of employeeID, date, time, and if they
clock-in or clock-out.  I create a form that allows the employee to enter
their Id and click on a clock-in or clock-out button.  The Clock-in ...

I need to INSERT INTO a table with 19 columns.  To simplify the code, I do
not list the columns after the table name, which means I have to define all
19 variables.  (My form has only 16 of them, so I define the others as Null.)
Here is how I thought it would work.  But Access ...