I have a form that uses an auto number and a command button that should
cancel the entry if there is a user error (if user initiated a record by
mistake and needs to clear it).  I need this command button (ran by a macro)
to not save the mistakenly entered record, and reuse this ...

According to Access help, it is possible to display expressions in a
message box, as opposed to just text. I am not sure how to do this
properly, but I want a msgbox to display some text as well as a text
string that is referenced off another form.

I am trying to move files using a macro in Access. I create files weekly and
move to a shared folder. However, there is an error (File already exist) due
to the existing files. Is there a way I can override them? Thanks.

I'm full of questions today :)
I have a Date Completed field (date format) and a Awaiting Signature field
(which is a check box).  I would like to know if there is a way to
automatically have the awaiting signature box "uncheck" once the date

Does anyone have a macro that asks for a range like A1:J5000 and highlights
that range?  That would be a nice macro if anyone would share it.

I'm trying to get a form to automatically open when starting a MS Access
database, i need the Macro Required I've triey creating a marco to Open the
form and Naming it Auto_Open, but his doesn't seem to work.

I have a few append queries that I want to run with a macro.  I have done
this many times before and never got the results I am now.  Which is the
queries all stay open or open the tables they are appending to.  I have put
in a setwarning to no but still get all the tables open ...

Due to privacy considerations I have created a sendObject macro for each of
the recipients reports separately. There are 100 reports. Is their a simple
shortcut I can add so I do not have to run and click 'yes' to each email
macro individually?

I need the ability to build up to 58 output files from a single query.
There's a field that can be used to control this.
Tough question?

I'm trying to include an auto report in my macro.  The data in my query is
constantly changing an a 'regular' report will omit any data not included in
the original.  The autoreport will capture all of the current data.
Any ideas how to include an auto report in a macro?

I am trying to run a macro that exports text from a query to notepad, this
works, but Access attempts to put a frame around each result, I need raw text.
See below - Can you help?
-Mark Matzke

Inserting clip art works ok.  Inserting pictures from files causes Pub 2003
to lock up.  Has been working fine up to some time this month.  Save As also
causes lock up depending on file(?).  Similar problem in Word 2003.  Pub 2000
& Word 2000 on same computer ok.  Norton's ...

I am running a macro with the OpenQuery action to run an update query, which
is set up as a parameter query to prompt the user for the new value in the
updated field:
[To change BIN NUMBER, enter new value:]

I use a tool (wget) to download (automatic) a file from a website. This works
fine but when I call it with a macro I cannot let Access wait until the wget
command is finished, (my idea is to download the file and after that some
queries and code changes alot off record but when I ...

How do you create macros in Microsoft Word, if possible.