Setting reminders in Access

  • Thread starter Thread starter Kaleemuddin
  • Start date Start date
K

Kaleemuddin

How can be reminders set in MS Access just like the
reminders found in Outlook.Please look to this
question.Thanx in advance.
 
Kaleemuddin said:
How can be reminders set in MS Access just like the
reminders found in Outlook.Please look to this
question.Thanx in advance.
Click to expand...

Remember, that Outllook is always open in memory. If you truly close it, you
do not get reminders. The same holds true for Access. You will need to keep
it open to run your reminders.

That said, you can build a form with a Timer event that looks at a table to
see if there is a reminder for that date/time which hasn't been opened yet.
Set the TimerInterval property to 60000 (milliseconds) to have the event run
once per minute. This form can be hidden, or in view, but it must stay open.
The Kickemoff.mdb database at my website is a sample of how to get a single
event to fire.

http://www.datastrat.com/Download/KickEm.zip

the birthday database on my website is an example that checks birthdays, but
doesn't have any event code. With a little ingenuity, you should be able to
combine the code, add some, and come up with your solution.

http://www.datastrat.com/Download/Birthday2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
I hope that you have an answer for my question.
I need to pass a date to outlook.
I have a DB in access 2k where i write many date.
There is a date of when the client set an order, the delivery date and every
step of the order is set with a date.
So for example I make an order the 05/05/2003, i must delivery the article
the 30/10/2003 but the client must give me some information the 10/06/2003
and another the 15/07/2003. so i want to set up an appointment for each
date.

After that i sincronize the DB with palm Tungsten, so I always know the
situation of my orders.
Many thanks.
Stefano
 
It sounds like you need to use Outlook and sync your Palm to it. For that,
I'd put the reminders directly into Outlook since you won't be able to sync
up directly with Access because it doesn't run on the Palm. I suggest you
use my Outlook Forms database app to start Outlook and open the proper form.
You can import this directly into your Access database:

http://www.datastrat.com/Download/OutlookForms2K.zip

or for Outlook Appointments only, the following database app will set the
Outlook Appointment directly from Access. It is written in Access 2002, but
will work in Access 2000 (or even Access 97, if converted) with the proper
references set.

http://www.datastrat.com/Download/OutlookAppointment.zip

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
It sounds like you need to use Outlook and sync your Palm to it. For that,
I'd put the reminders directly into Outlook since you won't be able to sync
up directly with Access because it doesn't run on the Palm.
Click to expand...
I can sync palm appointment with outlook and viceversa. no problem

I suggest you
use my Outlook Forms database app to start Outlook and open the proper form.
You can import this directly into your Access database:

http://www.datastrat.com/Download/OutlookForms2K.zip
Click to expand...

I'll try soon.
or for Outlook Appointments only, the following database app will set the
Outlook Appointment directly from Access. It is written in Access 2002, but
will work in Access 2000 (or even Access 97, if converted) with the proper
references set.

http://www.datastrat.com/Download/OutlookAppointment.zip
Click to expand...

access 2002 is ok. I think that this is what I need.
Many thanks.
Stefano
 
Back
Top