MS Access Advanced: VBA code Week 6 assignment

Availability: In stock

Regular Price: $20.00

Special Price: $15.00

OR

MS Access Advanced: VBA code Week 6 assignment

Double click on above image to view full picture

Zoom Out
Zoom In

More Views

Quick Overview

MS Access Advanced: VBA code Week 6 assignment


You will be modifying the frmMainMenu to call the caption of each button from the table MainMenu and form or the report.
1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run.


2) Your code (for the button) will dynamically read the caption from the table and assign it to the button.
HINT: Variables (table name) in other areas of the code should not be "hard-coded". If for example a Table name changes in the database it should be reflected in the menu. I do not need to go into the code and look for all entries for the hard-coded name of the table. Dynamic caption means should the name of any table change – the caption on the button for that table must change as well. Test it out …


3) Your code (for the button) will dynamically read the form/report name and will run when you press the button.
HINT: Like the hint for #2 above do the same for the reports. No names should be hard-coded. This prevents errors in the long run which often break a program, and maintenance does not become a nightmare!! This approach is a widely utilized practice amongst professional developers in support of friendly user experience enhancements! Our users want to be able to press buttons that are logical, practical, and smart

**My professor said that this assignment has to use the "DLookup" element in VBA.**

Regular Price: $20.00

Special Price: $15.00

Details

MS Access Advanced: VBA code Week 6 assignment

You will be modifying the frmMainMenu to call the caption of each button from the table MainMenu and form or the report.
1) Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run.

2) Your code (for the button) will dynamically read the caption from the table and assign it to the button.
HINT: Variables (table name) in other areas of the code should not be "hard-coded". If for example a Table name changes in the database it should be reflected in the menu. I do not need to go into the code and look for all entries for the hard-coded name of the table. Dynamic caption means should the name of any table change – the caption on the button for that table must change as well. Test it out …

3) Your code (for the button) will dynamically read the form/report name and will run when you press the button.
HINT: Like the hint for #2 above do the same for the reports. No names should be hard-coded. This prevents errors in the long run which often break a program, and maintenance does not become a nightmare!! This approach is a widely utilized practice amongst professional developers in support of friendly user experience enhancements! Our users want to be able to press buttons that are logical, practical, and smart

**My professor said that this assignment has to use the "DLookup" element in VBA.**

Product Tags

Use spaces to separate tags. Use single quotes (') for phrases.