473,326 Members | 2,102 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Send a Reminder

Hi Everyone
I send an email upon the user request to the administrator & i send a
reminder in case of two day pass without any action from the administrator
The problem is that i cant find the event that fire the Reminder action???
Thx in Adv
Nov 18 '05 #1
3 1514
There wouldn't and can't be an event. Your code only runs when there is a
page to process. What I would do is write a sql job that checks nightly for
stuff like this and sends out the email. In a unix environment I would write
a cron job. Look to see if there is something like that in Windows.
Nov 18 '05 #2
Thx Scott for ur response
but is it possible that the sql job call a visual basic code to be
executed???
"Scott Simons" <Scott.Simons.At.MealMagic.Com.Remove.This> wrote in message
news:3D**********************************@microsof t.com...
There wouldn't and can't be an event. Your code only runs when there is a
page to process. What I would do is write a sql job that checks nightly for stuff like this and sends out the email. In a unix environment I would write a cron job. Look to see if there is something like that in Windows.

Nov 18 '05 #3
Mariame wrote:
Thx Scott for ur response
but is it possible that the sql job call a visual basic code to be
executed???


Write a WSH script that queries the DB for a recordset of notifications
to be made and processes it. Use Scheduled Tasks to schedule it.
Nov 18 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: serendipity | last post by:
Hi, I'm not sure if this is possible as i've googled everywhere, but i have a select query that returns a customer record with their associated sales orders. I would like to automate a process...
3
by: John | last post by:
Hi I want to implement an auto reminder like outlook that pops up at the specified time. I think there would be some sort of timer that will check when an appointment is due and pop-up the...
9
by: Phil G. | last post by:
Hi all, I would like to create a very simple 'lite' version of Outlook Calendar's reminder function. I will use a windows service that will read timedate stamps from a db and compare them to...
17
by: DP | last post by:
hi, is there a way to send an e-mail to a customer, using ms access?? or some kind of automated mail merge, so the user only has to review the body, and click send? ive got a customer table,...
1
by: Jeremy Simpson | last post by:
Has anyone tried to set a reminder in MS Outlook from with Access? I want to, when a checkbox is ticked automatically set a reminder in access that takes information from the current record i.e...
1
by: groupie | last post by:
Hi, I'd like to know how to implement the "Forgot Password" feature on many websites which require a login, exactly like this ebay example:...
2
by: THEAF | last post by:
hi, I'm trying to create a reminder. i have 2 forms one for to set the reminder and one to view all the reminders. these reminders are recorded on access. i can save the reminder and the other form...
1
by: THEAF | last post by:
OK, i've had quite a few problems with this form and again i have another one. i'm using vb6 and access. THIS IS MY FORM LOAD AND AFTER THE LOOP IS WHERE THE REMINDER CODE IS Private Sub...
3
Shakss2
by: Shakss2 | last post by:
Hi, I have a application which creates a task in outlook on the click of a button. I have made set reminder true. It works fine when it tried on the desktop. But wne tried the same...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.