I'm working with an inherited Access DB with 5-10 concurrent users.
There is no backend and it sits in a folder on a file server.  It has
bound forms (opened with where clause), and access security.  A remote
user "crashed the db and corrupted a record".  After deleting the

I open a Main form in Normal mode.  A button on the form opens a Pop up form
in Dialog mode.  The Pop up and Modal properties are set to yes for the Pop
up form.  Most of the time it works fine, but once in awhile the Pop up form
ends up behind the Main form.  Does anyone have ...

I am creating a tabbed form and when I open the form, I can see the first tab
with no problem, but when I click on the second tab, the subform enlarges to
full screen and I can't return to the 1st form.  I switched the forms from 1
to 2 to 2 to 1 and it still happened.  Any ...

What I have is the following tables
products
order details
orders

On our Install Order form, if user changes value of combo box OrderStatus
(with row source of a list table), when the user then tries to go to another
record, it displays "The search key was not found in any record."
It only happens in certain records, and it happens fairly ...

Is there any way to put a check box next to each item in a combo box?
I am assuming I would have to somehow do it in the query, but I'm not
sure what it would entail.  The combo box is located on a form and is
used to filter a subform, the value of which is the criteria for my

I have 3 different types of permission levels for my database, when a form
loads i want only certain tabs to show up depending on the permission level,
this is what i have so far which works strictly for "SUPER ADMIN", how do
tell the form if the permission level ="MANAGER" to ...

I have frmMain with frmSub1 (datasheet view) and frmSub2 (single view, set to
invisible). Both suforms are linked to the frmMain by the ClientID field and
have OrderID in their underlying queries.
I want to turn frmSub2 visible by double-clicking OrderDate-cell on frmSub1,

I wonder if there is a way to change the Fore/Background Color and Font of a
selected Item either in a Listbox or ComboBox.
At this moment the Backgound color of a selected item is black which I dont
like and I want to change it to another color.

I have a form that is actually a very simple form but recently the "new
record" Icon, the Add Record Button and the New Record icon on the ribbon are
not available.  The "Allow Additions" property is set to yes.  I get a dialog
box with "You can't go to the specified record."  It ...

Here is what I have:
1) I have a main form called frmInspectionReport_AddNew with a subform
called frmItemsChosen.
2) The subform is from a query called qryItemsChosen.

I have a text box on a form meant to be used to add a prefix string to a
particular field.  I noticed that no matter what I put in the box, it always
trimmed out any trailing spaces I may have typed in.  (Which is no problem, I
add back the space in the concatenation.)

i have made a table with students and their photo - ole object  ,bmp.
i would like to make a form and using their photo for selecting a value,
because i remember better their faces than their names. So when i select the
photo i can enter automatically the name .

I created a form and embedded two subforms. I can only input data into the
main form. I can't move or input any data into the subforms.

I have a form with 6 unbound text boxes that show various calculated values
(using DLookups etc.). The only problem is that the values are not
displaying when the form is first opened: the only way I can get them to
display is either to click on them, or to tab through them.