Solved

Daisy Chain Forms in MS Access

Posted on 2013-05-11
7
569 Views
Last Modified: 2013-05-12
I was given a task to create an Employee Change Form in our access database but not sure how I want to set it up. I was given an example from our HR manager. She wants to know if I can set it up sorta like in the attached document. The first form pops up and you make your selection then click "Next". Then the next form pops up and you make your selection, and then it continues opening the forms via the "Next" buttons. Now depending on what they choose from the first form will depend on which forms open next due to the info required. But I also want to be able to store all the info in a temporary table until the form is completed. Then once all the data is collected they can click a "Process" button on the final form and it will update the tables and also print the completed form. Can anyone shed some light on how I might go about doing this or point me in the direction where I can get some ideas?
Sample-Doc.docx
0
Comment
Question by:Lawrence Salvucci
7 Comments
 
LVL 39

Assisted Solution

by:als315
als315 earned 100 total points
ID: 39159100
I see no problems with this design.
1. Start from splitted DB. All "constant" tables should be in back-end and all temporary tables - if front-end.
2. Create temporary tables for all forms, where data are stored. Table should be cleared when you enter form.
3. Create chain logic and develop forms (will be better to use modal forms, otherwise user can break chain).
4. On last form (Process button) you should collect data from all your temporary tables and write data to main tables.
0
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 400 total points
ID: 39159224
It is much easier to do this like the wizards. These are one form only but with several pages - yes, forms can be divided into pages of equal height:

http://office.microsoft.com/en-ca/access-help/add-a-tab-or-page-break-control-to-a-form-HP005187893.aspx?CTT=5&origin=HA001034548

Use Previous and Next buttons to navigate between the pages, and your code decides which page is "next" to allow you to skip some pages to simulate a flow chart.

As it is one form, every page "knows" about the current data on other pages.

/gustav
0
 
LVL 9
ID: 39159643
(no points)

Because your forms just gather single values (not a continuous list), you should be able to do it without temporary tables.  As cactus_data suggests, a wizard approach would probably work best.  While the form is open, it will retain all the values on the hidden pages, allowing you to use them at the end when the user proceeds.

Cheers,
Armen Stein
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 1

Author Comment

by:Lawrence Salvucci
ID: 39159726
@ cactus_data

I understand your concept and I think that will work but how do I get the "next" button to move to a specific page depending the data that is entered on the first page? For example say the user selects "change employee" instead of "new employee", I would want it to jump to say page 3 instead of page 2. How would I make this happen in the vb code?

Larry
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 39159763
It's not a magic button but one you create yourself. Thus, you simply adjust the OnClick event to make the form go to whatever page you like given the content of the other controls of the form.

You will also need code the enable/disable the Previous/Next/Finish buttons which you normally have as to some conditions.

I may have some code somewhere - back from the Access 2.0(!) days ...

/gustav
0
 
LVL 1

Author Closing Comment

by:Lawrence Salvucci
ID: 39160025
Thank you for your help. I am going with the page break idea and it seems to work out perfectly.
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 39160465
You are welcome!

/gustav
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How can you open the FORM2 2 32
Display label on subreport when NO DATA on subreport 4 22
Dlookup MSACCESS 5 25
Calculation in Access 5 26
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question