I have a form with several combo boxes on it, the last of which allows the
user to type in new data.  Depending on the contents of all of the combo
boxes, a routine executed in the before_update event enables or disables a
command button.  The users don't learn to tab off of the ...

I need to set a command button's visibility to
FALSE when it receives the focus. So, I first
need to move the focus to some innocuous
control, most desirably the form itself. I've

If user enters an InmateId value and a ClassDate (a unique index) that
already exits in the table, I want to undo what the user punched in and go
find the record they tried to duplicate. A button click is called that fires
two SendKeys "{ESC}", which undoes everything on the form ...

I'm new to Access and VBA. (I've been working with Pick/Universe forever.)
I'm about going nuts trying to figure out something that should be (and most
likely is) very simple.
I have a form that reads and writes data from/to a table (call it

I have a serie of values like:
Month    Value
1    100
2    200

Hi to everyone,
on the KeyDown Event of my form I have that:
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
   If KeyCode = vbKeyTab Then

Hello Newsgroup.  I have a dilemma regarding referencing a subform to a
subform in an expression.  Below is the expression and it is not working
properly.  This expression is in a textbox on a subform that needs to count
how many comments there are based on the other subform ...

Hi. I am able to loop through my records and create an email, EXCEPT I'm not
limiting my email addresses based on one of the parameters.
I have Contacts that hold Licenses. I want to send an email to all Contacts
(that are in good standing) and have a current license as stated in ...

I am developing an application using an ms access front end and a
visual foxpro 8 backend. The application uses adodb connections to add/
update/edit data in the back end database.  When a user clicks the
save button on main data capture form the user input is

Access97
I have a form for spare parts information and selection.
For the parts I have a library of jpg files held in a shared drive.
When the operator selects a part number in a list I have the image

I get an Object Required error when I attempt to run this command from a
button on a subform.
Private Sub Command15_Click()
On Error GoTo Err_Command15_Click

i wish to find a record based on 2 criteria, in this case i wish to search
for a particular job id and then date type as each job id could have a
multiple amount of date types.
rs.Findfirst "[Job ID] = " & aJob  AND "[Date Type] = " &aDate

I know that when you open or load a form you can put the following:
DoCmd.GoToRecord , , acNewRec
to create a new record so that the bound form does not retrieve the
1st record in the table .  But here is my dilemma.  I have a bound

I have a table with a list of several hundred reports that I want to import
from another mdb that has say, 1,000 reports. I'm using
DoCmd.TransferDatabase, acImport,.....
I have a procedure that loops through the table importing each report -

tabControlReservations contains Jobfrm, which in turn contains
tabControlInvoice.  When my user clicks tabControlReservations tab 2
(value=1) I want to ensure that tabControlInvoice is set to its first tab
(value=0).