I have a macro in which I have conditions that must be met before a certain
Macro is run.  The problem is I have a number of conditions that must be met
before this command macro will be run and it exceeds the max character length
allowed in the conditions column.  This is ...

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.

Ok, so I've seen how you use DCount to check the value of a query, but what
is the syntax of the DCount function if you want the criteria in the DCount
statement?
Here's my situation: I have a form named New Lender Legal Name.  On that

I wanted the font larger in a msg box and I figured out how to do that. But,
when I run the macro it is still the same size. Any suggestions? Thanks!
-dtalent

Hi! I have such data in Excel's worksheet "Sheet1"
date    id    test1                         test2                 test3
20070801    a1    aa@mm.com     bb@cc.com   
20070801    a2    dd@zz.com       

I have a macro with the following condition:
Dir("S:\VISAPC\CCSTATUS.TXT")<>""
The error I'm getting is this:
The expression you entered has a function name that Access can't find.

I have a problem which, I 'm hoping you can helps me with.
I've built an access form. My form is called "DataEntryFrm"
On that access form, I've created a command button called "Send", When
I click on that button, it open another form called "EmailForm".

I have a macro with a great numbers of steps (basically making a local
copy of tables from a very slow ODBC database and doing some linking
and calculations at the same time)  The macro is calling a series of
Make Table queries. As the macro takes over 5 minutes to run, it would

I am hoping you can help me!
I have a table ( for example ) with a field name "FOOD STUFF" , which has a
look up list from another table.
I have created a form which has the text box ( so actually a Combo box), so

I have a continuous form of 'Customer' records, each with three controls:
customer name, customer type ID, and segment ID.  The ID fields are
multi-value, with column 1 bound in each case.  I attached a macro to the 'On
Double Click' action of the 'Customer Name' control to open ...

Help with writing a macro that will force form users to enter data in
required fields before the form is updated or can exit. The problem I'm
having is the table being used is a 'linked' table, which restricts any
modification to the table. Therefore I can't set validations or ...

I am using citrix to access a remote site and then using the remote task
scheduler to run my database, but it appears on my screen, I want it to run
without coming up on my screen( Like a background process). How can I do this?

I have a 2003 access Database. Daily a macro is run with the command
'transferdatabase'. This is used to copy all data and structure from a table
to an SQL database via an .adp file. When opening this same database in 2007,
I cannot add the 'transferdatabase' command to a macro ...

I have a Macro to send an email after the database has run.  After it runs
and it tries’s to send the e-mail an outlook message box comes up asking you
if you want to send the e-mail or not.  Does anyone know how to get it so I
do not have to click the yes button to send it?  ...

Once again I am seeing wonderful helpful tools.  As usual, they do not answer
my question, (especially for someone as new to Access as I).
I am running a reservation confirmation macro.  I have three different
resorts I am sending reservation confirmations and three different .rtf ...