I have created an Access 2000 (all office patches are setup) application
(MDE + MDB file)
which is run through an Internet VPN.
The application uses SQL wherever possible, to eliminate the full data

I have a form with a tab control and three pages (tabs) under that control.
Each page has a subform on it.
What I'm trying to do is check all the controls located on the subform on
page 2 for any changes (dirty) when I click on another tab (page).

I'm triyng to fild checkoudDate and InOrOut field but I can't because
everytime that the CheckoutID is empty keep filling out the other two.  my ?
is if the field is empty is suppose to leave empty the other two.
Private Sub CheckoutID_AfterUpdate()

I have a table that describes different tour promotions at a resort.  The
primary key is made up of a Keycode and a Promocode.  Other columns include
Source, Program, and Company, Price, and Premium.
I am trying to make a form that uses two combo boxes to choose the primary

Morning,
I've been hacking away at this for a week now and am just not getting
anywhere!  Some help would be greatly appreciated..
I have a form (P_Test) with a subform (P_Fault)

  I'm a little stuck with the syntax for this one. it used to be something
simple like cmd.cls or something which cleared everything in text boxes on
the selected form. Anyway, what I have is a Database for Equipment so I know
what's being taken out and the user selects the item ...

HI TWIMC
I have two combo boxes that hold employee id and role id, both of which are
a part of the PRIMARY KEY for their table. The problem is that when a user
selects an employee name from the combo box and decides to delete the

I have the following code.  I would like to write code to loop through Step1
until the conditions have been met.  Once those condition have been met I
would like to do the same for Step2 if the code passes on to that level
instead of going directly to Step3.    How do I code this ...

Hi I have a form called Incident Data which records all the details of our
claims, is it possible when updating the field "Bodyshop", the on lost focus
event function searches for any other claims that are still open with a
matching Registation Number.  The search would be carried ...

I have a grid on form 1. I have detail records for the same table on form 2.
I want to doubleclick the row on Form 1 and carry forward the ssnumber to
Form 2, populate the combo box, refresh the combo to select the employee
that i clicked on in form 1.

Hey guys:
I have this application which is supposed to swap sub-forms, if I just drop
the sub-forms on the parent's form control, then, things swap out fine. The
moment I link the sub-form (child) to the parent (main form) via the child

Code not working any ideas? Form will not load selected table when choosing
team name.
E and d clients are tables.
Dim teamX as string

I am working on the application which has a number of sub-form being swapped
out during data entry. The object control name is: "fra_Embed_fsub_Dataforms"
and here is a sample of the code behind the toggle buttons doing the swapping:
Select Case Me![fraSwapForms]

Is is possible to specify in VBA that I want the form to print in Landscape
orientation?  The following is the code generated by Access when I used the
wizard to create a button to print the form.  Thanks.  Matt
Private Sub cmdPrint_Click()

I need help on this urgently. I have synchonized combo boxes on a form,
which show the value, and when submitted, the ID of the value gets
captured. How do I create a query which will display the values
instead?