Question...

[ubergeek8]

I have a business and want to start sending out newsletters. I have
already purchased a program to blast the emails but need to collect
the emails. To do this I am going to set a computer on the checkout
counter and allow them to enter their info while their items are
scanned. I would just do an excel spreadsheet but I don't want people
seeing everyones information. So, I have been trying to build a SIMPLE
SIMPLE SIMPLE form in access that will collect the info. I have the
form built but am at a loss when programming comes into play. I
realize that there are navigation arrows at the bottom of the page but
I don't think a regular customer will think to click them to reset the
form. I have added a "Done" button at the bottom of the screen and
realize that I must add an event procedure that will reset the form to
insert another record. What I don't know is how to do it! I'm sure
it's just one tiny piece of code...but I don't know what it is. Please
help!!
Thanks!!

 

[ajetrumpet]

I have added a "Done" button at the bottom of the screen and
realize that I must add an event procedure that will reset the form to
insert another record.

If you're talking about people just entering their information into the form as a new record, specify the Form as "DataEntry" in properties. Don't need code for that...

 

[Larry Linson]

I have a business and want to start sending out newsletters. I have
already purchased a program to blast the emails but need to collect
the emails. To do this I am going to set a computer on the checkout
counter and allow them to enter their info while their items are
scanned. I would just do an excel spreadsheet but I don't want people
seeing everyones information. So, I have been trying to build a SIMPLE
SIMPLE SIMPLE form in access that will collect the info. I have the
form built but am at a loss when programming comes into play.

I realize that there are navigation arrows
at the bottom of the page but I don't think
a regular customer will think to click them
to reset the form.

For people with no training in using the application (as your customers will
not have), you need to make it just as simple as you can. That would not
include relying on, or even showing, the navigation buttons. If you show an
empty text box alongside a Label Control that reads: "Enter your last name",
it should be pretty obvious what the user is expected to do -- another term
for that is "intuitive".

If you set the Property "Data Entry" to "Yes", then the Form can be used as
you want -- only for adding a new Record.

I have added a "Done" button at the bottom
of the screen and realize that I must add an
event procedure that will reset the form to
insert another record.

If you are comfortable with VBA code, you can use a DoCmd.RunCommand
acGoToNewRecord (if memory serves on the name of the ac.. constant), but if
not, or even if you do, easier... clear the "Event Procedure" in the Click
Event for the button and add a macro, using the GoToRecord macro action, and
choose "New" in the options.

Larry Linson
Microsoft Access MVP

 

[ubergeek8]

For people with no training in using the application (as your customers will
not have), you need to make it just as simple as you can. That would not
include relying on, or even showing, the navigation buttons. If you show an
empty text box alongside a Label Control that reads: "Enter your last name",
it should be pretty obvious what the user is expected to do -- another term
for that is "intuitive".

If you set the Property "Data Entry" to "Yes", then the Form can be used as
you want -- only for adding a new Record.


If you are comfortable with VBA code, you can use a DoCmd.RunCommand
acGoToNewRecord (if memory serves on the name of the ac.. constant), but if
not, or even if you do, easier... clear the "Event Procedure" in the Click
Event for the button and add a macro, using the GoToRecord macro action, and
choose "New" in the options.

Larry Linson
Microsoft Access MVP

It worked! Thanks!!!