This must be quite a common problem but I can't find a solution so any help
greatly appreciated...
I have some detailed validation code in a main form's Before Update event.  
Half way through entering a new record into the form, the user must enter

I have a form that contains a subform that has a subform in it, how do I
reference the child's child for from the main form?   The reason for this is
that I am using Stephen Lebans RecordNavigationButtons code from his site,
which by the way is very usefull.  So in the first ...

I created a button to email report.
I would like to add massege in the mail body. I know I can put it in the
code, but it's quite long and I want the user to change it as he see fit.
Is there a way o do it, or the code is the only way?

Access 2000 - I have created a form containing a subform which allows the
user to select a drop down menu to populate the first field, on selecting the
value I would like to be able to automatically populate another field in the
same record with a value from the same row of the ...

I want to run some queries at the same time each day (6:00 AM and then at
600PM). Is there something better then using a timer event?  Is there a
trigger that can be used that will run as soon as it hits the 6:00 hour?  I
hate to have to use a timer event and check every minute ...

I have a form with a combobox used to select employees who did something.  
Over time, my employees table (and thus the combobox used to select an
employee) has gotten rather cluttered.
Is there a way I can hide the records in the Employees table from the

I use some controls and code, such as custom navigation buttons and
associated code, over and over.  I have seen the recommendation to use a
standard module for such things, but am not sure I am implementing it
properly.  To use a simple example, the code to go to the next record ...

I would like to use numbers for input on forms to speed up data entry, for
instance:
1- positive
2- negative

I've created a form on which there is a button that when I click it a series
of queries are run.  I keep getting this annoying "Microsoft Access" Message
after all my codes run that says:
"You can't move to a previous control when only one control has had the

I am getting a run time error when I am on a form.  It says Runtime error
2001 - and then some text about canceling the previous action.  When I click
on the Debug button, it highlights the following code:
Current_Vendor_Count = DCount("*", "tbl_Vendor", "(tbl_Zip_Code.Zip_Code =

I have a One to Many Form used in  a checking account application that works
as designed. The subform transaction table is named called tblTransactions
and the form name is sfrmTblTransactions.
In addition to the Main and Subform described above, I also have a 2nd

I have created a form (parent table) that also displays a subform (child
table).  The child table is void of records at the moment but the parent
table has records.  First I find a record in the parent table through the
form and then attempt to put a record in through the sub ...

I have a form that contains a ComboBox control, which displays the
following information:
    Project Description
    Project Code

I'm wondering if I can use controltips on a subform in datasheet view.  I can
set the text but I'm not seeing the tip pop up.  The statusbar text property
works fine.
Am I missing something simple here?  I've been searching this one to no

Reworking a previous entry:
I have a cmdbutton in a form with the following code:  This appears to work
except an error occurs if the same name of an existing query is input into
the InputBox more than twice.