Hello,
I am new to the Access world and my boss has tasked me with creating a survey for employees to take. This survey will be linked onto a website where each employee can log on and choose which survey to take, then all the information will be uploaded to a DB.
An example for this is he wants to test some employees on their MS Office proficiencies and wants it so the employee can just click on a link for Word, Excel, Ppt... so on. The way I have the forms set up is there is an Admin form to enter the questions and a Survey ID #, which is the Primary key for the "Questions DB", from there I want it so the employee can then click on a link on the website and access another form which pulls the questions from the "Question DB" through the Survey ID #. They then fill out answers to the form and all the information goes into an "Answer DB"
I do not want the employee to be able to scroll through the other surveys while in the form. I would like it so the link opens a specific survey with a specific Survey ID # that cannot be changed. The Survey ID # is what specifies what questions are pulled (if you couldn't guess) so I would like to code the Survey ID # into the link so the employees cannot change it by accident. Is that possible? My problem is I dont know exactly where this would get done, is this coded in the HTML of the site or can it be done in Access?