I have an enumeration table that includes 2 fields (each field has unique
values) called Common_Name and Scientific_Name.  
In my form, I am using combo boxes that lets the user select a name from
each of the fields listed above.  

I have two comboboxes where combo1 follows combo2.  I want the coice
in combo1 to reduce the choices in combo2.
Choices in combo1 are Vehicle A and Vehicle B.  Each is given an ID of
1 for Vehicle A and a 2 for Vehicle B

I'm typing into an unbound textbox.
I want to limit the number of characters that can be entered.
As your typing the letters in, if you go over a certain number, lets say 5 I
want a msgbox (that Imade to pop up)

I'm trying to create a button on a form that when clicked automatically
mails a report.  However, the tricky part is that I want that report to only
contain the data from the current record.
I am an Access amateur but have fudged together the following code where

I want to programmatically (VBA) grab the values of fields in a subform of a
main form. For example, how can I access the values for a single field in a
subform containing, say, three rows of data?
If someone could help me I'd most grateful!

I would like someone to answer a question!
Are office pro 2007, sql server 2005, and windows vista ultimate all
compatable. I dont really like office 2007 but 2003 is not compatable
with sql server 2005 and sql server 2000 is not compatable with vista.

I created a form in datasheet view.  However, when I open this form from some
VB code on another form, it opens as a regular form.    
Dim stFormPT as string
stFormPT = "ErrorPT"

I have an Access 2007 application in which I'm creating a custom ribbon.  I
have a callback module in which there is a routine called onOpenForm.  Within
the routine there is a select case statement where code is executed based on
the calling ribbon button.  I'm having trouble ...

How can we set the below properties of a FORM  programatically?
Left
Top
Right

A bit of background to start.
A2003, split, multi-user. I have a form that uses a stored query as it's
recordsource. The query (qryDeliveries) pulls a limited number of records
from the table (the previous 7 days worth). In the header of the form are

Do we need to open a form in design view only  for changes and saving the
forrm
thru VBA code?
DoCmd.OpenForm rs1("Form"), acDesign

I am opening a form dynamically in VBA code in design view and making changes
DoCmd.OpenForm rs1("Form"), acDesign
But for sub-forms the above statement fails. How can i check if
rs1("Form") is a sub-form and how do I open in design view to make changes

I need help with my forms in Access 2003. Basically my question is how to
move some values from one form to another. I am totally stuck and don't know
how to do it. Any help would be greatly appreciated.
Here is my scenario.

I have a Purchase Order database that generally seems to be working as
intended, but I have run into a wall on an aspect of data validation.  The
PO record is in the main table, with the LineItems in a related table.  The
user interface is a main form with a subform.  It's a ...

I am not familiar with the syntax of VB though I do have a fair knowledge of
several programming languages. I am working on a form in access 2007 where
the user enters address information and can click a check box if the billing
address is the same address, if it is I want the ...