I would like to know how I stop users putting a dash between a number
I have a big database that requires users to enter a ID no such as 123896521
and some cannot help them selves and enter 123-563-985 etc. The filed is a
text field because sometimes it has a letter at the star.

The following code to change the color of the text is working
Private Sub cboClassification_AfterUpdate()
Select Case cboClassification.Value
   Case 6

How do I get the calling form to close after the user previews the
report.   Thanks in advance.
I tried adding a docmd.close acform on the report's close event, but
it didn't work.

I have the following SQL to insert into a table:
strSQL = "INSERT INTO log " & "(origin, to, mobile, result) " & "VALUES(" &
"Mobile List" & ", " & firstname & " " & lastname & ", " & Mobile & ", " &
getresponse & ")"

From the main menu, I have a Max query that displays the most recent
date of a particular field.  When I go into a form off of the main
menu and update that field, I'd like the main menu to be updated.  The
code below does not work.  Any help is appreciated.

I have a query that has a field that for some records it's blank while
others it has information. Is there away to pull the records that have
information in it so for example:
1

I am trying to add items to a Access combo box programatically as follows:
' Load the drop down
With cbTechnique
   .AddItem "Orders by Customer (refresh method)"

I have a form where a user would input data into and logs that data
into many different tables. I would like to have the form default in
read only view where that user can't make any changes but only look at
the data, I'd like to add a button called "UPDATE" where the form text

I've declared 20 Public variables in the Declaration section of a
General module:
Public gCF1 as Double, gAFa as Double, etc.
These variables will contain values that are used in subsequent

I have a form I've made for recording defects on parts we make. This
runs on a touch screen, and the user pushes a cmdbutton that inserts
the text into Text Box. (using a setvalue macro) well, it has come
time for us to have multiple defects per part, but the way I have it

I'm trying to save a record and than stay on that same record. Below is my
code which saves the record but moves to a new record instead of staying on
the record which was changed or added. The vbNo works OK. Help would be much
appreciated. Thanks, Jani

Hi,
How can we convert this code become a BETWEEN function:
(Rs_Cum1.Fields("Site").Value >= 18 And Rs_Cum1.Fields("site").Value <= 24)
Thanks you,

I have a spin button to use for increase a value in text box by decimal.
The minimum increase is one.
I need synchronize the value user enter.
I have

I have this excel code
Dim objExcel As Object
Select Case Me!List1
       Case "Supply Flour"

I have a list of 20 different items that have checkboxes that need to be
clicked for them to be included on a list.  I want to be able to click a
master checkbox and have all 20 different items have their checkboxes clicked
and be included on the list.  Any ideas?