I have a form bound to a table.  When entries are made to the form, I
want
only values that are multiples of 5 input into the table.  Anything
that is

I have a checkbox on my form called ActiveCheck that I want to be checked if
the information has not expired. I have a textbox with a short date that is
an expiration date for the record.
What I want is for the database to compare the current date to the

I have struggled tremedously with setting a default value on a data
entry form. I keep running into road blocks. I do not think that I am
taking the right approach - I need advice from the experts on how to
handle the situation. The scenario is: A user is entering a set of

I have a combo in which to select "DestCountry". There are about 20 of these.
Then there's another control that shows the "Price Band". That's also a combo
with 5 different values to choose from (1-5).
I wanted to code the AfterUpdate event on the DestCountry control, so that

Ms access 2003. I am trying to store the radio selection to db where 1 (Yes)
and 2(No) into db instead of 1 or 2. On my table, a field call "commPaid"
with data type "text". On my form, i using wizard to create group option. the
Label"lblCommPaid", the whole group "OptCommPaid", ...

I am using Access 2002 sp3.
I have a combo box that is used on a form whose control source is a query.  
The query has an image field in it that containes a picture of the item to
select.  I would like to display this image in an unbound OLE field as the

In my Form_BeforeUpdate I have the following code:
If MsgBox("Save changes?", vbQuestion + vbYesNo) = vbNo Then
  Cancel = True
  Me.Undo

Hi, I'm running Office 2002 SP3 and am having trouble with running VBA code
contained in a access database made in Office 2003 SP3. My references are:
http://img339.imageshack.us/img339/9433/referencesneededtk9.gif but the
version numbers do not match the known working references ...

I have two tables: Table1 has the following fields: TASKID, ISSUE, ACTION;
Table2 has the fields TASKID, STARTTIME, ENDTIME (reason I don't have the
STARTTIME/ENDTIME on first table is due to multiple users updating the TASKID)
.

On my form I have a field that is a Combo Box (1,2,3,None) If None is not
picked I want another field (Estimated Total Field Hours) to be required.
Fairly new user.
Thanks in advance!

I'm getting an error code 3346, "Number of query values and destination
fields are not the same" when I attempt to run the following code
strNUMBER = Me.Number.Value
strAY = "07/08"

Another issue today... How do I code this type of thing... Two fields, first
field one makes a text selection from a list; second field, one would fill in
a number (this field defaults to 0). I want to make sure that someone does
not fill in a number >0 in field 2 if they have ...

You may have seen my posts before but here we go again:
Ive got 13 combo's ( rig name, owner, world region, rig heading, etc.) and
one table ( MODU ) on one form ( MODU-Form ).
Still can go straight through all them, in order, having each combo filter

I have a form that is running a command button to print an invoice.  For some
reason, I am getting no data, even though I think I am passing the date
correctly.  Here is my coding:
Private Sub cmdPrintInvoices_Click()

How do I determine if a form has been opened in read ony mode.
ie.  If frmExample "Is opened as read only" then
     do whatever
     Else