I need a date validation that will not allow a date to be entered in
the field if it occurs before a date in another field (StartDate).  But
I cannot find any information on how to do this.
Olly

I have a datasheet that has one of the columns dedicated to email address.
The hyperlink (of the text box) of that column set to yes so that the text
in the column appears in blue and the cursor turns into a hand when moved on
top of the text.

Is there anyway to make this Expression cough up a Zero if the field in
this Unbound Text Box is Empty or Null?
Thanks.
DS

I have a question that may have been asked numerous times, however
from the previous postings no one seems to have a plausible
explanation.
This is a performance issue that is very common:

How could I create a query which multiples all the values in one field
of a table by 1000?  Would it be done the same way to do the same thing
on a query from a query of table?  Thanks.
Mat

Well, that's the best I can do to describe it in short at the minute.
We have a peer to peer network, the "server" with the Access app runs on
XP. This worked fine until yesterday, and I am now unable to connect
with read/write capabilities from all machines.

Sorry for x-post.  Using Access 2000, what is wrong with this syntax?
INSERT INTO Activity (
IDType, ID, ProjectID, ComponentID, SubComponentID, ProcessDate )
VALUES (

Can someone please give me the error number for this error?
dixie

I'm trying to do some simple emacs-like macros in the VBA editor for
access. I've figured out how to use VBA.SendKeys to insert the text I
want, but I'm wondering if anyone can tell me a better way to do it.
specifically I'd like to have direct access to the document currently

Private Sub tbDate_AfterUpdate()
   Dim cnn As New ADODB.Connection
   Dim rst As New ADODB.Recordset
   rst.CursorLocation = adUseClient

This one really has me going.  Probably something silly.  I'm using
dcount for a report to determine the number of different types of
tests proctored in a semester.
My report is based on a parameter query which is the recordsource for

how should i format the conditional parameter on the WHERE clause to
limit the query on a date field.
Let say I want to limit the query from today up to a month back, or
today up to 20 days back.

   I am using an Access 2000 client linked to a Postgresql 7.4 server
via ODBC.
I have a stored proc on the server that inserts rows into a
table.particular table, accomplished via an INSERT

MS Access 2002  - query form control returns funny symbols like [][]
I am running an append query on a form.  Access is having trouble with
the calculated fields and comboboxes.  Example – referring to
forms!FormName!ControlName within the query should return the value of

In Access Options, this can be set. I wonder if there are any good reasons
why someone should not use the latest ANSI standard of 92, considering they
develop a brand new database where no old SQL code exists.
Konstantinos