I am using the following code.  The code is programmed to pull a
mileage expense rate from a table called "ExpenseMileageRate" (the
fields are 'Rate' and 'EffectiveDate' and use it to calculate the
currency amount.  As the rate changes, I need the code to lookup the

I would like to create a form for inputing new records. The first field is
PartNumber.  If this PartNumber already exists in the InfoTbl (in the field
PartNumber) I then want a message box to appear that the number is already in
the database.  If there the number does not exist, ...

Thank you
How can I refer to (subform) from (subform) on the main form?
How can I refer to (subform) from (masterform)?
How can I refer to control on (master form) from (subform)?

access 2007
How can I cancel this message ? and display custom message
You can't save this record at this time
May have encountered an error while trying to save a record if you close

My access database stopped calculating the age of people for some reason.  
When it calculates, it shows the correct age (say 40) but in the format of
1940.  I am using the difference of the last time the person took a test vs.
their date of birth.  the code being used is:

I have an Access form that contains a subform.  the subform is connected to
an access table.  I need to have VBA (or I could use a query) to update the
access table.  However, the data shown in the form do not update.  checking
error messages in VBA, I discovered that the VBA ...

i will apologize in advance for asking again...
database set up:
table: classes available
        fields: class

I hesitate to ask this because it's in the manual somewhere, but since
I'm programming successfully in Visual Basic in Access without any
books (I do have a C#/C++.NET background), I'll ask:
In Access forms, how do you bind a control to another control?  I can

the end user needs to be able to type in the combo box if there selection is
not there, the information that is typed in needs to be saved to the combo
box for future use. How do I make this happen?

I’m sure this is pretty basic to most Access veterans but I’m having a hard
time coding a report list selection. I created a Combo Box with a list of
reports such as the following:
Annual Report

Hello.  I have a situation in which the higher ups are restructuring
territories/areas based on zip codes.   Which now will require the changing
the designated area of 16,000 records.  There are 3 tables that are involved;
tblArea - has the updated restructuring

Given a form with 3 fields:
ssn
firstname
lastname

On a continuous subform with only one field (suffix) I need to automatically
enter 0 when the field gets focus and then set the focus to the next record
in the subform, leaving the 2nd record blank and ready for the user to enter
a number.  I have tried in the field's OnGotFocus ...

To begin with, I would like to thank you all for taking the time in
assisting me!  Your help is very much appreciated!
I have a field that contains both negative and positive numbers ((set to
currency to represent (-) credits and (+) debits)).  My client would like to

I would like to have  a function to take care of the controls from calling
function. I am not sure what kind variable I have to pass.
For example,
function ValidateMyControl( MyControl as Combobox)