Hi I have a validation on a form with the following code:
Dim Myctl As Control
   For Each Myctl In Me.Controls
       Select Case Myctl.ControlType

Hello, this is just a user ease problem, not  life or death, but here it is:
I have a command button on my form to delete a record.
Access brings up a warning asking the user if he really wants to delete the
record yes or no.

I'm having problems with broken/missing references when different
computers on the network open up an Access 2000 application(s).

remedy broken references.

Private Sub txtCallerName_KeyPress(KeyAscii As Integer)
On Error GoTo Err_txtCallerName_KeyPress
   Select Case KeyAscii
   '65-90 are caps 97-122 are lower case; tab (9) and backspace (8) okay

after running a query from a form, by using a command button, is it possible
to return the result of the query to a textbox in the same form?
eg....in the form i need to enter the Qty then run a query to calculate the
TotalCosts. I want to show the TotalCost in a Textbox in the ...

I have a form that has a combo box on it.  The combo box selects a
developer's name from a table named tbl-developer.  I'm trying to pass off
that name into the criteria of a query to filter only the projects of that
developer.  The form's name is frmByDeveloper and the field's ...

I have a label on Form A with an onClick method that opens a new form (form B)
with the following code:
   stDocName = "frmdocument_review_referral"
   MsgBox "doc_review_id = " & Me![doc_review_id]

Excuse my ignorance but I am trying to get a button to send a certain email
and have done this by using
"Dim sendto as string, mysubject as string, mymessage as string.....etc
but my message seems to be too long for one line of coding.  How do i get it

I've been told that a certain important field is too easily changed.  I'd
like to use a toggle button to set the "Locked" value of the field.  If the
toggle is pressed in, then the field is unlocked.  If the toggle is pressed
again to deselect it, the field is locked.

I am launching a word "serial letter" from access. The new document is
created correctly. When I try to close the template document (which is
write protected) using
objWord.close wdDoNotSaveChanges

I have a continuous subform that lists the numerous stages of a process.  The
form is sorted in descending order on a seqence number field.    I would like
the blank new record to appear at the top of the list rather than at the
bottom.  Any suggestions.

Help!  I am trying to put an address finder (from postcodes - PAF) on to my
acess database. How do I go about this?  Any suggestions?

I have a bunch of checkboxes to include certain things in a calculation by
default.  Others can be added by clicking other checkboxes.  What I want is
for the checkboxes (and everything else) to return to their original state
when the form is closed.  I used this:

I'm familiar with the Left (and Right and Mid) commands, but my brain
evidently isn't firing on all cylinders today.  My code is inside an
On_Click event for a command button and the value is returning the same as
the main string.  txtNumber is bound to Number which is always a 5 ...

i like to add a command button to my database that when clicked, it creates a
backup or compact  the data base and then closes the database,