Multiple Users - Form Submission

Question

I wanted to ask the community for assistance/guidance. 

I am creating a database that will ultimately be for a group of individuals to input their new, incoming projects. So they will need to fill out a form with all of the pertinent information which will obviously be stored in a back end table.

I have completed the tables with the relevant information, but now I need to understand the best way for the end user to submit a form with information (actually multiple forms, so complete one, possibly hit a button, go to the next, then final submission). The end user will also need to be able to pull up the form at a later date, if necessary to complete the submission. 

Any assistance would be appreciated.

DV

Answer 1

A bound form's data is automatically saved to a table when you move to another record or close the form.  If you wish to force the user to save a record via a command button you might like to take a look at SaveDemo.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

Note that if you are using an earlier version of Access you might find that the colour of some form objects such as buttons shows incorrectly and you will need to  amend the form design accordingly.  

If you have difficulty opening the link, copy the link (NB, not the link location) and paste it into your browser's address bar.

As regards retrieving data you might like to take a look at DatabaseBasics.zip in the same OneDrive folder.  This includes a section on this, illustrated with a number of annotated forms, containing unbound controls in which values can be selected or entered to define the basis of the search.

Other demos in the same folder which might be of interest are FindRecord.zip and SearchDemo.zip.  For the use of unbound forms for data entry see VolunteerRota.zip.  Generally, though, bound forms are used for data input, unless there are cogent reasons for doing otherwise, e.g where a highly customized interface, such as that illustrated in my VolunteerRota demo, is required.

Answer 2

Did that as well.

Its just the form submission and ability to bring up previous forms.

Answer 3

Not sure if you've seen this guide on splitting a database to a front end and back end:

https://support.office.com/en-us/article/split-...

Answer 4

Thank you for the reply. 

I am actually well into the build. Tables are complete. Linking tables complete. 

Now I just need to understand the best way to create the front end and how to have it interact with the BE. 

I needs to include multi user forms, with the option of recalling a partially completed form when more data/info has to be added.

So how I see it is user opens Access, form pops up with the options of 1) New Form 2) All of the active, in progress forms.

Thanks, 

DV

Answer 5

Hi DV123,

I'm a fellow Microsoft customer and expert user here to help.

Did you try out the sample databases that Microsoft has? You can access them right in Access. You may be able to take one and see how it works using forms to access the tables to update the records and view the entered records.

That should give you a good start.