How to program submit button

[Louisa Ray]

Hello,

I need some step by step help please. I am completely new at this and know
next to nothing about how to do this. I have created a form in Access which
has the follow fields:

Item/Price field, Date (unbound), First Name (unbound), Last Name (unbound),
Employee Location (unbound) and Employee Number (unbound).

At the bottom of this form is a submit button that does nothing right now.
When a user fills out this form I want them to click the submit button and
have the form information either emailed to a user or have the data populate
a table.

How do I do this? I have no idea how to set this up.

Thank you,
Louisa Ray

 

[Danny J. Lesandrini]

The concept of "Submit Button" is not native to Access. That's the language
used in a web form. Are you building a Microsoft Access UI application?

If you use bound forms, then there is no need to Submit or Save the edits.
You can create unbound forms and then add code to execute the INSERT
and UPDATE, but if you're completely new, I doubt that is what you're trying
to accomplish.

So, why do you have a submit button at the bottom of the form?

 

[Louisa Ray]

The concept is for 3rd shift workers to be able to place a food order and
then have their choices sent to a cafeteria worker. They will select which
entree they want and enter their name, location, etc and then I need for
their info to go somewhere so the cafeteria will know what to pull for them.
Does that make sense?

 

[Danny J. Lesandrini]

I was just trying to determine your background for programming, assuming
it wasn't Access, where the paradigm is a little different.

You've described a requirement below, but it's not clear how Access is
involved. I could do that quite simply with classic ASP and SQL Server.

Will your users have an Access database on their desktop where they may
enter their choices? Will the cafeteria worker have the same app with a
report of recently placed orders?

If both parties have a copy of the app, then the workers will simply add
a record and the cafeteria will have to have a self refreshing form or report
that keeps aprised of additions.

Create a data entry form for adding choices
No need for a Submit or Save button ... it's saved as soon as it's entered.
Create a form that displays the current list
Place a checkbox on each "choice" record to flag it as completed
Put code to requery the list on the timer event, or add a refresh button.

 

[golfinray]

Use a command button set up by the wizard to save.

 

[Louisa Ray]

Unfortunately I don't get the wizard on mine.

Use a command button set up by the wizard to save.

 

[Louisa Ray]

I'm sorry - still a little lost on this. There will be a couple of
workstations set up where the users will select their choices and the
cafeteria worker will also have Access on their pc. How do I go about getting
the food choices that the workers have selected to the cafeteria worker? I am
not a programmer and don't have any idea how to set this up. Please help.

Thanks,
Louisa

 

[Mike Painter]

I'm sorry - still a little lost on this. There will be a couple of
workstations set up where the users will select their choices and the
cafeteria worker will also have Access on their pc. How do I go about
getting the food choices that the workers have selected to the
cafeteria worker? I am not a programmer and don't have any idea how
to set this up. Please help.

Thanks,
Louisa

All computers have a copy of Access but only one has a copy of the tables
that run the program. Everything gets sent to the same place.
Usually this is done by splitting the database into a front end and back
end, something Acccess will do for you the first time.
You need to then go the the other machines and use the linked table manager
to attach the front end of those machine to the backend of the "main"
computer. I'd use the one in the kitchen