Can someone tell me what the correct syntax is for opening a form to a
certain record based on a value from a combo box in a subform?  I am using
open form in the macro and I have tried the following in the Where Condition
and when the Action Failed pop up comes up I can see in ...

I have a lot of macros and VB apps that open MS Access 2000 databases.
This worked great until I started using Access 2003 (and it's new security
model).
In a Visual Basic app, I've been issuing the "Application.AutomationSecurity

I have a macro that runs when a button is pushed, this appends some tables
with fresh information, but it will not allow the information to be
duplicated.  I get the normal message that says x number or records could not
be appended due to duplication.  I have sent a sendkey y in ...

I am using an Access Macro to transfer text files to may database.
Using the TransferText Command
I want to enter the name of the file to be transferred.
I have tried the script of:

I have an Excel spreadsheet where the columns have a comma for their
delimiter.  The file was send to me from my bank (it has a csv extension) and
I cannot get it to import into my access database.
The TransferSpreadsheet will only work with an xls extension.  Can this be

I have a report that I am using the SendObject macro to send the report via
email to multiple people. Right now I have the properties set so that I can
edit the email before its sent so that I can include today's date and the
count of records on the report in the subject line of ...

Just learning Access so bear with me if this is a dumb question. I created a
parameter query that promts for a customer's account. The query works fine
and brings up that customer's account information, but I am querying 20
accounts so is there an easy way for the query to show ...

I am trying to run a module that i have created in access to prevent
people entering certain sections of the database. I have constructed a
password request when a button is pressed to prevent people being able
to access an admin toolbar with all the master controls.

Any one know how to build a macro to run a control button on a form to
populate a field on a from? kind of like a time clock?

I need the code for a macro that will try to Find "#Num!" without the quotes,
within a field called 'Date'.  If it finds #Num! then Quit the database.  If
it doesn't find #Num! then stay in the database.
Can this be done?

I would like to create a macro that will close the whole database.
Can anybody give me the proper way to do this with a macro or VBA.
Basically I have the database set to open a report when the database is
opened.  I would like to close the database when that report is closed.

I setup a search macro and need to be able to set up a print option to print
just the first pg of the form any suggestions?

Please help me to avoid being prompted "The existing table will be deleted
before you run the make table query" when I run macro and inside this macro I
run the command "Open make-table queries". Althought I turned off the check
box "Action query"  under "Confirm" label in ...

Today I have a spreadsheet that contains 100 different sheets in it. In
my module I have to run a macro in each sheet in order to recieve the
final outcome.
Is there a way I could run one macro that will run on all the sheets at

Good day,
I have a macro which runs several queries and finally makes a table of that
compiled information.  This final table is where I need to change the field
size of a text field from 5 to 6, however I don't seem to be able to do that