Hi Jan,
Thank you so much for your post. I think this will work as a solution to my problem.
Regards,
Leanne...
User Profile
Collapse
-
hi nico,
thanks for your feedback, I think that what you are suggesting is that I have a table where the columns are the questions, the rows are the students, and the cells are the answers for the corresponding question and student. I have created tables like this in the past however when you create a form to collect the data, you have to 'place' the question and answer objects in the form (thias makes it harder for other non-programming...Leave a comment:
-
Populating a ComboBox RowSource on a Continuous Form
howdy scriptors… here’s my question:
Project Background:
I’m creating a database that will hold questionnaire data.
Situation:
I would like to set up a combobox with a changing rowsource property on a continuous form. I have created a query for the record source so that the text value of the rowsource property is included as a separate field for each record. I have call this field: [AnsRowSource]... -
-
How do Global variables behave in Access when there is more than one user logged into the system? For example, if a restricted user logs in to the front-end and then an administrator logs into the same front-end file... are the Global variables unique to each user? (Ideally people will have different front ends but I cannot always ensure this will be the case).
thanks again...Leave a comment:
-
Storing sessional User information using VBA
Situation:
I have a database that has users with different levels of access to the information they are allowed to view. I have addressed this issue by creating a login form that opens on startup. Behind this form is the tblUserDetails, which has login information such as: userID, password and access level (which has three levels: basic/full/admin).
Problem:
Once the user has logged in I would like to be able to retrieve...
No activity results to display
Show More
Leave a comment: