I'm trying to do a SELECT statement looking for a DATE_COMPLETED field which
is blank, meaning it has not been completed.  The DATE_COMPLETED field is a
DATE type field.  How do I specify my WHERE conditiion to restrict the
results to only those records which have no ...

I have a table in 2003 that has 221 fields defined.
I tried to add another variable and got this error.
I was surprised when it didn't say too many fields defined.
I look at the error description and it says size greater than the

I have a postal code field, when I run the query to ask the user which
postal code want to view.
I need to use like now, so if If the user wants all the postal codes
which begins in 17, Selec * from PostalCodes where "[PostalCode]*"

Hello I'm fairly new to Access but remember just enough programming
from school to be frustrated that I can't figure this out.
I have a table with AccountNum and MonthNum (as a number from 1 to 12).
I need to design a query (maybe a macro?) that will give me the Count

I have written a script to back/compact/repair an msaccess db it works
fine however i would like to determine if access successfully compact
and repaired the database. How could i do this?
I am running Access2k

I have a form with a number of multi-select lists and drop downs that user
can select to define a search criteria. The result then needs to be shown in
another list on the same form. Normally I would use a number of query
working in series (i.e. one query is source to the other ...

I have a continous form based on a query.  The Query checks a students
record to see if a letter has been selected.  The letters are selected
from a combo box so each letter has a corresponding number.  It also
checks a check box to see if the letter has been sent.  If it hasn't

I have custom menu bars for Admins and Users. I now need to add a new group
call 'DataEntry'. Their custom menu bar will be very similar to that for
Admins, with just a few items removed.
So, is there a way to copy a custom menu bar and give it a different name.

I was wondering if it was possible to export information from a pivot
chart when double clicking on the item I want.  For example I have a
pivot chart with Four items in the legend and they are split up into
four categories on the chart.  If I double click on one of the items in

I am trying to create an access file that is similar to a address book
or rol-o-dex.  What I would like it to do is have a line of buttons
each with a different letter on it, when one of the letters is pressed
it only shows those entrees that start with that letter.  I have tried

I have an unbound text field conditionally formatted:
[ID]=DomWert("[ID]";"ActiveLines")
(DomWert is the german translation for domain value)
(to check whether the currend record is within the set of records

I'm not sure if this is possible or even practical to do, but I have a
database which logs customer enquiries and has a field for the status
of the enquiry i.e. Received, Approved, Job start, Job Finish.
I need to be able to date stamp so that when a record is received, the

Im just made one application in VB... one kind of pos system... I use
MS Access 2003...My question is if I run this application twice and
have to users start this applicaton and read, write and update data
what happens I will have some problems... I have two computers

Access 2000 SR1
Windows XP SP2
Word 2000
I have a button on a form (frmMainMenu) that calls a second form

Hi Allan,
I'm using a nifty piece of code you put on here some time back to do a
duplicate entry check as below. I'm using to check for duplicate names.
However I am getting an error message on this line:    Set rs =