I want to open a form to a record specified by the user through an input box.
The control on the form that contains the number is txtProject. Here is the
code I am trying to make work:
strProjNum = Val(Inputbox("Enter project number","Project Number:"

Using Access 2000, am running a macro which imports a text file into an
access table.  I have a query which reformats fields which are dates.  Now, I
need a way to change the data type from text to date/time.
All help much appreciated!

What is the Condition I would use to determine if a query has 0 records?  And
what would the reverse be...to determine if the query has at least 1 record?

To print the same report several times with different criteria each time, I
set up a form with 16 textboxes and then set a macro to run the report with
two text boxes something like color = forms!formname!field. Two text boxes
for each time it is run. So 16 text boxes make 8 ...

I am trying to run a .vbs file from an access macro using RunApp. Is this
possible?
If not is there an alternative. I'd like to keep it all in access as it is
the last in  several steps in the macro.

I'm running an Access macro to update an Excel spreadsheet
using the Transfer Spreadsheet function. After executing
the macro, when I open up the spreadsheet, I get the
message: "File error: data may have been lost". I don't

Say, I have 2 tables (1 and 2).  Can I create a query to extract only
records that Table1 does not have in Table2 ?
Steve

I'm running a macro in access that then exports data into
various excel files.  Is there any way the macro will
automatically tell access/excel to replace the existing
files.  Every time it tries to save the data under that

I have a subform that lists many records (obviously). I want to be able to
go to a main form with the record that the user is current focused on (the
record selector is pointing to). I don't know the control name to do this,
is there a way with a macro?

I am trying to create a macro to set a value that is determined by a
hierarchical IF statement.  i.e.  If condition 1 is not met, condition 2 is
checked, if condition 2 is not met, condition 3 is checked and so on.  I am
using Access 2000

I wanted to use the runapp action in a macro with the command line to open a
specific word document.  Basically, I created a macro and selected the action
"runapp" with the command line giving the path of "J:\Anita.doc", but this
didn't work.  How do I open a specific word ...

I have a form which has a macro to open a query.  I also have check boxes on
the form so the user can check which fields they query results will be
grouped on. So if the box is not checked, the query should not be grouped on
that particular field. How can I write a macro to do ...

I have a data entry form ( reciepts) linked to a table( Donations)  that
accepts data into temporary fields ( unbounded text boxes)
An "enter" button on the form kicks off a macro that
1 adds a record to the underlying table Donations

I am trying to import a spreadsheet to a table in Access but am having
problems.
The file is on the D disk
the folder is called "Tutorial"

I'm not sure if this is possible, but what I'd like to do is to have a
custom command on the context menu when I right-click on the name of a
table.  When the command is selected, a msgbox will display the name of that
table.