By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,587 Members | 1,020 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,587 IT Pros & Developers. It's quick & easy.

'delete event' in tables?

P: 1
Hi,

I'd just like to know how to catch the delete event for tables. In other words, how can I tell Access to do something first before deleting records in tables..I know that there is a delete event for forms, is there a same event for tables?

Warren
Aug 31 '06 #1
Share this Question
Share on Google+
3 Replies


PEB
Expert 100+
P: 1,418
PEB
In fact for the tables I think NO! But for the queries that use tables there is one or two properties that you can try!

Application.Screen.ActiveDatasheet.AfterDelConfirm
Application.Screen.ActiveDatasheet.AfterUpdate
Application.Screen.ActiveDatasheet.AllowDeletions
Application.Screen.ActiveDatasheet.AllowEdits
Application.Screen.ActiveDatasheet.BeforeDelConfir m
Application.Screen.ActiveDatasheet.BeforeUpdate
Application.Screen.ActiveDatasheet.DataChange

If you try some of those property, I'm curious to know what happens! Please tell us! For me it's very interesting!
Thank you!
Aug 31 '06 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Tables are for storage only. How are these records being deleted?



Hi,

I'd just like to know how to catch the delete event for tables. In other words, how can I tell Access to do something first before deleting records in tables..I know that there is a delete event for forms, is there a same event for tables?

Warren
Aug 31 '06 #3

PEB
Expert 100+
P: 1,418
PEB
The way you can use those properties is the next:
Application.Screen.ActiveDatasheet.AfterUpdate="=L og_OAS()"

Where Log_OAS is a customer definied function!
Aug 31 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.