Hi Guys and Girls,
I have created a Database which we call a filechecker, its to check users are doing there job correctly.
Everything i have done on the databse is from the internet and a few videos so please be gentle with how its built
I would like some help with VBA with the following please:
I have attached the database here:Test.zip
Here are step i hope can help understand what i need help with:
1. On the HomePage_frm select the File Checker btn.
2. this will open the FileChecker_frm (there is some VBA code for this form upon loading to Name the btns as you can see(these names are from the Users_tbl Authority=Supervisors)
3. when you click one of the btns ( eg.Richard Bartlett) it will open the FileCheckSelection_frm, this form has hidden btns ( you can see these in design view).
4. what i want to do between the FileChecker_frm and the FileCheckSelection_frm is open the FileCheckSelection_frm but only display the btns that the user has a yes against in the Users_tbl.
5 Also when the FileCheckSelection_frm loads with there buttons they can access, when they click the btns of choice it will open the form (eg. BrokerFileCheck_frm)
6. when the eg.BrokerFileCheck_frm opens then it only open for the supervisor that was selected from the FileChecker_frm.
i hope it all makes sense and any help would greatly apprechated.
Thanks
Simon