I think it's the Syntax but it's not returning a value.  It might be the
DATE part. Any help appreciated.
Thanks
DS

I have a main table commondata that has information in two other tables,
components table and primitives, I need a count of like fileds from
commondata where the line to EITHER the compionents or primitives is good.

I am fairly new to access (using 2003 with a 2000 format project).  I
have created a budget control module that tracks a line item budget and
any updates, and can then assign a purchase order to that line.
I have a main form that has the budget line item number, description,

I have a form that connect to a query, so the data on the from changes
depending on what is selected in the query. Each record has a check box. I
have a select all button on my form and when somone clicks it I want all the
boxes checked. This is the crrent code Im using.

How could I set a popup warning to say that a query was completed (I've
disabled the Warnings to reduce the clicks required to complete an append
query).
Thanks.

I have an update form designed to enter ship dates and other information for
orders.  I have text boxes for the original order date and promise date.  By
the time the ship dates are entered the data for the order and promise dates
is already in the order detail table but it's not ...

I just got some help populating a text box in a form based on a combo box
selection. Now I need to format my report and I'm faced with the same
challenge again!
The following is the thread of help for the form text box. How can I make

The database is an Access 2003 ADP. I want to copy data from an Access
database (mdb) table to SQL Server. I can do this using DTS but would prefer
to use an ADO transfer so that I can do extensive data manipulation on
selected fields (plus I am not real flash on DTS). I can get ...

Is there any way to import the windows files search function that exists in
windows and serves to find files in a defined location and between 2 dates.
because I can already use the function Dir that allows to me to brows all
the files and folders and then with the path get the ...

Can't seem to get the syntax correct for the assignment
statement seen in Sub tbMov3_LostFocus. I need to
set the corresponding text box in the calling form after
focus moves from one control to another. (Only

I cam across a post on this board giving code on how to hide a subform
depending on if a check box was true or fals.  I am trying to recreate and
can hide the subform based on the checkbox's initial value when opening the
form/subform, but if I check the checkbox to hide/unhide ...

I have a situation in an access 2000 app where I would like to allow users
to build and save their own queries. Then, when they want to re-run a stored
query down the road, I want to list only their own queries for them, to
choose from - not the ones that the app uses on a ...

My page is in spanish. When no document is found, I need the information to
be in spanish. How do I change the wording: "No documents found. Please try
again." to wording my spanish users will understand?

I used ADO , to connect to excel file and read it row by row , i has a
problem of text filed in excel,  ex: if the field has values like
'abac' , ,my vba module return a null value, if the field has value
like '43cxcx' it return correct as it is???

I have a form with two combo boxes and associated text fields.
cboJobID     {text box brings up job description from JobId #}
cboEmployeeID {text box bings up employee name}
I created another text box [work hours this week] with a Dlookup