I am trying to calculate two fields. I have six fields in
query window...
ID, PAY_CODE_1, PAY_CODE_1HOUR, PAY_CODE_2, PAY_CODE_2HOUR
PAY_CODE_1 and PAY_CODE_2 include pay codes such as

A2K,
My form has an image frame. The user can pick and save the image to be
loaded into the frame. The path and filename are stored in a table (it's
always a path to a photo CD).

I know the path you export to from Access can only be a
certain number of character at max, but I don't know what
that number is.  Can anyone tell me the exact number for a
maximum path name?

A user has reported a problem with an Access 2000 database. Upon open the database asks for a password and then says 'needs to be repaired or isnt a database file'. This database is protected by a password. When I say 'Yes' to repair, I get a message 'not  a valid password' and ...

Two fields on a report contain a date-time stamp recorded by =now().  How to
display the elapsed time in hh:mm format in a third control?

My problem is about combo box filters. I have two combo
boxes one is for main category and one is for sub
category. When you choose the main ctg. from the first
combo, the second combo box shows the sub categories

When I have opened up my form I want to jump to a specific
record. Is this possible, and how?
Do I have to use some magic RunCommand constants ??

I have an open form. I want to write info into fields
then save without closing form or moving to next record.
Is it possible to do this programmatically by clicking a
button? What code should i use? Thanks in advance.

I found the following commandment on the www.mvps.org/access site.
Thou shalt never allow thy users to see or edit tables directly, but only
through forms and thou shalt abhor the use of "Lookup Fields" which art the
creation of the Evil One.

I keep getting a runtime error 3464, Data mismatch. ">><<" indicates the line the error is o

Could anybody help me to find out how to program Esc Key to exit an open form.
thanks for your help!

This is a follow on from an earlier post I had in
the "External Data" group. I am still having problems and
suspect this may be a more appropriate place to ask.
Whenever I try and use the "Dir" function I get a message

Following is the code fo a command button I have on a form.  I am trying to
get the contents of LIST9 into the TRN_PAY field in my TRANSACTIONS table
but I am getting a NULL instead.  What am I doing wrong.
Private Sub Command43_Click()

How would I go about trimming off only certain trailing
numbers from a non-fixed width field?  In other words, if
I want to trim off "999" everytime it occurs at the end
of a number, no matter how long the number string is,

I have a report in which I need to print a series of values using the
following formula TimeSerial([txtTeeTime],11,0)+[txtTeeTime]. However, when
I enter values greater than 12:00 in [txtTeeTime], the result increases by 1
hour.