Hi,
I am a newbe to access and am trying to create a database, which is going well so far.
I would like to get a pop up box or form to appear depending on a value in a date field.
I have menaged to get the text boxes to change colour depending on the date, but not sure about getting a pop up to work.
I would also like the pop up to only close when a password is entered, ideally masking the password that is typed in. I presume this will need a control button to work.
Edit to question:
I would like the pop up or new form to appear when a record is opened and meets the criteria, e.g. if record 23 is selected and the date (date of birth) shows as being within the next few days, then a pop up form or message will appear, but only close down when a password is entered.
Apologies - forther edit after guidance
If the date is within 3 days, i would like the pop up to happen, but it needs to have a password entered to close it.
Can anyone offer any guidance please?
Thank you
I am a newbe to access and am trying to create a database, which is going well so far.
I would like to get a pop up box or form to appear depending on a value in a date field.
I have menaged to get the text boxes to change colour depending on the date, but not sure about getting a pop up to work.
I would also like the pop up to only close when a password is entered, ideally masking the password that is typed in. I presume this will need a control button to work.
Edit to question:
I would like the pop up or new form to appear when a record is opened and meets the criteria, e.g. if record 23 is selected and the date (date of birth) shows as being within the next few days, then a pop up form or message will appear, but only close down when a password is entered.
Apologies - forther edit after guidance
If the date is within 3 days, i would like the pop up to happen, but it needs to have a password entered to close it.
Can anyone offer any guidance please?
Thank you
Last edited: