I've inherited a database that has about 9 tabs and multiple
forms/subforms per tab.  I'm new to forms in Access and was wondering
how to determine what query a particular form is based on?
Thanks

I have created small application with few forms and reports. My tables are
on SQL server and I am liniking these tables in my ACCESS application. How
can I prevent all users to make changes directly on tables?
I tried to setup login form at startup and can't bypass the login form, ...

I have been using Access 2003 on WinXP  (SP1) for a while now and am
continually having problems with multitasking.
When I switch from Access to aother appp and then switch back there is a 2-3
delay for the screen to refresh. Sometimes the desktop will display within

Im re doing our chemical register and want to 'clear' all the old data that
has been entered over the years and start again, I want to use the old
database though.
Can you tell me how to go about doing this?

I'm doing a traineeship and for my certificate i need to complete Microsoft
access as a subject but my text book is not very informative, one of the
questions request that I print out one of the reports I have created in
columnar and tabular format. the help option does not tell ...

Hello group, I am using continuous forms to record childrens details; Age
and name.  I require the childs name if they are over 17 but do not if they
are below.
When I use continuous forms I can enable/disable the name when the age is

In my Access 2003 toolbars I have only the print icon that
immediately starts the print job. I would like the one that
triggers the same options window as when you hit File/Print,
or Ctrl+P. That way you get to choose the various options

I need to format the following telephone input mask
(123)    -   to be displayed  in a control. The  cursor
must be ready for input after ")". The user must be able
to use the left arrow to edit the contents (123)  (or the

I have a "Last Update Made On" field which is an input the
user has to enter whenever any changes or entries are made
to any field in the record.
Is there a way to have the date automatically change to

I've got two tables so far.  One for categories and category types, and
then one with a product list.
In the product list table, I have a category field and I want to have a
listbox for categories come up as products are entered.  For example, the

I just became Personnel Manager in our rural, small school district and want
to create a data base to track support personnel information such as name,
date of medical, criminal record check results, etc. employment date,
contract date, position.  I have never created a data base ...

How do I show leading zeros in access tables?
eg "0-004-3" shows as " -  4-3" using the mask "0-000-0"

To all the wise ones,
I have just started understanding access and VB. As an
exercise, I want to be able to access the fields of a
table created in my database. I have created a form with

I ann using Access 2003 and have a table in datasheet view and want to
change the background colour of selected rows, I guess in a similar way to
the functionality Excel has. When I try to do this (using "datasheet
formatting" from the format menu) this changes the background ...

I have what might be a simple question:  I have a table
with a field that is a memo datatype.  The table is
displayed as a subform on my main form, and lists the
records in datasheet view.  Some records are long