Anyone out there had any experience with saving with the
DoCmd.Save?  I had to switch my macro to vb code due to
lan connectvitity and the long delays in retriving data
over my work LAN.  I can now open the spreadheet and

I need a button that will check (make true) two check boxes (fields)
For the record that has the focus (the record on the form that I am
presently looking at).  The two check boxes would be like a "sold"
check box and an "add to report" check box (for print out).  Also as

I'm a novice at MS Access97. I am creating an Application
in Access in which i have the
following requirements
I have a form in which I fill some search criteria. This

I want to create a macro which changes the value of a
text box to zero, when the message #Error is displayed in
the text box.
My text box is unbound, so i can manually delete and

Does anyone know what the syntax and format should be for using DLOOKUP as a condition in a macro
I am trying to basically run macro1 if the value in tableA exists in tableB .....or run macro2 if the value in tableA DOES NO
exist in table B
I know how to write and use a dlookup when ...

Hi i have a form that contains two subforms. I have a
macro attached to one field on subform1 which if a
particular option is chosen i want to go to a new record
in subform2.

I have never suceed to set value by using SetValue command
in macro.  It always return the following error mssg
(which is my translation from Chinese)
START

Is there a way to move records from one table to another
in Access 2000 without using code?  I want to completely
remove the records from the original table and place them
in another table.  I have appended, updated, and deleted

I have a whole bunch of email addresses with the user's first and last names
all on an access database.  I want to send out a broadcast email.  Is there
an Access function that does this or do i have to write my own.
please advise

while working in access 97 ...trying to compact db, program says there's
another user trying to access the same data...but no one else is on....?

I entered this problem before but can't seem to see this on line so I am entering this again.
My make and append and delete queries work correctly when I run them manually and individually. But when I use a macro, the queries do not always run correctly, i.e. one of my queries ...

Dear Macro Pros and MVPs,
I run command line code to run a macro from one database
into another.
I get an error if I try to run the macro without quitting

Howdy Al
    I am using a flat file, downloaded from the internet, to update my database.  I don't want my database to be updated from an improperly formatted flat file, so I do the initial editing and data storage into a recordset that is not connected to my database.  Once the ...

I have a macro all set up to run a mail merge against my query in access--I want to be able to stay in by db and run the macro...I thought I could use a blank form,create a command button,choose run application as the command and then I would have to choose the macro name with ...

I'm using Access and Outlook 2000 to send reports to
various people.  With certain e-mail addresses in the To:
field, I see between 2 and 4 small boxes after the e-mail
address.