Hey all,
Using access 2003, getting more familiar with access, new to vba.
I'm working on setting up a user notices system that will log receipt of a notice when the user inputs their password.
Setup so far
Table users
Userid
Username
Password
Table notices
NoticeID
NoticeBody
Table NoticeUsers
NoticeUserID
NoticeID
UserId
Acknowledge (date/time)
I've created variables for use in VBA.
CurrUser, curruserID, curruserPass which gathers the user info upon successful login.
My next planned step will be to set up code in the load event of the main menu that loops through a recordset created from the notices table to identify all the notices.
Here's where I'm stuck for each notice in that recordset I need to check table noticeusers to see if there is already a record for each notice. If there already is a record, check next. If doesn't exist load form notice, if does exist load main menu. How to tell vba to do the if then for each of the notices in notice table check the records in noticeusers table?
My end goal will be to bring up the notice if the user hasn't acknowledged receipt. Once they read the notice, enter their password and a record is created in usernotices allowing them to not see it next login.
Using access 2003, getting more familiar with access, new to vba.
I'm working on setting up a user notices system that will log receipt of a notice when the user inputs their password.
Setup so far
Table users
Userid
Username
Password
Table notices
NoticeID
NoticeBody
Table NoticeUsers
NoticeUserID
NoticeID
UserId
Acknowledge (date/time)
I've created variables for use in VBA.
CurrUser, curruserID, curruserPass which gathers the user info upon successful login.
My next planned step will be to set up code in the load event of the main menu that loops through a recordset created from the notices table to identify all the notices.
Here's where I'm stuck for each notice in that recordset I need to check table noticeusers to see if there is already a record for each notice. If there already is a record, check next. If doesn't exist load form notice, if does exist load main menu. How to tell vba to do the if then for each of the notices in notice table check the records in noticeusers table?
My end goal will be to bring up the notice if the user hasn't acknowledged receipt. Once they read the notice, enter their password and a record is created in usernotices allowing them to not see it next login.
