I have a single table with two ID fields.  The second ID field is a cross
reference to the first to show a link between two separate entities.
ID1        ID2
001

I have a password form, the code behind the OK button is as follows:
Private Sub okbutton_Click()
If Forms![password form].text_password = "fav1m" Then DoCmd.OpenForm "name1"
Else: If Forms![password form].text_password = "ro488" Then DoCmd.OpenForm

Please guys everyone knows about the date settings on microsoft outlook so
this fault is alittle harder than that to locate.
Emails while in your own computer or sent to yourself  have the correct date
and time.

I am attempting to extract the first 2 digits of a 6-digit number in column
CX for a new column. I've entered the following for the query:
NEW:Left([CX],2)
but receive the following error msg: "The syntax of the entered expression

In a query, is there a criteria that will count the number of characters in a
field... For instance...
Show me records w/ less than 6 characters in FieldA...
Thank you!!

In  Query1 I have two fields:
CurScore    ReqScore
1            2
0.5            3

How can I add a function to an expression in query? I have the following
expression:
OPSE Avg All: (Nz([OPSE cracker Avg],0)+Nz([OPSE Pudding Avg],0)+Nz([OPSE 10
ml Avg],0))/CountItems([OPSE cracker Avg],[OPSE Pudding Avg],[OPSE 10 ml Avg])

John has been helping on another issue related to this one.  Here is the deal:
1.) When I start a new query and bring in one table everything works fine.  
I am adding the number of items processed for a period of time by User ID.
2.) When I introduce another table that contains ...

I am trying to use an expression as a name of a field in a query.  However it
is not working.
For instance,  the expression  Format("30/06/07","ddmmyy") comes as a string
"300607", which I want to use as a field name.  When running the query a

I'm relatively new to access' more advanced features, like queries etc. and
am happy ot supply more information as required.
I have 'inherited' a database which basically lumps most of its information
in one field. This can contain associated people, places etc.

I have a main form that the user can select a ProjectID.  When this is
selected a subform displays all the records in that table for that ProjectID.
My problem is that for example: I select ProjectID (PWD) the subform will
disiplay every employee working on that project, but ...

I'm beginning to question my own sanity here.
I have a simple query that derives these fields:
UID Firstname Lastname Registered Updated Accessed Num
The fields Registered Updated Accessed are strings in the underlying tables,

hi again -
i wud want the user to enter the employee code. That ecode would be checked
in the table for a duplication and based on the result, if the ecode entered
is a unique/new one, the rest of the data is allowed to be entered else if

I have a query that has a date/time field on it and in the criteria field i
have Date()-1.
My problem is that on Sunday there is no data... so what I want to do is
something like  

I've got a field with several 100 characters. The exact composition of those
characters vary.
However, in all records, a certain exact phrase will always be present.
I'm needing to replace that phrase with another while keeping the rest of the