I am trying to automate the export of a very large
database that is allready importing automated from a text
file. The data only has 4 columns and right now I am
running a query with date range and exporting chunks to

How do I test for the precense of a Null value when
retrieving a field in VBA with a statement like:
var = rst("VariableName"). The field is Null but a test
like:

I've developed a form with some command buttons that link
to reports I've developed. However none of the command
buttons are working and I'm getting the exact same error
message regardless of which command button I press. The

I am using SendObject to send an email to the principal of my school to alert
him that a student is on the way to the office.
Is there a way to add a line break to the Text Message portion of that macro?
Rip

My company uses an access database designed by an outside
programmer.  We no longer have contact with this man and I
am responsible for maintaining the program.  When i went
to open it the other day it did not respond.  I tried to

Is there a macro that i can run that would allow me to automatically rename
a file from, for example, job1, to 0412job1, where 0412 is the current date
(or at least something similar).
I would then need to take this file, copy, and then paste it back as

I have a form with the following parameters:
1 main form based on a query
2 tabs (subforms) that include the following:
  New Employee Entry (new data inputs)

Good afternoon
I have a macro that's hanging on me, and I am not able to determine cause.  I'm on Win2000 running Access 2000.
This runs OnClick on a form
GotoRecord - Next (to complete the record

I have a form with a control button which runs a query.  I
want to be able to have check boxes on the form that
decide the sorting of the query.  Ex. If the box for name
is check I want the query to be sorting by name when it is

Whilst I fundamentally dislike having more than one copy of a DB, I'm in a
situation where I need to.  Currently, I'm doing it by having 2 copies of
Access running and copying and pasting the relevant bits from one to the
other.  This makes me rather nervous, in case I end up ...

I have a macro that changes the title of a macro and its
background colour and then saves the form. The title and
colour change however when the database is opened again
the form is in the original colour and has the original

I have a parameter query that runs off a macro. I want a
second totals query that uses the results of the parameter
query to run off the same macro. How would I set this up.
Thanks.

Please help.
I have a Main form with subforms which are broken up int
in different page via page breaks. Now the problem I have
is that I have put command buttons on the main form and

Good morning,
Can anyone tell me when you are running an MS Access Macro interactively, how do
you prevent the query results of each successive query from opening a new
results table in the GUI window?

hello i have no expirience in access, but i am sur i have
a problem and i want to know if someone know how to solve
it.
when i am using msgbox in macro the access stucks!!!