I went back to my search form, deleted all and started over from scratch.  
When I went to the code window and ran the debug, I get the following error
msg.  Complie Error; Duplicate Optiion Statement.  
Then it automatically highlights the Option Compare Database statement which

my client is running windows XP on all workstaitons. I'm looking for some
free or not to expensive (under $100 total would be nice - not per
workstation, but total) software that I can control from Access for a dozen
or so workstations just to burn some files to CD from my Access ...

I am using Access 2000 I would like to know if it is possible to copy the
effect of the mouse over a button that happens when the mouse pointer hovers
over the closing “X” in the control box. Eg when the mouse pointer hovers
over a button but before it is clicked the button ...

I have users that threw me a curve and now want to have the query show the
records that do not have a date in a field.  This query will then be the
bases for a report that will be used.  The report will exported to excel and
when it is, I then need to have it so the date exported ...

Here is the code, the first column in the table is the primary key. I get an
Access error window (with a negative error number) instead of the error trap
being triggered. I need to trap duplicate inserts.
Public Sub DupTest()

I have four major fields that my db is filtered by regularly
I have four combo boxes with grouped options.
address     lastname    firstname  company
I need to filter each by each as they are used.

How do you create query that can be used to append data that has no unique
identifier? I am afraid that if I append data twice on accident it will cause
duplicate data in the table. I tried selecting distinct but it doesn't work
and creating an auto number primary key will only ...

I am using Access 2003.
I am exporting tables to Excell.  No problem here.
However, what I want to do is set the name of the Excel file using VB in
Access.  I' would like to use NameXLS to name the Excel file I'm exporting to.

I have a form that automatically assigns invoice numbers as records are
added.  On the form is a combo box with a pull down defaulting  to
"Invoice", but you are allowed to choose "Credit Memo" or "Finance Charge"
in addition to"Invoice".

At least that is what I am thinking is needed.  Here's the problem:
On my main form, there are 3 combo boxes, Company, Shape and Size.  User
selected one for each.  On the subform is a search button that runs the query
and displays the results.  All works but I would like to add a ...

I am very new to Access and VBA. I am trying to add a multiselect list box
(http://allenbrowne.com/ser-50.html) and code to a search form
(http://allenbrowne.com/ser-62.html) that I modified based on Allen Browne's
examples, but I can not seen to get the code right, as I keep on ...

I have created 2 buttons to open 2 different forms but I would like to
create one button to open a certain form based on certain criteria.
Here is my current code for one of the buttons:
Private Sub ContactsForm_Click()

I'm using MS Access 2003 and Windows XP Professional.
I should like to save the extra effort of programming reports. A lot of
effort has gone into designing the layout and arrangement of data in the
form, and the form displays the data very nicely. So I should like to use it

I am unable to update the data in a subform.  I have the code attached to a
close button on a popup form.
Code follows:
Using Forms![formname]![subformname].requery

Hello, I have a form that I need to calculate duration.  I'm sure it is
somewhat simple to do but I'm just not sure how to do it.  I have to fields,
one is start time and the other is end time and both have the medium time
input mask on them.  All I want to do is calculate the ...