How to set default value in form like cell before (in same column)?
Example: if cell before have value "FORD", I want copy this value lake
default to next cell.
Thanks!

Using A2K.
I have a form that has all records in the table.  I'd like to bold the
records in the form that have the value '21' in the Category Field and
non-bold if it contains anything else.

Good morning, everybody.
I would create a button, in a form, that execute scanning of a document, but
I don't tried anything by this argument:
someone help me to suggest method (or code) to realize this?

I've done the obligatory searching on google for an answer to this
question but without success.
I have a form (say switchboard) which opens various other forms. I
would like this switchboard to open another form, wait till that form

I have a form with a number of fields that dump data into Table A. I need a
number of validation rules within the form to ensure that dates cannot be
entered incorrectly. I can get one of these rules to work in the validation
section for the table itself, but not more than one. I ...

Anyone know how to find the current screen res and dpi in code?
TIA!

I have button on my form that runs an Update Query. However I want to limit
the query to only run based on the current record on the form. How would l
best handle this issue?

I may have to pay someone to help me with this one.
Here is the situation:
Our customers have a customer Type (number). Each Item has an Item Type
(number). Using a matrix to look up the customer type and the item type tells

I have a dilema. . .
I have a task tracking database that users enter data regarding a task they
are beginning and dependent on the type of task they are entering, they will
enter details of that task into separate tables.  When they are done with

How do I delete undesired characters from a text box and then check the
length of the resulting string when the user moves the focus to another
control? For example, if only numbers are desired in the output, the user
should be able to type

I have 4 fields and a button to click in order to change the values of all
four fields.
The four fields are as follows.
ser

I've got a form that only my managers have access to (suposedly).  The form
displays a record for each of our guys in our department.  Each of our guys
can login and update their own record using another form with limited
capabilities.  I want my managers to click a button that ...

I have an Access 2000 database.
I have a Parent table and a Child table.
The Parent table's key is LeadID - which is an autonumber field.
The Child table has a foreign key of LeadID - long Integer - Indexed but

I have a subform with this code:
Private Sub Form_Error(DataErr As Integer, Response As Integer)
   Select Case DataErr
       Case 3022

I hae an issue that's got me pulling my hair out. I have a form, based on a
one-table query (it's being used to filter for specific projects in the
table). I added a second table to that query (no join, as one is a lookup
table of sorts, listing scores and text translations of ...