Designing a Form in access

M

maw358

Im currently attempting to design a form in access. What i want is
this.

1.)The form to open up with blank input tabs when newly opened
(example, if there are 100 entries in the database, the form to open
up blank when im opening the database and be ready to input entry 101)

2.)I have a column in my table for the date entered. I would like the
form to have a tab with the current date in it and ready to be inputed
instead of having to type the date.

.....i have it designed so when u open up the database, the Form is the
pop up, Im hoping others in my office can just click open the DB,
input the info (w/out worrying about enterting the date or navigating
to a new entry) and submit into the DB.

Your help is much appreciated!
 
J

Jeff Boyce

Check Access HELP for the Data Entry property of a form -- by setting this,
you allow ONLY data entry.

You do NOT need to keep track of how many have already be entered this way,
since anyone opening the form will be able to add a new record (i.e., the
values that make up a new record).

If you add a BeforeUpdate event procedure to the form, you can use this to
set the value of the table's date/time entered field to Now() (if you need
date AND time), or to Date() (if you only need the date). The user would
never see this, plus YOU would not need to "hide" the value somewhere on
your form.

I don't understand what you mean when you say "... with blank input tabs..."

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
M

maw358

Check Access HELP for the Data Entry property of a form -- by setting this,
you allow ONLY data entry.

You do NOT need to keep track of how many have already be entered this way,
since anyone opening the form will be able to add a new record (i.e., the
values that make up a new record).

If you add a BeforeUpdate event procedure to the form, you can use this to
set the value of the table's date/time entered field to Now() (if you need
date AND time), or to Date() (if you only need the date). The user would
never see this, plus YOU would not need to "hide" the value somewhere on
your form.

I don't understand what you mean when you say "... with blank input tabs..."

Regards

Jeff Boyce
Microsoft Office/Access MVP










- Show quoted text -
Click to expand...

ill look into the Help...

When i start the Database, the form opens up immediately and it shows
the 1st entry of the table. There are 4 fields for values on my form.
PAYEE , CONTRACT, AUDITOR, DATE FILED. Fairly simple. What id like is
for the database to open with these fields blank and ready to have a
new value inputed for each, instead it shows the first record and i
have to click some of the footer buttons to get to a blank version of
the form and submit a new record.
 
J

Jeff Boyce

Your form shows existing records because the form's Data Entry property is
set to No. Re-read my response and check Access HELP.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top