Just a quick question
I am creating a form that will ultimately open a table based on a query.  
One of my filter criteria is a list box that will allow multiple selections.  
How would the where criteria look in the query  i.e.

I found this code in an Access 2007 programming book and tried to make it
work(using Access 2003)which may be the problem.  Does anyone see a problem
with the code which would give me the error message:
"Undefined function 'pcase' in expression.

Every day I find a new reason why nobody wanted this job.
I have built a vacation-tracking system that worked quite well with "File
Number" as a key. I say "worked" because last week we found that a File
Number was duplicated. A whole new set of problems was illuminated.

How can I parse a text field to pick up just the date.  The field has mixed
values. If I could get some guidance in how to look for starting point of
text or number, I could try to use instr and mid but I'm stumped about how to
start the search. Thanks.

I am looking to schedule MSAccess to run a macro either by MSAccess itself
via VBA(preffered option) or via an external app.
Note the following;
1. MSAccess will already be running (so I don't want task schedular to run

I've seen several people ask this question recently, but none of them have
received replies.  Perhaps this is impossible?
I have a Pivot Form in Access 2000 that I've made into a nice little pivot
chart. I have another form that updates the data in the pivot form query, so

What i have is a query that needs to export to a template that I have set up.
I need each field in the query to go to a set Cell on the template. What is
the best way to do this?

I would like to turn off only the check box controls that have already been
selected.
I have a multi-row data sheet subform that I use to select multiple records.
However if the some of the rows have already been selected I would like them

Hey there,
For the past few weeks I've been programming a lot of things with VBA. There
only is one thing that I haven't got a solution for. I've made a script in
VBA which has to add a certain field to a table based upon a date. This date

Currently I am writing data to a table based on an Excel file (name could be
anything), then changing the name of the file to show the date, based on the
date given in the file, and then moving it to a designated project folder,
based on the project number listed in the file, and ...

I have a Site lookup table with one field (SiteID).
I also have a Projects table (ProjectID, Project Description) and an
AssignedProjects table(ProjectID, SiteID)
There is a form, which for each project, displays all the sites assigned to

I have a database that prepares data to notify our clients if there was any
microbiological growth on their samples. The database will look for a
non-null value in [strCount]. It will then pull in the [strProjectManager],
[strClient], [strSampleName], etc. This is used at the ...

I  have a macro in an Excel workbook that imports data into an Access
database.  Once the data is imported, the following sub is automatically run
to compact the database for the user.
Several warning messages are displayed as the databases compacts.  The

I have a letter that is generated to every student attending our school in
the fall.  If a student's registration is incomplete, the letter blocks out
certain key information to encourage the student to complete registration
before the start of school in order to receive this key ...

I'm trying to automatically create a logonname out of a filled in sur- and
lastname. I'm running into a small problem here. This is the full code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim i As Integer