I have a form that lists all Outstanding Jobs in our department.  Only a few
fields have been selected to appear in this form.  It's format is Continuous
Forms so the jobs appear in list format.  The form's source is a query that
filters out all jobs that have been completed.

Before I allow a row to be added to the db, I need to check to see if a row
already exists that meets certain WHERE clause criteria.   The user will
have clicked a button to make the addition and I'll be adding the row via my
own code.  But I need to check first before I actually ...

How can I update the value of a textbox with each keystroke in the KeyDown
Event?  For example if I type 'a' "then the value of the textbox is 'a'" ;
then if I type c "the value will be 'ac'.  Then if I take the mouse and
highlight over the ac and type d "then the value will be ...

In my DB (Access 2000 /Win X Home) I have 2 tables:
- tblTransactions to record transactions on transport vehicles
- tblIncidents linked to tblTransactions to record incidents related to a
transaction if any.

I have a form/subform page.
On the form I have a button to 'Browse Folder' that I want to open
Explorer.exe and go to a folder location which is defined by a 'hyperlink'
field in my subform. I know how to run the shell command to get explorer to

Is it possible to write a macro that will goto the next record in a subform?  
Using the gotoRecord option brings up an error message saying that the form
is not open.  Thank you in advance.

A subform consists of multiple categories of labor postitions, the unit
number of each, and the total cost per catagory.  The third field calculates
the cost per unit (ie.  $75K for 3 supervisors = $25K per unit.  The main
form calculates the grand total labor cost of all the ...

I have a form on which are several tabbed subforms.  The form is for the
purpose of inputting information about jobs that come into our department,
and tracking the progress of work on them.  Each job has a job number, and
jub numbering starts at "1" at the beginning of each day.

I don't understand why one machine works on my application and let someone
use the application but it doesn't work on someone's machine getting like
Function is not available in expressions in query expression
("Ucase[LastName]....

Okay I screwed up big time. I was trying to set up user accounts / groups /
etc. so I could restrict my users, and somehow I did not set the admin
password. Now I can only log onto the database as a user.
I need to know how to undo this.....

I have a continuous subform that works just fine when it's based on a table,
but I want to base it on a query.  When I change the recordsource to a query
instead of a table, as soon as I type a single character, I get the error:
"Field cannot be updated."

Okay, I relaize that the following is not a secure way to do things, but
I've been instructed not to use Access 2000's security features, but rather
just make forms for users to enter/change paswords.  Everyone knows this is
not a secure app, and they're completely fine with that.

On one hand, I'd like to create a standard form that is tied to a table and
use it for data entry.  On the other hand, I'd like to control the actual
adding of the record to the DB.  Is there a way to prevent the automatic
addition of the record to the table when the user exits the ...

I have a form that I have the OnCurrent event set to set the Record Source
of a combo box to a query based on the data in anohter field.  This is done
to only allow the combo box to give them options apprpriate to the data in
the other field.

I'm creating an entry form for users to create estimates.  The user enters
an ItemID, and on exit from the ID field, I look up a description from a
table.  I'm using DAO because I'm familiar with it, so I define a database
and recordset variable each time I call the ItemID.Exit ...