Can the current database (the one that’s open) be compacted using a macro in
Access 97?  When I try to use the RunCommand (Action) CompactDatabase
(Command) in a Macro it opens a dialogue box (explorer) looking for the
database.

I have an macro that runs whenever a new record is added to a main form.  The
macro automatically adds a new record into the subform with standard default
values.  
This feature is working fine, but it only inserts one record into the

pulling my hair out. experienced access user with old 'tricks' not working.
just want to update one field in one table.
tried. condition:[table1]![field1]![value]="abc" and
[table1]![field2]![value]="xyz"  action:setvalue

I  have a macro where I print a report of the form I am entering on.  I
created a button for the macro.  When I press the button it comes up blank
because the information is not saved as I am entering it.  I am trying to
make it so rather than clicking on save record, the macro ...

I have a very basic macro that:
1) renames an existing base table from "abc" to "abcYYYYMMDD" (where
YYYYMMDD is the current date).
2) uses transfertext to import data into a new table called "abc"

I am trying to send a report by email,  using the macro sendobject method.  I
used a command button to send the email from a form.  The query which is used
for the report creation has the email id of different employees.    I used
the [forms]![formname]![fieldname] to send the ...

I am trying to create a Macro that will open another database but not sure
what to put in the command line.  I tried to put the path where the database
it located but i get and error.. Hope someone can help..
Thanks

I need some help to make my little project work. !! Any help is very
appreciated
What I want the macros to do ?
Compare cells A2:A28 with cells B2:B28

I'd like to summarize the returned customer surveys, which are stored in
different Excel files, preferably using a VBA template.
The data structure of the source files are linear, i.e. all answers are
within one column in the source files.

I have created two forms using Access 2002. I used SetValue action in both
macro to hide and show each form after a command button is clicked. It worked
fine with Access 2002, but when I operate the database from my colleague's
computer (which runs Access 2003), the following ...

I apologize if this isn't where I should post this.  (If so, please tell me
where.)
For all the work I've done in Access, I've done virtually nothing with forms.
I'm trying to set up my "main menu" form, but can't seem to get it to work.  I

How can you start to use Active x controls, is there a reference guide or web
that you could recommend for someone starting out. I already use all the
other features on the tool box but I don't know where to start with Active x.
Any advice?

Can this be done.
I have made a simple radio station ad scheduling system but it takes forever
because I need to repeat the append qry the max potential number of times to
make sure evry add is scheduled.  I need to make this simpler by stopping the

The Macro I used has several quries  and a report.  The queries are ususally
parameter query i use to filter data.  The report is also based on  a
parameter query. all these queries has the same 2 parameter for example
Enter Vessel Code

I'm new at this. I would like to pause this and enter the content for Name:=""
as in Name:="Albion2"
How can I re-write this please?
John