Access database reminder

[ed the beginner]

I have a column with “expire date“ and I want to set up a reminder for 5 days
before that date.
It’s possible? How?

Thank you.

 

[tina]

to calculate "5 days before x date", you can use

DateFieldName - 5

or the DateAdd() function - which also works to subtract; see Help for
details.

as to *how* you would use the calculation, that depends on where and when
you want to see the reminder. for a specific answer, post specific
information.

hth

 

[ed the beginner]

I have expire date as march 2008 and as 09/03/2008. in both cases I would
like to see a mesage box, warning, pop up etc. on my screen even when
database is closed. I don't know what kind of date format to use to be easier
to set up. Most of my data is march 2008 format.

 

[tina]

okay. i can't tell you how to run a reminder in Windows, based on data in an
Access table, sorry. suggest you watch this thread for a day or two
(especially as this is the weekend), and start a new thread if you don't get
any helpful responses in that time. if you do end up starting a new thread,
it would be courteous to post back to this thread one last time, to say
you're closing the thread and have reposted to....
good luck with it.

 

[Philip Herlihy]

I have expire date as march 2008 and as 09/03/2008. in both cases I would
like to see a mesage box, warning, pop up etc. on my screen even when
database is closed. I don't know what kind of date format to use to be easier
to set up. Most of my data is march 2008 format.

If you've correctly entered the data into your Access table then you can
subsequently format it any way you like, in queries (using the various
date functions) or in forms and reports.

The puzzle is how to get a reminder to appear when Access isn't running.
Unless you have Outlook available (in which case you could use VBA to
create a calendar item, with reminder) then the only software you can
count on having available is Windows itself. Vista has a calendar
available, I seem to recall, although I've no idea how you can interact
with it from Access. However, you could use the VBA "Shell" command to
add (using the AT or SCHTASKS command-shell tools) an item to the system
schedule, if you can arrange for admin privilege (look into Makemeadmin,
perhaps). The scheduled command could be a command script using the
ECHO, TITLE and PAUSE commands, perhaps, or a bit of VBS using Windows
Script Host.

Phil, London

 

[ed the beginner]

I'll ask again for help, because like in my screen name I am a total beginner
( start using access 4 weeks ago ).

1. I created a table for aprox 500 products

products received expire
date
a 23/02/2008
23/02/2009
b 01/01/2009
10/02/2009
c 10/12/2008
31/12/2010

I like to have a code to search all my expire date column and with 5 days
before to have a message box or pop up with all products due to expire in 5
days.

2. Next I like to create a treeview and to be able to open a form when I
click on the leaf ( is correct? ).

I know I just started but I want to learn and the problem is that I don't
know what and from where. I think it will be helpful to have a small template
or example ( like that I learned my first steps into Access ).

Thank you

 

[Philip Herlihy]

I'll ask again for help, because like in my screen name I am a total beginner
( start using access 4 weeks ago ).

1. I created a table for aprox 500 products

products received expire
date
a 23/02/2008
23/02/2009
b 01/01/2009
10/02/2009
c 10/12/2008
31/12/2010

I like to have a code to search all my expire date column and with 5 days
before to have a message box or pop up with all products due to expire in 5
days.

2. Next I like to create a treeview and to be able to open a form when I
click on the leaf ( is correct? ).

I know I just started but I want to learn and the problem is that I don't
know what and from where. I think it will be helpful to have a small template
or example ( like that I learned my first steps into Access ).

Thank you

I haven't used Treeview controls (I'm not an expert) so I can't help
much with that, but I'd imagine you'd use the DoCmd.Openform method in
the appropriate OnClick event handler.

For the reminder issue, it seems to me that you need to create a query
which identifies the items which are due to expire in 5 days or less,
and load that into a recordset. You'll need to learn how to run a query
in VBA using DAO (or ADO). Have a look for "OpenRecordset" in Help or
online. Then you'll move through the contents of the recordset
(DoCmd.GoToRecord), issuing the "Shell" commands as described above.

Phil

 

[ed the beginner]

Hello again.

I managed to create a query that is showing all records with expire date in
next 5 days. My question is what I have to do, learn or where I have to look
to have a message or warning that will show the query everytime I open the
database?

Thank you all.

 

[Philip Herlihy]

Hello again.

I managed to create a query that is showing all records with expire date in
next 5 days. My question is what I have to do, learn or where I have to look
to have a message or warning that will show the query everytime I open the
database?

Thank you all.

Look up AutoExec (a macro) in Help. In general, anything at all complex
should be done in VBA, but macros are good for simple things like this.

Phil