reminder pop up return date

[zyan31]

Re: https://www.accessforums.net/access/...age-28251.html

Code in switchboard form Open event like:

If DCount("ID","table","DueDate=#" & Date() + 1 & "#") > 0 Then
If MsgBox("Books are due tomorrow. Do you want to review?", vbYesNo) = vbYes Then
DoCmd.OpenForm "formname"
End If
End If

Hello, i'm a total newbie in access. I dont really get it, can u explain to me in details on how can i get the pop up message to show? i use your codes and its getting error at the "If DCount("ID","table","DueDate=#" & Date() + 1 & "#") > 0 Then". I already changed the details

[June7]

Changed what details - using your actual table and field names? Post your actual code or database for analysis.

What is the exact error message?

[zyan31]

Hello June7. Can i have your email cos i need to email you my database. Tq.

[June7]

I do not provide email. Attach db to post in thread or upload to fileshare site such as Box.com and post link to file.