I have a table in access and I want a code that will automatically send an email if someone tries to delete the any lines within the table. as i know it ask permission to send emails if the person clicks no then I don't want it to delete the line. Basically it only deletes the line if employee allows email to be sent.
I am confused by your explanation. Are you able to supply an example of what you are looking to do. When you say line are you referring to a complete record in a table or just a particular field with in a record. The term "line" is not an access term so I am not sure what you are referring to.
It is a poor development practice to allow users to access tables directly. All work should be performed within forms to maintain integrity. With accessibility to tables it is easy to modify and change things accidentally.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Sorry for the confusion as I am still a novice. when I said line i did mean record. The majority of people do not have access to the tables but a hand full of people do, and occasionally they delete records. What I need is when they attempt to delete a record it will automatically send a email to me and some others. if they decline the email (because my researsh says outlook ask permission) then record does not delete.
I believe you have an issue here. Firstly, as I indicated earlier, users should not have direct access to tables. Second, it is generally a bad practice to delete records in a database. You should alternatively have a field that makes a record inactive. In this manner, no data is ever lost. Just good database practices. I believe you have an education process that needs to be invoked.
Others may have a solution for you, but I know of no way to trigger an email from action that takes place directly in a table. If you do not receive a viable solution in this sub-forum, you may wish to engage the Commercial Services portion of this forum. It is a pay for results sub forum.
okay 2 questions, first does the code i seek exist? and secondaly how do you creat a field to make and entry inactive?
Open your table in design view. Add a new row (field) to the table. Give it a name ie. Active or Inactive and make it a Y/N Boolean Field. Add this to your Form and then in your queries, you can set the field to Y or N to exlcude or include whichever way you go (Active or Inactive).
As to your code question. Anything of this type would have to be developed. I have never seen any code driven directly from a table change. I could be wrong on this. I will ask other Forum experts to look at this issue and determine if they have a solution.
Last edited by alansidman; 11-19-2014 at 10:53 AM.
I have done a little bit of research
https://support.office.com/en-us/art...rs=en-US&ad=US
I have no experience writing Macros in Access. They are different from VBA. I use only VBA.
Do you not have normal Triggers in Access?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks