how to terminate pop up reminder that has been set(check out)

[nurul]

hye all,



i would like to ask is there anyone here know how to terminate reminders.

i have made borrowing system and it will have date taken and date return..

for now, my pop up reminder will pop up in a week before the date return.

my problem right now is if the user return the cd early than the actual date return, the reminder will still pop up. it is because, i have no function to check out the cd..

how to make the check out and also can disable the reminder if i click the check out for that borrowing.

i'am beginner in access and VB.
hopefully somebody can help me on this.

thank in advance.

[June7]

Would need to know your data structure and form designs to provide specifics.

Have you looked at the Lending Library template? Sounds like it might meet your requirements. http://office.microsoft.com/en-us/te...010206883.aspx

[nurul]

tq June7 for your reply..

i'm use this code at switchboard so that the form will pop up once we open the switchboard.

If DCount("ID", "Table1", "date_return BETWEEN #" & Date & "# AND #" & Date + 7 & "#") > 0 Then
If MsgBox("Documents are due in a week. Do you want to review?", vbYesNo) = vbYes Then
DoCmd.OpenForm "Form1", , , , , acDialog
End If
ProgramExit:
Exit Sub
ErrorHandler:
MsgBox Err.Number & " - " & Err.Description
Resume ProgramExit
End If
End Sub


then maybe i will need to have check out button if the borrower return the cd which i don't know how to do it.
hope you can help me to solve this.

thank in advance.

[June7]

Maybe you just need to include criteria in the code that opens the popup to run only if the cd is still 'checked out' but I still don't understand your db enough to offer specifics. I don't know how you determine a cd is 'checked out'.

Again, I think you would benefit from exploring the Lending Library db.

[nurul]

can you take a look into the system that i already created..
so how can i improve the function..

yes i currently exploring the library lending..still figure out how it functioning..

[June7]

Your data includes date_taken and date_return (this appears to be a due date, not the date actually returned). With this data structure there is no documentation of when cd has been returned and therefore no way to exclude it from the DCount expression. There is no way to fix your code because the data structure does not allow for any fix.

This db really has only one table for data. This is not a relational structure. Why are you building this when a workable product is available?

[nurul]

ok..if i want to use the lending library, can the system show reminder to remind for return the items or maybe can set reminder in outlook like i see the email function is there..?

actually i'm quite do not understand how the system works...

sorry because i'm only beginner in vb.

thank

[June7]

I don't think the LL has automatic popup reminders, there is a report to show checked out items. There is simple email functionality. It has no VBA code, all macro driven.

Suggest you just try entering records and explore the design. Otherwise, go back to the drawing board because what you have now is not a relational database and won't do what you want.