I want to show records from different tables on the Main form based on the
selection from a ComboBox.  There are at  least 2 sub-forms to show different
data from different tables.  I want the sub-forms to show only the data based
on the selected value of the  combobox.  How can ...

I have basically an Employee_Calendar table  which has 4 shifts per day x
365 days per employee.
A snippet of the table looks like:
EMPL /    DATE   / SHIFT / STATUS

I would like to communicate between two forms.  For example, if I
add/change/delete a record in the Employee form, I would like to ensure that
a list on the Find form is update to reflect this action.  While I don't
have other forms that need to be notified, I would like to ...

I have a form that everyone enters data into. I have allowed the date field
to have duplicates because we all enter data in for the same days. My
question is can I put something in the code that will still allow the
duplicates for the date field but will have a limit of one a day ...

Hello All;
I would like to stop a user from closing a form if they have not filled in
certain fields under certain circumstances.
How can I stop the form from closing if my test parameters are not met?

This will probably sound rather dumb, but I'm having a problem getting a form
to open to a specific record.
I do a search based on a query and the query returns the record(s) to a
form.  I have a command button to open the selected record, but instead it

Basicly i have a MainFrm and a ReportFrm, The user clicks on a button and
the ReportFrm comes up. well since the reportFrm is long, the user scrolls
down and there is a Close button at the bottom of the form, so when they
click Close, i want it to focus back onto the MainFrm.

hello, I have a form that I use to filter the employee database. I can then
click 'delete user' and another modal form will popup asking for the
termination date.  Once I enter the date I click 'OK' and it deletes the
record just fine, only I want to remove the filter from the ...

I am trying to replicate the employee form from Northwind, but cannot get the
'Add Photo' button to work.  When I click on the Add Photo button I get an
error message like 'Compile error and variable not defined.' and the
following code is highlighted.  I have copied the entire ...

I'm having a problem with the "NotInList" coding.  I have  a combo box that
lists "Department Contacts", but when I try to input a new contact, I get a
"Run Time Error 2113...Value entered isn't valid for the field".  I'm using
Access 2003 and here is my code.  

I have code that assigns a primary key field in a particular format.  The
primary key is the report number (report in the generic sense, that is, not
an Access object) in the format RPT 05-01, RPT 05-02, and so forth.  That is
fine, as long as there is only one user.  While ...

Hi. Im using Access 2002 on XP.
Can anyone help me modify the following code? Its part of a set of On Click
code associated with a forms command button and is intended to identify a set
of records where the SchoolID field has the same value as the record being

I have used Allen's sort code in my application and it works great...except
for one thing I can't figure out how to deal with.
Alot of my table fields are look-ups o other tables. For instance TableA has
EmployeeID, which has a relationship with TableEmployees, where the person's

Using Access 2002 we have a form containg a 6 page tab control.
When the user clicks an edit button they are taken  to the 3rd page of that
control. That control has 18 unbound text boxes.
What is best practise to clear those 18 text boxes when that tab page

I have a message box that pops up on the screen in the occurance of a certain
event. The message box has two buttons YES and NO. I want when the user
clicks on NO to set the focus on a field in the form and when clicking on YES
to close the form. How to assign this to the 2 ...