I have recently made a survey using Microsoft Access 03. I am a very new user to Access and learning as much as I can from TT and other websites.
Now the survey I have created is set up to collect test data on prototype machines. If the machine fails to perform correctly the tester will use my form to relay the data to us. Now I would like to create a login and password for the tester and have the form run much like a computer program would look.
I have already learned how to create the form to look much like a survey or questionnaire so that part has been taken care of.
1. I would like to learn how to create a login for new users
2. I would like my form to add any newly created users to a drop down list
3. I would love to learn how to have selections determine the next "page" in the form.
I have not learned how to create multiple "pages" for a form. For instance, say the machine did not function because of a power issue. Well I would like the tester to drop down a list that states [Power Issue] and then click NEXT. This would take them to a form dedicated to Power Issues (with different forms for all the different troubleshooting issues). But if possible, have all this data store into one main table.
Now like I said I am a very new user and I don't know if what I am looking for is even possible, this is just what my client is looking for!
I appreciate any help you guys provide, I couldn't have gotten at least this far without you guys!
Now the survey I have created is set up to collect test data on prototype machines. If the machine fails to perform correctly the tester will use my form to relay the data to us. Now I would like to create a login and password for the tester and have the form run much like a computer program would look.
I have already learned how to create the form to look much like a survey or questionnaire so that part has been taken care of.
1. I would like to learn how to create a login for new users
2. I would like my form to add any newly created users to a drop down list
3. I would love to learn how to have selections determine the next "page" in the form.
I have not learned how to create multiple "pages" for a form. For instance, say the machine did not function because of a power issue. Well I would like the tester to drop down a list that states [Power Issue] and then click NEXT. This would take them to a form dedicated to Power Issues (with different forms for all the different troubleshooting issues). But if possible, have all this data store into one main table.
Now like I said I am a very new user and I don't know if what I am looking for is even possible, this is just what my client is looking for!
I appreciate any help you guys provide, I couldn't have gotten at least this far without you guys!