when using an append query in a macro, how can you hide the alerts or dialog
boxes or make them automatically click yes

SetWarnings is not in my macro list of actions in Access 07....even though
applications built in 03 but being used in 07 have them....how does one get
the SetWarnings in new 07 development?   I set up the location on my desktop
PC to be trusted but still no luck.

This is my first macro, so be sensitive!  I am attempting to create a macro
that opens and runs a query, exporting the results to a text file.  It runs
fine until the export step where I get the global message "Access can't save
the output data to the file you've selected.  I've ...

I have a main form in access with a textfield called quote
number.
My problem: I have a button on form which on click should
1.search for a .doc file ( with the name same as the text

I have a csv file I will be importing each month. One of the fields is a
date, but it will not let me import the field as a date, I think because some
records have a date and time and others just have a date.
It allows me to import as text, then change the data type to date/time ...

I'm sure I've seen this posted before, but I must not be using good keywords
when I search google.
I need to update an older DB, where the original person used a lot of macros.
I've already searched code for references to the macros, but that didn't help.

I have set up a database that is beening used by several other users.
What I would like to do is to write a macro or VBA so that when the program
is being shut down, it will do a compile and repair automaticaly.
Is this possible?  

I have an autoexec macro that I mistakenly built an exit command in, which is
generally how I would want it to be, but occasionally I'll have to add
validation records in, without the macro, and need to figure out how to edit
the macro to remove the exit command.

I have more than a hundred queries that I must export from one MDB file to
several other MDB files.
I have tried to use the Macro-building tool.  But when I select "RunCommand"
as the action and "Export" as the command, there does not seem to be any

I have a feedback report that service people need to email.  The way they
print now is to pick "File", "Print", "PDF" then enter.  I would like to
automate it through the print button on the form.
Any help would be appreciated

Please bear with me as I try my best to describe a problem we have with our
Access 2003 program. I didn't create our system but I do use it daily.
We're using Access 2003 (I don't know the version) for a simple inventory
program. We have 12 fields that has 10 items (entries) each. ...

I have a "frmMain" and this has an unrelated
"frmSub".
There are text fields in each which have the
same value.

I can create recorder macros but I do not know how to code; yet. Is there a
simple macro to resize multiple graphic files in a word doc?
thank you,

I'm new to Access and need some help with building a macro.
On a form, how do you use the Set Value Macro to hide (visible=no) a control
based on the value in another field?  What would you use for the Item and
Expression?

I am working on a database for a friend.  They have set up a relationship
between tables, all looks correct however when I go to look at the relatiship
in the table I get the message
The table or query name 'Sheet1) you enter in either the property sheet or