If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access database reminder
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. |
#2
|
|||
|
|||
Access database reminder
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" ed the wrote in message ... 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. |
#3
|
|||
|
|||
Access database reminder
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" wrote: 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" ed the wrote in message ... 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. |
#4
|
|||
|
|||
NOT SOLVED Access database reminder
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. "ed the beginner" wrote in message ... 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" wrote: 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" ed the wrote in message ... 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. |
#5
|
|||
|
|||
Access database reminder
ed the beginner wrote:
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" wrote: 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" ed the wrote in message ... 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. 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 |
#6
|
|||
|
|||
Access database reminder
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" wrote: ed the beginner wrote: 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" wrote: 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" ed the wrote in message ... 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. 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 |
#7
|
|||
|
|||
Access database reminder
ed the beginner wrote:
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" wrote: ed the beginner wrote: 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" wrote: 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" ed the wrote in message ... 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. 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 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 |
#8
|
|||
|
|||
Access database reminder
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" wrote: ed the beginner wrote: 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" wrote: ed the beginner wrote: 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" wrote: 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" ed the wrote in message ... 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. 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 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 |
#9
|
|||
|
|||
Access database reminder
ed the beginner wrote:
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" wrote: ed the beginner wrote: 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" wrote: ed the beginner wrote: 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" wrote: 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" ed the wrote in message ... 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. 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 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 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 |
Thread Tools | |
Display Modes | |
|
|