I have two forms displaying data from two related (one to many) tables. Form
1 displays data from table 1 (one) and form 2 from table 2 (many). I've used
the wizard to provide a button on form 1 to launch form 2 using the related
fields to provide the connection between the two ...

I have a form (employees).  It has tabs that show general employee info and
another tab that gives information concerning each employees uniform
allowance.  The uniform allowance information is organized into a table and
linked to the main employee table in a one to many ...

i would like to create my own switchboard, which should have mainpage,
2ndpage, 3rdpage and 4th page.
i am not expert in swithboard but i no some of the VBA codes. can u help me
please. i would be greatful if u give me the steps.

are there available in any versions of Access features that allow a user to
alter part of the text in a note field with some of the features of Word ie.
Bold underline font colour etc?. Poeple love to mess with text!!
Alternatively is it possible to change the font for all text ...

Okay I have a form whose caption is based on some information on the form.
The information updates the caption at every change.  For example the caption
at a new record will read "Background Analysis Database", however when there
is information entered for a specific record, the ...

i have some values to be added in a form but if one of the values is null the
"add" operation is not done at all even if the rest of the values are
available

I have cancellation form which have 4 fields to be filled. In the same form i
have added corresponding 4 fields which shows what's their value in invoice
form. (thru dlookup)
Also have added validation that 4 fields in cancellation cant be different

Can someone give me a start on this project?
I have about 5000 scanned and downloaded photos in folders in WindowsXP pro
and I want to use Access2003 to tag these with keywords, and then use a
query to select sets based on these keywords.

Am totally stuck up! There are 2 tables : 1 for invoice information and other
table with Cancellation information related to invoice table on doc no, as
cncl table would be used when an invoice issued needs to be cancelled.
I need report where when i give month range, total ...

Hello;
I have a subform with 4 different fields.
The value of the first field will determine the options that are available
in the last field.

the line jumps up over and over when I type data in lower one third of space
of 7 inches high column

It seems like this should be fairly straight forward but I can't get it quite
right.  I have a combo box that finds a record on the form based on what you
select (from the Combo Box Wizard).  This works perfectly.  However, if
someone types in a value that is not in the list I ...

Hi there everyone!  Using A02 on XP.  Not a programmer but learning VB and
loving it.
I have a form that is opened from the AutoExec MainForm.  I would like to
have the OnClick OpenForm event tell you that the form is already in use and

Hello experts!
I have created a database program that will be used by our clients.
It will be packaged using the developer tools with Access 2003.
What I forgot to take into consideration while I was designing the Main form

Hi Freinds,
I have an issue and hoping that anyone can help me. I have two forms 1)
frmSystem and
2)frmDelayReasons. frmSystem has a combo box RSN1 which has four