I have added the database to a trusted location but the RunApp command is not
available.
thanks in advance

I give up.  All I want to do is use the SetValue macro action to put a value
(test) into a field on a form.  I've read the Access help, and a couple of
posts here, but I clearly don't have the syntax for the expression figured
out.  Why is this so difficult. Oh, I forgot, it's MS ...

I have a functin 'test' which takes a parameter 'a'. I run the
function using a  macro (Runncode). The function appears as
test(<<a>>). Now when i run the macro , it gives me an error like
"Microsoft Access can't find the name <<a>> you entered in the

I have been using this condition in Access2000 for years, no problem.
DCount("*","OrderHeader")>0
Yet when I copy this in an Access2003 macro I get this message:
Microsoft Office Access can't parse the

I am using Access2000 and I have 2 forms which can accessed from the
switchboard page and 1 of the forms is functioning correctly but the second
form will not save. At first it was linking to the first form but I think
that has been fixed but now it will not save and go to the ...

I have a macro attached to a command button on a form that runs a query that
appends a new record to a table compiled from field data collected from a
series of controls on the form.
Is there any user-friendly way I can program the macro to trap errors such

I want to create a query using a macro or hide the query from view in the
database window

In access 2003 you could setwarning = false in a macro to disable any pop-up
warnings.
How can you do that in Access 2007?
Thanks

Hi, I need help making a button on my switchboard that will close access. I
know I need to set the button to follow a macro but I dont know how to write
the macro. Does anyone know how to do this? I remember reading it somewhere
but i can't find where.

I am running OutputTo macro that takes a query and exports it to
excel. I would like it to automatically make the file name one of the
fields in the form that I use to run the query.
Currently I have the Output File set to: S:\Sales\Grant Temp\Exports

Ok few thigs to start with:
 I am using Access 2003
 I have little to no experience with VB so if I can do this using the
design window it is over my head.

I know I'm just not formatting something right, but I can't get my table to
export.  I get an error "Cannot update.  Database or object is read-only."  
Neither of which are read only.  What have I done wrong?  Here are my
settings:

I have a phone number database in which I keep phone listings update for our
company.  After I make changes I have attached a macro to a "Update Web"
button on the switchboard.   Two questions?   I have three individual phone
listings is there a way to update all three in one ...

I have a form in excel (using vba) to "add" data into the spreadsheet.
However, is there a way where i can delete it using a form?
i.e. i have a payroll database with a lot of employees.
If an employee quits, i wish to select from the form, the employee which

I have created a custom menu and want to attach a macro to it.  After going
to tools, customize, I right-clicked on the menu item and chose properties.  
There is a place to choose a macro in this box.
However, I need a macro to run the following code: