to any one that can help,  I am trying to create a form which has two combo
boxes.  The first combo box has a list of categories and the second combo box
would show just items within a category.  I have looked at Article ID 97624 &
98660.  I have followed the directions very ...

We just converted from Access 2000 to 2003.  Is there a reason why all macros
using the runapp command will not run?  All of them get an error message.
Is there another command that is replacing Runapp?

I run a macro in Access that sends approximately 50 emails. I was using
lotus notes and had no problems at all. Now that I have installed Outlook
2003 I get the warning stating that someone is trying to send an email
message and it could be a virus do you want to allow this. Is ...

I have read things about them being unreliable and trouble but i dont mind. OK
I want to be able to open a form by hitting a combination of keys. This can
be done using send keys, yes? how do I do this? I have done the "Sendkey"
thing in a macro and then "OpenForm" with the form ...

Good morning.
I am working on an existing db in which the developer turn off the majority
of menu items.  The FILE menu is usable for PRINT and EXIT.  I need to add
the EXPORT command.  I want to do this in a MACRO and then run a QUERY and

While creating a table with a macro the New Table dialogue box pops up and
asks input from me. I have to press enter or click oke but like to avoid
that. In other words how can I insert the keystroke enter within the macro so
that it will continue to run.

I inserted a toggle button with a simple macro to close the subform when the
toggle button is clicked but it's not working.  What am I doing wrong?

How can I set the value of a control in a query using a macro.
For example, I've just printed a report based on a query and now I want to
record "Action Complete" control as True.
Any ideas??

I want to link data from one file to another using a macro / visual basis. I
am hoping to have a drop down in which I can select the week number I want to
pull into me 'master file'
I would have one master file and 52 weekly files. The macro should allow me

I want to know if it's possible to output/export data from several different
queries into the one word document for use in writing a report.

Access 2000  (but will be used in access 2003 single machine)
I tried to put a msgbox macro tied to a forms open event, and it worked
fine. But it only gave me the option to click "ok" and no other options.
This was a feable attempt at making a macro that would print ALL reports ...

have a form in my access 2003 database on which i embedded a "find
record button".  when i clik on this button a window opens asking
What to Find:
Look in: Search Form

I am new to using Recordsets to select data from tables, but I tried building
the following statements to start out:
   PQuery = "SELECT * FROM PHY"
   Set PRecord = CurrentDb.OpenRecordset(PQuery)

I am using a Macro to throw up a "Save As" Prompt when someone creates a new
spreadsheet.
I would like to know if its possible to make it so that when the "SaveAs"
prompt it thrown up, it automatically is in thefolder "w:/PCD Service

I have several queries that all prompt for the same paramter, Year, which is
not going to vary within one run of the macro.  When I run the macro, it
prompts me for the Year for every query where that parameter is needed.  Is
there a way I can have the macro prompt for the ...