Data entry in Access

  • Thread starter Thread starter dcooper5
  • Start date Start date
D

dcooper5

I am working on a large data entry project and must create forms for the data
to be entered into. Without using a template, what is the easiest way to
create a blank form?
 
dcooper5 said:
I am working on a large data entry project and must create forms for the data
to be entered into. Without using a template, what is the easiest way to
create a blank form?
Click to expand...

First you need to design the table(s) that hold the data then you can
build the form based off the table or a query.

gls858
 
I am working on a large data entry project and must create forms for the data
to be entered into. Without using a template, what is the easiest way to
create a blank form?
Click to expand...

If you set a Form's "Data Entry" property to True, it will automatically open
to the blank "new record" and will not allow the display of any existing
records. It's not completely clear that's what you want though.

Do be sure to provide some way to edit and delete existing data if you create
such a form.
 
Help! I’m creating a basic form but need users to be able to add new records,
search and edit current records. Can anyone help me on how to do this?
Currently, I can entry new records from setting the data entry field to yes,
but can’t edit or search.
 
Help! I’m creating a basic form but need users to be able to add new records,
search and edit current records. Can anyone help me on how to do this?
Currently, I can entry new records from setting the data entry field to yes,
but can’t edit or search.
Click to expand...

Well... then don't DO that.

If the Data Entry property is set to No, you can still enter data (just by
moving to the new record using the *> navigation button); but you can also
edit existing records, search, etc.
 
can i create some botton title search or add? if so how?
Click to expand...

You can use the Combo Box Wizard to create a combo box to search, and the
Command Button Wizard to create a button to go to the "new record" for adding.

Take a look at some of the tutorials available:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
Back
Top