I have developed a form, based on a query and set it to datasheet view mode.
What I'd like to do is use the form to search through records and then be
able to select a particular record by double-clicking within it, upon which
the clicked record will open in form view and the ...

I want to have a combo box on my form that allows the user to enter data that
is not an item in the value list, and where the combo box has as its value
list, all the different values in a field. (The purpose being to minimize
entry error, as in misspellings, etc. so that a ...

I have a form that has an "On Open" event and the problem with the event is
that when the form is opened with DataMode=acFormEdit I get a run-time error
'2448':  "You can't assign a value to this object".  The "On Open" Event
works fine with DataMode=acFormAdd.

I have a form for change/ update requests. When the user fills in the form,
the data goes into a table. I don't wish for the table to grow as it takes up
weight.
I would like the table's contents to be removed either when users exit from

I have a combo box that lists an item type such as Frame.
The second combo box lists the issue category such as cosmetic
Based on these two critera I would like the issue type pull from the
FrameCosmetic table list.

Hiya folks!
Heres the problem:
I have three tables.  The first table is related to second table (one-
to-many) and the second table is related to the third table (one-to-

I have a form Customer Order with an item number combo box that looks up the
item numbers on an item master table.  The Item description is basically a
text box =ItemNumber.column(2) which populates the item description when the
item number is selected.  What I would like to know ...

I am trying to insert a new record to the table, but if the Contract_No
(primary Key) of the record i'm trying to insert was similar to another one
that is already in the table, I recieve an error msg.. how can I show a
msgbox "There was a contract with the same No., please ...

In my database I have two tables:
T-Personnel Data and T-Annual Training used to track how many days my
guardsmen deploy each year.
I created a form F-Annual Training Summary that has the following fields:

The below Sub returns 2 columns and 3 records. The open shows Recs = 3. The
If statement to move through the recordset returns the name in the first
row but does not move through the next 2 rows. Evidently it thinks it is
EOF and quits. I tried Not .EOF, but it also only returned ...

I have a tiny bit of self taught knowledge using our Access 2003 but
I'm stumped on how to carry out some needed changes to our database.
I'll try not to be to wordy and I don't have Access here so some of my
explanations are from memory. These groups have been really helpful in

My main form is called "MRA Form_JPS" and has a child sub-form called
"subfrm_Aneurism". When the value of a control on the subform called
"Aneurism" reaches more than 4, I want the backcolor of a label called
"Label113" on the main form to go vbred, so I coded the following ...

I have a form with two subforms that was working fine until a few
hours ago. Now, when I open up the form, I get this error message
every time I open it, try to move to a new record, or do anything else
besides scroll through the subforms:

I need to run an Access query (2003) from VBA and put the result (one row,
one column) into a local variable. I have tried a public defining
pstcorpname as a string, acresult, acdataobject, and so on. I have tried

I have a question regarding the state of a form:
I have a form with a subform in DS view, and when I enter data in the main
form then I cannot edit anything in the subform.
If I empty completely the main form, then my subform becomes available for