I just wanted to let everyone know that I figured out a way to do
this. I created a form to pass the date values to my query. I didn't
have to change any of the code to my DCOUNT function, which I thought
I might have to do after reading some of the posts. Maybe I

I have four tables with the contractor field. These tables were
created over the years by different people and the spelling is
different in each table for the contractor field. I would to be able
to use these four tables in queries but the different spelling of the

It's kicking my butt.  All I want to do is add 1 to each new records I add
to my table using a form.  The serial number is in the form 0001, 0002, 0003
etc, and increments for each record.  If I enter the value in the table
directly it retains the leading zero's however if I use the ...

I'm working on a new report in an MS Access DB.
The first anomaly was a message "This action will reset the current
code in break mode." when the report was run.   Seems TB something
about my Detail1_Print(): if I answer "No" to the dialog the report

My problem is when trying to embed or link a graphic into a table as a bmp.
I am developing an access database which has photos of clients.
When I choose the object type, created from a file I get he following error
message.....

How do I resolve the problem of passing a string that has quotes
within in a SQL statement? Sometimes the string contains a single
quote (') and some others it contains the double quote (")?
Any clue...

I have a problem that is driving me BATTY!  I have a report, that contains
no sub report, no dlookups and no nested queries.  This report is based on a
normalized set of tables.  The SQL is used in the record source.  When I run
the SQL, it opens into datasheet view fine, without ...

i have a DB which allows users to allocate trainers to course
sessions, they fill out date, start time , end time and other fields
and when they click on the trainer field I have a pop up which shows
the AVAILABLE trainers, i.e. it checks the existing session times and

I keep having problems in which ADO disconnected recordset work under some
circumstances, but lose all their data at other times, having no rows or
fields, though the recordset object still exists.
One case where this happened to me today was in trying to store disconnected

I have an application that sends a query by e-mail in Excel format using
a DoCmd.SendObject statement in VBA. I need to delete the column
headings now before I send it. Help appreciated. Thanks.
Steve

Below is the code I currently have to either skip a control or go to a
control based on the response in the complications control.  The
problem is even when Me.Complications is "None" the cursor goes to
RiskAssessment.  What's wrong with my code?

Since I just started my new work, I have inherited a MS Access
database which has nearly 13000 records in a single table. Now, my
mandate is to clean the database and maybe split the table into two.
Can anyone please give me some ideas on how to clean duplicated

I have Aceess 2000 front end linking to SQLServer 2000 BE.
While developing the backend I work on an offline database. When happy I
update the live one. Any changes I've made to the testone are highlighted by
running some database comparison software that shows all the differencs

I have a database of Access tables on the server and ODBC links to
legacy systems.
This is not too much of a problem as, at least, I have my tables/files
in 2 distinct places.

I need to develop a Tab Form where selecting a particular key from an
unbound combo listbox will resulting in the display one or many
records from several tables, where each tab has the matching rows for
the selected key.