I have several database that have developed the same issue.
All of these databases have reports that are query driven. The queries
have date range criteria. In the date columns of these queries the
criteria reads Between [Start Date:] and [End Date:]

I need to create a report summary that displays data from 8 individual
reports. The control source for each individual report is a distinct
query. I am currently using an unbound report with
selected fields from each individual report to compose the summary

I have an Access 2003 database that is used by around sixty users.
Routinely I can't gain access, even late at night after I KNOW that no
one is using it.  The database is stored on a server that is accessed
through a Citrix environment.  I've implemented an inactivity timer

Hopefully you will understand my problem.
I have a spreadsheet that i import into a table which contains job
data. Using a number of queries i can filter the data as requested.
What i now want to do is have the database split the data into

Is it possible to create an ImportSpec for an excel file using Access
2003?  I currently have an excel spreadsheet which is imported into my
DB on a daily basis consisting of several hundred transactionsl; of
late we began trading treasuries whose prices are entered as "xxx-

Real quick question, can anyone point me to an article discussing how
to use a listbox where the data comes from a lookup table to store
multiple records in a child table?  I created a form based on a select
query that joins the parent and child records, but it's not an obvious

Someone with very little computer experience is having problems with the
label wizard. She is able to create a new label report, but the result only
contains numbers. It is an address database and all fields are text fields.
Apparently normal reports (not labels) are just fine.

May be it will help someone.
I faced the strange problem with RecordCount property of cloned
Recordset within the Current event handler. The RecordCount value was
correct every time I had diagnostic message boxes turned on or when I

I'm using Accrss 2003. I try to build a GUI using the Webpage-option in
Access. Now I want to call a procedure by placing a CommandButton on the
webpage. Doing so I find the following in thr Microsoft Script Editor
<SCRIPT language=vbscript event=onclick for=Knop0>

I am working on an Access 2002 database where one of the tables has
five required fields making up the key.
There is a form that is linked to this table which is used for adding
new records.

Consider having tblCorrespondence, then copying & pasting
it to tblCorrespondence1 - such that they are identical. Then
consider the following UNION SELECT statement...
SELECT tblCorrespondence.CorrespID, tblCorrespondence.VehicleJobID,

Some of the people are requiring a personID to be in the records and
of course formatted as 001 002....etc so its a text field.
Now they are also skipping this field and putting in stuff and just
quitting out...leaving junk records in the tables.

I'm attempting to use Tony Toews utility.  I've set it up after taking
awhile to figure it out (this is due to my inexperience and definitely
not the utility!)  I'm not sure if I've done this right but I have
an .ini setting for each user, which sets each users "my documents"

Hi people,
My main form has a subform nested with another subform, both subs
work as a subDatasheet. Indeed I keep the mainForm just to put some
filters. Whenever I open de MainForm I have no problems. The mainForm

I installed Office 2003 SP3 and ever since been experiencing database
corruption. I normally close the database (compact and repair), do a
backup and reopen the database and open a form, any form, I get the
dialog box "Microsoft Office Access has encountered a problem and