Set and activate auto reminder at scheduled time

[Hiren Joshi]

Hello Again to All Experts,

Does anyone know, How to Create Remider like outlook in VB 6.0?

I want to pop up couple of remiders at run time with Snooze and Dismiss Option.

Criteria: I am using VB 6.0 and MS Access. Lets say one of my Table of Quotation is not converted in to real business and its more than a week since we gave that quotation to the Client. How can we auto remind the staff to follow up the Quotation? Can we Auto Remind using Popup with Snooze and Dismiss Menu?

Any Suggestions?

Thanks and Regards

Hiren (Nairobi- Kenya)

[debasisdas]

Question moved to Visual Basic Forum from VB Articles Section.

[jamesd0142]

Use the timer in vb. (i assume vb6 has this?)

Set it to check the time every 30 seconds and search a db maybe for entries that macth the current time/date

[Hiren Joshi]

Use the timer in vb. (i assume vb6 has this?)

Set it to check the time every 30 seconds and search a db maybe for entries that macth the current time/date

Can U give me some Sample Code to do that? I will really appreciate that.

[debasisdas]

Can U give me some Sample Code to do that? I will really appreciate that.

You need to search the database at a particular time interval and check the records and then display the reminders as desired.

[jamesd0142]

Unsure in vb6...

This is vb.net...

Drag a timer control onto your form, set it to enabled and set interval to 30000 (30 seconds or as required).

then double click the timer control and input your code there.

this code will then execute every 30 seconds.

the code itself should (i feel)...

get syetm date/time,
select * from database where date/time column = to the current date/time.

display all matches in a grid view or some where else.