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