In VBA, how can I dynamically add controls to an Access from at runtime.

I have Access 2002.  For this database I've created,  when I enter data in
the form section, sometimes the record is filled with "#Deleted " instead of
the actual data.  Once deleted, my oringinal data could not be recovered.
My database has some built in marcos with no custom VB ...

I have a table with a hyperlink data type for one field
to reduce storage space this is how i have stored the picture, however, can
i, on a form, automatically display the contents of the file rather than the
hyperlink address in a field?

I have an order entry database (Template from access).
1.  Create customer info in form from customer table.
2.  Make certain products are in product table/form.
3.  Open orders form.

In Textbox when I DoublClick, open the F_Imgs on To Back.
I would like open it on To Front.
How is it possible, please.
Thanks in advance.

I am trying to use a Modal Form inside a procedure for collecting some user-
specific information (say, Username/password, for example).
I expect it to function in a way that unless a user clicks 'OK' or 'Cancel'
button (that is unless that form gets closed), the execution should ...

I have a text box which displays the month/year (i.e. Jul/05).  What I
would like to do is to keep that month/year constant until I enter a new
month/year.  I know that I saw an example of this once before in this
group.  I'm hoping that someone will help me.  TIA

I have two tables linked in a relationship by Key Ring numbers. It is a one
to many relationship. I have the Keys main from , that when I enter the Key
ring number, Location and number of keys in the main from, then go to the sub
form I am only allowed to enter one key number and ...

Using the code found here -->
http://support.microsoft.com/default.aspx?scid=kb;en-us;209871
I created a password-protected form.  Now I have two problems:
1.  After I've typed in the password, I don't need to type it in again as

I have a dialog box (frmDialogTransactionsForMeeting) that contains a combo
box (MeetingDatecombo) looking up date values from a table.
A query (qryAllTransactions) that reports transactions against certain date
values, contains the following criteria on the MeetingDate field:

I've got a form with 16 actions for customers and when the customer is
entered all these 16 actions (records) are entered but action successful is
not ticked and the date of action is automatically the date the actions were
entered. When action successful is ticked i change the ...

I am trying to build a form which will automatically enter information in a
field when the first field information is entered. Example I have one table
which list regions by number ( P. Key) and then the next record is a
description of tha region. I then have a table for entering ...

I hope someone could share some insight on this strange issue I've been
having.  I've been building a database for about three weeks now and I have
so far had no problems with it (on MY system).  My boss at work opened the
database up and tried to open the form.  He got this ...

I have a form whose recordsource is a query on table tblMytable. The form has
some command buttons. One runs an event procedure to process all records in
the form's recordset. Another is a "preview" of all the records that will be
processed. The preview button runs an OpenQuery ...

I need a little help coding a combo box.  I think I need code for the "not in
list" event to bring up a message box that says " The referral source you
have netered is not in the list.  Would you like to add this referral
source?"  There should be a "yes" and "no" button.  If ys ...