I need to find  all records in the database and then make a change in a
different field of that record based on whether the text exists in the field.
I have a pricing database where I have a discounting scheme that I apply.   I
take the list price, apply a discount, and then ...

I have a macro that is supposed to run VBA code that contains a
function.  This function contains code that decides which of 2 queries
to run depending on if a check box is checked or not.  In my macro i
have the "RunCode" option selected and "chkMisc()" selected as the

I have a small home-based business and maintain my customer mailing list in
an Access database.  Most of my customers have email addresses so I would
like to send out my twic a year mailing via email using some kind of
automated means.  My ISP doesn't allow me to send to everyone ...

Here is my question. I hope someone can help! I am trying to create a macro
that will open a form based on the value a user selects in a lookup field in
another form.
Specifically: Form1 has a lookup field based on its' underlying table. It

I'm writing a macro that will run DSQUERY *  Which opens a command prompt
and tells me all the machines in my Active Directory.
Problem is I need assistance in instructing Access to bring this data in and
create a TBL, so DDE is where my problem is.

I have a DB that uses VBscripting that has a Import table to import a text  
file invoking them from  a Switchboard form.  I get the User-defined not  
defined when I run it.  This is the  Dim dlgOpen As FileDialog ( 'Open-file  
dialog box)  It was built in Office 2003, I can not ...

I have a macro that emails a report to my users.  I save the report to a
spreadsheet using Output Format = Microsoft Excel 97-2003.  The problem I
have is with the dates (data type=Date/Time).  These getting converted to an
integer date in the spreadsheet.

Sorry, I have no VBA experience, and the Access Macro prompts me for every
action.  So I need to find a better solution.
I'm looking to run a series of Append Queries, then to finish by writing a
delete query.

Is it possible to define a date to run a macro, please?
Thanks in advance.
an

I have searched the files and only found one thread that pertained to auto
compact. I understand to use the compact on close will only compact the
front end, is there a way to run a macro to auto compact on the backend?
Michael

I have set up an autoexec macro. The last action it does is "close" the
database. Now when I want to make changes to the database, I can't because
the database opens and then closes. How do I interrupt the macro so that I
can make changes to the database?

I can get Access to open a program like Microsoft Word, but I can't get it to
open a specific file like help.doc.  Is this possible

Is it possible to use the TransferDatabse command and get a popu window to
select the databse you want rather than specify the databse.
Thanks,
duffer54

I want to use a series of Output To commands to create and save a series of
reports. Ideally I would like the file to be saved to the same location each
time, but with a filename that will include (at the end) the text that is
contained in a certain textbox on the current form ...

I have a macro which puts up a message box when a particular control of a
form is completed, reminding the user to complete another associated control
in a subform of the same form. I then want to place the cursor in this
control. I have managed to get the focus to move to the ...