I have a CmdButton on a form that I need to be enabled based on data
that is already listed in a combo box.
I need the Command Button: TimeSheetButton to be enabled when the data
in my Combo Box: TypeID reads either "HOURLY" or "NON-EXEMPT" and

I have a form that has a command button to add a complaint. You can only have
3 complaints. I have a query that counts the complaints.  I would like to
display a message in the event that the user tries to add a 4th complaint.
How would I do this using this count query? The form ...

Hi. I had a field on a form.  I deleted the field on the form, then deleted
the field in the table.  I've also cleaned up any code reference to that
field.  Then I compacted and repaired.  But, every time I open the form or
try to navigate to the next record, Access asks me (3 ...

Hello!  I have a form with a combo box called District Name.  The combo box
has two columns:  District Name and Area Education Agency Name.  I want to
fix it so that when the District name is chosen or typed in the combox box,
the corresponding Area Education Agency will appear ...

I'm looking to update row(s) in child subform (decreasing a count field by
1), when 'save' button clicked on Parent form.
What might be best strategy?
Thanks!

Hi,
My company uses Access 97. I need to make a database that uses three Many to
One relationships on four tables. I tried to make a form that had a main form
with a subform, with a nested subform, and a nested subform, and a nested

I have a DB setup that keeps track of 4 things. Customer, Legal, Date, and
Margin. Depending on the type of form the user requires all data is run
through on query, or another. The problem I am having is that say they run a
query that pulls up 4 entries. I need on the form 4 ...

On a subform I am using a query to list item for a combo box.  for that
record on the subform once i check it off as not available(yes/no) field  I
would like it to not be avaialbale for the next record in the subform.  When
I go out and open the query( with the criteria in the ...

I have a listbox lst1 which contains field values of tbl1
I have txtsearch1 and txtsearch2 textboxes
How do I only enable txtsearch2 when the field data type chosen in lst1 is a
time/date type.

I have an access database with serves as a catalog with the picture of
each catalogued item.
I have a form that enables me to view each item along with it's
information (Item number, description, picture and price). On that

Database
I am designing a database which basically consists of a set of questions
that are fixed
And answer that will change for each client.

I have a form I'd like to use to search for and delete a record.  But, the
record will not delete.  I've gone back to the underlying query and it allows
me to delete the record.  But, not once I get to the form.  Any Idea what I
need to do to get this to work?

I am new to Access 2003
Many years ago, I created a quote database, for our Sales Dept, with a
startup screen that is a menu to enter data. do reports and etc.  But now I
am trying to create a 2nd menu that only the VP can use.  I created a 2nd

I've created a frmMainForm with an embedded sbfSubForm.  I have set the
fields for the underlying tables as "Required".  Therefore, if frmMainForm
is closed without all the fields being filled in, an error message is
triggered.  This works fine if the main form is closed using the ...

Dear All..
I m working on editor based application.
For the 'mail merge'  functionality.. I need to connect the Access
Database.. Following are the steps for that..