I have a contacts database with 2 tables. (I know, I know - I should
normalize, but I designed this early on in the Access learning curve & am
just beginning the process of normalization - I have ALL info in a single
table until recently.)

How do I format my date so the user can enter the date without the
"/". Example:
Right now (enter by user): 02/27/07        Final Result: 2/27/2007
I want (enter by user): 022707                Final Result: 2/27/2007

Maybe the subject is not clear , but i'll try to explain here.
I'd like to change the formname in the next code with a variable :
ex : Forms!FrmOrders.Controls("CmdAdd").Caption = "Add"
change it in : Forms!VARIABLENAME.Controls("CmdAdd").Caption = "Add"

I have a Mainform and 2 subforms.  When I enter text on subform 1, I want
that to be populated on subform 2.  Subform 2 has many rows that are
associated with subform 1's ID.  Currently, when I enter subform 1's text it
will only populate the first row on subform 2.  How can I ...

I have a form with a subform that allows the user to update information about
a customer.
The first record of my data shows up every time regardless of the selection
I make on the form.  It also changes the customer information for this first

I have a Form with 8 sub forms. I need (if possible a code) to break the
large screen into a series of separate smaller screen pages with a command
button that says “Next Page”.
Thanks for you help

Using Access2003 - I want the user to be able to delete an entry (record)
from a continuous form - I have the record selectors down the left side and I
can iterate through them using tab or down arrow but I can't actually select
one until I click on it with the mouse and then ...

I have a database project that I was trying to make more efficient (I've been
doing the dangerous thing of reading about Database Normalization).  I have
one form that was based on the single table I started with.  I've now broken
the table into two separate tables.  All of the ...

I have co-developed an Access 2000 database that manages office pools for the
NCAA Basketball Tournament ... I run it in Access 2003, but maintain the 2000
format for a lot of the pool participants that are still running on 2000 ...
Several output items (Forms and Reports) ...

We have several forms where Single Form view is fine for adding or editing a
record, but if we then want to view all the records at once it is much better
to use Datasheet view.
Generally we do want the forms all to open in Form view by default. However

I have a Table called tblFleet, with the fields "Domicile" "Vehicle" and
among others, What I am been trying to do is create a form withn 2 drop
boxes, The First Drop Box must contain the Unique Values of "Domicile" after
choosing the correct "Domicile" I need tp populate the second ...

I need to store data in existing form's text box from another form text box
(field value), for which, i used the below codes which are showing "#Name?"...
The codes are..
When i use this code in the existing form's text box's control source,

I have a form with an imbedded subform. I have a record number field linked
from the main form to the subform. The subform contains an input mask to
correct the record ID from a DMR prefix to a CAR prefix and it uses the same
unique recoerd number AA00000, like this DMRAA00000 in ...

Hello, i am really new with access and i like to make a few adjustments to
my selection on a list. right at this moment, i have a multiselection list
and what it does with the code bellow is when i select a OrderNo, and print
result it will prints all OrderNos. to be more clear i ...

I need a button in a form to allow (or not allow) data entry. Many thanks in
advance for your help.