I want to create my forms using VBA.  I can make a subroutine for
fields/buttons that are used in more than 1 form, so I don't have to do
something twice. But the problem is: I don't know how I can add elements to
a form.

I apologize if this has been answered previously.  I could not find this
issue.
I have a form with a listbox and a subform.  The subform is linked to the
listbox via the "Link Child/Master Fields" properties.  The subform updates

How to I make an mde using vba code?

       I've gone blank...  I want to save the current record on a form from
within VB code, after changing a bound control.  What's the easiest way to
do this, shy of requerying the form?
- Max

I have 24 company tables.  I need to create a data entry form for each.
All the tables use the same fields.  Is there a way to use one(1) data
entry form for all table and populate the header with the table name of the
table in edit?

Hi! I have a procedure that I wish to run depending on which form was used to
open the existing form.  How do I determine that or if a given form is open?  
Thanks.

I can not get the date to appear in a field automatically after a certain
event occurs. Here is the code:
AfterUpdate for strRequestStatus Field
If  Me.strRequestStatus = "Closed" Then

I am getting a run-time error 2447 message (There is a invalid use of the .
(dot) or ! operator or an invalid parenthesis) in my code when I refer to the
value in a combo box. This error started showing up when I changed the number
of columns from 2 to 1 and eliminated the ...

I have an option group on a subform of an Access form.  I want to force the
user to select one of the options before they close the form.  I can't seem
to figure out what event procedure to put the following code in:
If Findings.value = null then MsgBox, "yada yada yada" EndIf

Hi again group
I need to extract the day and month from a date field and place these values
into 2 seperate fields ([day] and [month]).  Is this possible in access ??
Thanks in anticipation.

    i want to bring up a simple for that has one text box that says "enter
customer last name". when i enter the name and hit enter i want my customers
form to open to that customers record. I can't seem to figure this out. I'm
new to access but i can't find instruction on how ...

I have encountered a problem with some code in Access 2003 after upgrading
from Access '97.  In particular this statement:
me.ControlName.Value = [Forms]![Application]![ControlName].Value
I am attempting to assign the value of a control from the parent form to a

With the standard navigation buttons on an Access form, is there a way to
limit the user from proceeding to a new record?
I have four objects with a subform to enter data on each.  There are only
four.  The user can navigate to a 5th(new) form.  I have disabled the

How can I refer to fields on a form when I'm creating code for a command
button on a subform?
For example, I'm trying to create a command button that automatically opens
an e-mail.  In the subject of that e-mail I want the Name and State of the

How can I detect if my front end database is open already?
Thanks
Diarmuid