Data entry in Access

dcooper5 wrote:
> 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?

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

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.

"John W. Vinson" wrote:

> On Thu, 28 Aug 2008 11:48:00 -0700, dcooper5
> <dcooper5.DeleteThis@discussions.microsoft.com> wrote:
>
> >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?
>
> 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.
> --
>
> John W. Vinson [MVP]
>

On Wed, 24 Sep 2008 10:54:02 -0700, AccessUser30
<AccessUser30.DeleteThis@discussions.microsoft.com> wrote:

>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.

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.
--

John W. Vinson [MVP]

can i create some botton title search or add? if so how?

"John W. Vinson" wrote:

> On Wed, 24 Sep 2008 10:54:02 -0700, AccessUser30
> <AccessUser30 RemoveThis @discussions.microsoft.com> wrote:
>
> >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.
>
> 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.
> --
>
> John W. Vinson [MVP]
>

On Thu, 25 Sep 2008 06:07:01 -0700, AccessUser30
<AccessUser30.TakeThisOut@discussions.microsoft.com> wrote:

>can i create some botton title search or add? if so how?

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
--

John W. Vinson [MVP]