I have three tables - one for personnel records, one for comp time earned and
one for comp time used. I created two subforms out of the comp time earned
and used and place them on a form. The two subforms shows whats in the tables
but what I want to do is add a combo box to the ...

I have a form which only purpose is to show the result of a query (just some
form fields). This information is to be protected (read only); however I
would like to make a certain field active in order the user to double click
and to open the respective form.

When I am creating a form and click on the command button, I do not access
the wizard.  Is there an option which must be set to access it ? In addition
there are other wizards mentioned in the Help which do not seem available.  I
have installed access through Microsoft Office ...

I have a form with a tab control where the pages contain subforms.
When I click on a tab, if any controls are near or partially below the
bottom of the screen, the tabs (with the page names) fold up under the form
header. How can I stop this?

Using Allen Browne's 'not in table' method to add details to another table
and keep getting this error message:
error 3421: Data type conversion
I would assume from this message that the value is the wrong data type, but

When I am running Spellchecker, I can't add words to the Dictionary as the
ADD command is greyed out.  I used to be able to do it.

I am working with MS Access 2002 SP3
I have a lookup field in a table.  It is a value list with 2 columns. The
value list is 1;regional;2;Sub-regional;3;local.
I have an option group on a form which stores 1,2 or 3 in this field.

I created a form with two subforms on it and a combo box to search the
records.
If I select a name in the combo box and minimize the form and then open each
of the subforms they return the proper info.  But when I open the form with

I want to use a form to populate an adjustments table.  But, I need to enter
multiple records at once, so that the net sum of a certain numerical field in
the  adjustments will be $0, and all entered records will be populated to the
table and the form reset to blank on the save ...

While executing a VB script in Access 2003 I would like to "pop up a dialog
to get some user input" and then proceed with the script.
As far as I can figure out, VB Access does not support dialogs as such but
rather I build a Form that contains the various UI elements that I would ...

I have a subform in datasheet view with field "x" on it... and on some
event I can hide or unhide it... like this.
Me.Table1_subform.Form("x").ColumnHidden = False
But, I can't see a way to get a collection of the field names from the

I'm trying to get a cascading combo box in my subform to tie to a combo box
in my parent form.  What am I missing???
Private Sub cboSupply()
   On Error Resume Next

I have a combo box tied to a table.  The table is in alphabetical order but
the combo box is not.  How can I get the text in the "pull down" to be in
alphabetical order?

I built a very exhaustive database a few months ago and it has worked fine.  
Today I went into it trying to pull reports and view some data in forms.  I
was devasted to learn that none of my forms will display and most of my forms
won't due to 3 subforms that will not display.  ...

I have a combo box (Name= Combo482) on my form with a Control Source to
ComplainantAnonymous. You can pick 'Yes' or 'No' from the drop down
menu.
If someone selects 'Yes', I want the following Text Fields ( Name,