I copied the code from a switchboard button the works, but get a "compile
error, variable not defined" error message for this one.  I highlights the
"stCriterion =  statement.
Any help would be gratefully accepted.

I am trying to automate the emailing of an Access report, avoiding any
human intervention.  I have automated emails in the past using the
"With OutMail" construct, but not involving Access report or query objects.
So my question is this:  Is there an easy way with this approach to ...

I have a user form that has a datein and dueby text box.  The datein field
populates with the current date while the dueby field is 5 business days from
datein excluding identified holidays.  All this happens once the user saves a
record.  I was able to get this to work using the ...

I'm new to access but I've managed to convert a contact template database
into an employee tracking database file. My question is that I want to place
a picture of each individual employee on their own database record.  I tried
doing this but everything that I go to the next ...

I'm trying to use code to assign a value to an unbound text box. I need to
use values from the current record of the RecordSource but Access complains
when the report is run saying that it cannot find the field required. It is
possible to use iif the assign the value to the text ...

i have a table where i am writing a date, for instances (28-11-2007).
I have to retrieve the week Number of the year for this date, in order i can
make querys by week.
i made a table with week as primary Key and Initial date and Final date

I am getting a syntax error while running the below-mentioned query in
VBA (Access), and I am not sure why.
I am trying to insert a record in a table (tblEmp). i am pulling in
data through a form (AddUser).

I'm trying to create one table (only) where the combination of the state
field (IL or FL) and and autonumber field work together as the primary key.  
I can set them both, but I need the autonumber to start over and be
sequential per state.  Is that possible in one field? I assume ...

Hi I have a Macro that has 20 consecutive OpenQuery statements - obviously
each referring to a different query.
The whole Macro take several hours to run - is it possible to show the name
of the query that is currently running in the status bar and idealy, but not

I have a button on a form that imports a comma delimited text file.  It then
runs an update statement which concatenates data into a memo field.  Is there
a way to prevent the same text file from being imported more than once?  I
was thinking if I wrote the name of the file to a ...

How do I use the .FindFirst method when the field I need to search is a Long
Integer?
.FindFirst Me.ID
ID is Long Integer

I have recently taken over a number of Access databases.  The previous
developer used the $ symbol randomly for functions or thier arguments.    I
remember reading about the differance between using the $ symbol and not
using it, however that was years ago.  I have been searching ...

I was wondering if there was a way to use an if statement to change an ado
field name that is to be updated similar to the following:
Dim FieldNm as String
Dim cn as ADODB.Connection

We have a table called 'Priority'.  Priority Levels are assigned using a
form.  If a User does not assign Priority Levels to all of the items, I need
to write something that will check for the Null Priorities, find the Highest
Number already assigned and then number the remaining ...

I have a button on a form that runs this code.  It opens a script saved in a
folder in Query analyzer and hit's Enter when the connect to SQL Server
dialog box opens.  I just can't seem to get it to start running the script.  
i still have to hit F5 manually, but i wan't the ...