I am doing a Contacts db. All contacts are grouped into their respective
category, ie. Supplier, Purchaser, etc. I would like to let user search for
Category from a combo box cbxSearchCat in a Search form (eg. only show
Supplier contacts).

Is it better to use a single table and have one of the fields (for the form)
lookup via a combo a state for example or;
use a query for the form and then link both tables together so  that the
state can be looked up this way?

Have a field (column) in a query, and I need to have the total of that
field be a "Grand Total" (report footer) in a report.

I have a form with multiple tab forms in the detail section. Somehow :) when
I created the form the form width property got set at 22". I have tried
everything I know and can not get the width to change. If I cange it in the
form property, header property or detail property, when ...

i would like to make a form that can not be closed or minimised.
BUT the form will be maximised to full screen. so even when i set the MinMax
Buutons to None the restore button is still visible and can used to minimise
the form.

I have a form/subform setup.  One-to-Many relationship.
The source object of the subform is initially set to nothing (blank).
I have a command button that on click opens the subform (i.e., set the
source object to the subform).

Thanks in advance for any advice you can give me on this...
I have a problem with users trying to find records (using a single form
view):  they always seem to "forget" to click find or ctrl+F before entering
their criteria, therefore they are overwriting existing records.  The ...

I am trying to build a form using 2 tables in a 1 to many relationship as
follows :-
table 1 - code and name
table 2 - id, code(PK), start and end date

Can anyone help me with the following Chart Problem?
I am inserting a chart based on a query that I build. If I put the company
code into the query and then insert my chart into my form everything works
fine. However, I would like the chart to be dynamic.

Access 2000.  I have a table with 3 fields indexed to prevent duplicates.
How do I get rid of the generic warning stating "Duplicate keys" etc.  and
replace it with a custom warning of my choosing?..Thanks

I have a table "Student" containing student info like ID, names and
addresses.  I also have a table "Student Record" which keeps track of grades
and other info.  
I created a form for people to input the info into the table "Student

I just made a form and I can't get any of the changes to take.  If I open it
in design view and so much as change a letter in a text box and then change
it back, then try to close it, and answer "yes" to whether I want to save
the changes, that window disappears and the form is ...

I have just started setting up a database and I have a command button on data
entry form. When I tried to set up the expression for it all seems fine but I
get an error message when I try to run. It says there is a syntax error
(missing operator) in query expression 'Data ...

Essentially what I have is two main forms based on two main tables both
having a unique "Case ID" field, linked on a one-to-one relationship. I split
the table because when I created the form it returned an Access message
saying something like "your data will be truncated...". So ...

I have controls in all 3 sections and want the users to be able to tab
through all 3 sections without having to use the mouse, currently it just
moves through 1 section and then starts back at the first control in that
section.  This form isn't used for data entry, but for records ...