I have a form with multiple test boxes to create a new record when a command
button is pushed.  All works and closes the form.
I want a second command button to call the same maco and have a condition on
the form close action so as to not close if I want to add additional records.

I used Access 2003 to develop several macros awhile ago.  I recently upgraded
to Access 2007, and many of the Actions I am familiar with (like
DeleteObject, Rename, CopyObject, SendKeys etc...) aren't in the list of
available Actions.  But, if I open an older database that ...

I can't find a macro command to open an icon on my destop.  Double
clicking the icon on my desktop connects me to a mainframe.  I'm
trying to replicate that in a macro.
Thanks

I have a Macro that runs on a scheduler, it runs every 30 minutes and it
updates the our database.
The problem that I have is that if someone has that Table open, the macro
errors out and Locks the database.

I've read the help section on SetValue.  I've read the books I have, but
still can't get this to work.  Clearly I don't have the expression syntax
correct.  How do I (what is the syntax) insert text into a field, on a form,
using the the SetValue action.  I also want the current ...

Is it possible for a macro to output multiple queries to a certain sheet in
an excel file?

Good afternoon.  I hope all is well.  I have two data tables in
Microsoft Access, Table 1 and Table 2.  Both data tables contain about
2.6 million records.  However, on Table 1 important information is
missing.  The two tables include data concerning mechanical parts,

I need to send a export table with a macro, but all time appear this message:
A program is trying to send mail using Item.Send
i make this macro:
Sub a()

Currently when I enter new data into a subform (I open the subform in form
view for easier data entry) and then save and close it and go back to the
main form, I have to exit out of the database then re-enter for the new
information to show on the subform datasheet on the main ...

I am working with 8 groups of 51 dbase files that are all in a trusted
location. My plan is to create one table per group, which means importing 408
dBase IV (I’m guessing the version) files as tables and appending 400 of the
tables to their respective 1st table. I’ve already ...

I am trying to create a macro from a command button that, when clicked, will
open a new record of the subform (Reservations_subform)  in form view for
easy data entry and set the value of the CustomerID field to the same ID as
the record on the main form (Customers).  I have ...

I'm trying to create a button in access 2007 that will
a) open maps.google.com (this part i can get no problem)
b) automatically enter the address information from the record.
I think it should be something like:

I am trying to write a VB macro that will allow me to open up several
reports under one parameter.
For example I have 7 Reports, where the primary Key is ProjectNumber,
I want to be able to click a button and have a pop-up box asking the

I'm trying to create a macro to open a subform to the record that was
double-clicked.
I've got a macro set on the OnDblClick property as follows:
Action:  OpenForm

I'm using 2007 but want to create my Db to share with 2000 users.  In
numerous cases, I've seen macro actions missing from the list, so I come to
the newsgroups, and in every relevant case see that someone fixes the problem
by "showing all actions".  Mine is grayed over.  Is this ...