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
|
|||
|
|||
information massage when a record entered to the DB
hi,
I want to know if i can get an information massage when a new record enters to my database, 1. when the access program opens. 2.when the access program close. remark! the records coming from the intra-net, not from the access program. my access version is 2003 thanks! |
#2
|
|||
|
|||
information massage when a record entered to the DB
No. Access lacks triggers. There is no event that fires at the engine level
when a new record is added. You will therefore need to design it at the interface level, so that when your (browser-based?) interface appends a new record, it also sends the (email?) message to give you the notification. Alternatively, you would need to leave Access running, with a form open, and use the Timer event of the form to periodically check for new records and SendObject to fire the email. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "rach" wrote in message ... hi, I want to know if i can get an information massage when a new record enters to my database, 1. when the access program opens. 2.when the access program close. remark! the records coming from the intra-net, not from the access program. my access version is 2003 thanks! |
#3
|
|||
|
|||
information massage when a record entered to the DB
thank you,
can you explain me how can i design it at the interface level ? No. Access lacks triggers. There is no event that fires at the engine level when a new record is added. You will therefore need to design it at the interface level, so that when your (browser-based?) interface appends a new record, it also sends the (email?) message to give you the notification. Alternatively, you would need to leave Access running, with a form open, and use the Timer event of the form to periodically check for new records and SendObject to fire the email. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "rach" wrote in message ... hi, I want to know if i can get an information massage when a new record enters to my database, 1. when the access program opens. 2.when the access program close. remark! the records coming from the intra-net, not from the access program. my access version is 2003 thanks! |
#4
|
|||
|
|||
information massage when a record entered to the DB
Allen already did explain.
In your code, where you have the code to append a new record, you need to include code so that it also sends the message to give you the notification. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "rach" wrote in message ... thank you, can you explain me how can i design it at the interface level ? No. Access lacks triggers. There is no event that fires at the engine level when a new record is added. You will therefore need to design it at the interface level, so that when your (browser-based?) interface appends a new record, it also sends the (email?) message to give you the notification. Alternatively, you would need to leave Access running, with a form open, and use the Timer event of the form to periodically check for new records and SendObject to fire the email. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "rach" wrote in message ... hi, I want to know if i can get an information massage when a new record enters to my database, 1. when the access program opens. 2.when the access program close. remark! the records coming from the intra-net, not from the access program. my access version is 2003 thanks! |
#5
|
|||
|
|||
information massage when a record entered to the DB
Your original post said:
remark! the records coming from the intra-net, not from the access program. If this means your interface is a browser, it probably uses ASP or PHP to access the database. If so, you need to modify the code in the ASP or PHP script. If the database is being opened in Access across your network, you can use the AfterInsert event procedure of the form. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "rach" wrote in message ... thank you, can you explain me how can i design it at the interface level ? No. Access lacks triggers. There is no event that fires at the engine level when a new record is added. You will therefore need to design it at the interface level, so that when your (browser-based?) interface appends a new record, it also sends the (email?) message to give you the notification. Alternatively, you would need to leave Access running, with a form open, and use the Timer event of the form to periodically check for new records and SendObject to fire the email. "rach" wrote in message ... hi, I want to know if i can get an information massage when a new record enters to my database, 1. when the access program opens. 2.when the access program close. remark! the records coming from the intra-net, not from the access program. my access version is 2003 |
Thread Tools | |
Display Modes | |
|
|