I am using a tag on controls to flag certain controls for certain
programmatic manipulation.
I need manipulate others groups of controls, some already have tags set.
Is there another way to tag controls so I can have two independent sets of

Is it possible to use and update query to edit a field in a table
based on a combobox value selected on a  form?  The specifics of what
I'm trying to accomplish are...
I want the user to be able to make a selection from a combobox and

I want to build and event procedure in Close Form that says if field A is
null, don't close the form.
If IsNull(FieldA) then
MsgBox "Field A is Not Complete"

In A2K, I have a form with two calendar controls.  One for a start date, one
for an end date - both have text boxes that get the dates clicked - TxtBegin
and TxtEnd.  I have three buttons that hit nearly identical queries (same
fields but present differing data) for the three ...

I have an unbound text box on a form, that needs the following code to be run:
SELECT Count (*) AS NewTotal
FROM tblIssues
WHERE Risk = True

Hi Everyone,
I have the following code to message the user to enter in an employee's name
if the user forgot to.
Private Sub txtEmpName_Exit(Cancel As Integer)

I have a simple line to put a date into a table using a form.  The tables
have an average of 300,000 records in them and to put in a pre-determined
date I just run:
Private Sub ID_GotFocus()

I have a combo Box on a form the CB row source is a table with about 50 codes
and a text field that holds a text description of what the code means. This
CB is used to select an agency code that corresponnds to the agency name.
This avoid any data entry error. Now the problem. ...

I'm getting a type mismatch 13 on this first if line and have tried several
things but can't see what is missing.  The test is to see if first column of
combo box equals Name1 or Name2 then made controls not visible.  CustomerName
is a text string.

I have a command button with the code below. The problem I have is that when
I first open the form, the me.recordset.recordcount = 1 (no matter how many
records I have.) I have tried using the movelast, movefirst to get the
recordcount to accurately reflect the number of records, ...

I have a Purchase Order form with a LineItems subform (record sources are a
main PO table and a LineItems child table).  The line items are selected
from a combo box based on a products table (tblPO_Product).  The information
includes ProductCode, ProductDescription, Unit (Each, ...

I have a simple form for updating records. I do a DoCmd.Openform with a
WHERE clause that works great when there is a record that matches the WHERE
clause.  The form opens populated with data from the record.  My problem is
when the User keys in wrong information and no record is ...

I would like to have a form check the current drive, then check if the
linked tables are linked to the same drive letter and change the
background color if the application is not being used on the server.
I wrote the following code, got it to work , but it broke now. I don't

Hai
iam trying to develop a database for a flying club.
i have a form which enables users to enter their flight details called
LogFlight

When a user enter letters in a numeric field, and attempt to move out of the
field, MS Access displays a warning the "Value is not valid for the field."
Is there a way to not display that message and instead display a different
custom message