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

Users can "Delete" but not from database

blyxx86
100+
P: 256
I am trying to find a method of allowing users to 'delete' data from the database, but without that information actually being deleted. Is there a possibility of some sort of code or macro that would move the information to a separate table(s) when they click the "Delete Record" button? I know I could execute something similar with a delete command button, but I don't know how to do that with the standard Access toolbar "Delete" ... am I making sense?

If you can cipher out what I'm trying to accomplish and can think of a way to do that, could you please let me know?

Thank you very very much.
May 18 '07 #1
Share this Question
Share on Google+
2 Replies


JConsulting
Expert 100+
P: 603
I am trying to find a method of allowing users to 'delete' data from the database, but without that information actually being deleted. Is there a possibility of some sort of code or macro that would move the information to a separate table(s) when they click the "Delete Record" button? I know I could execute something similar with a delete command button, but I don't know how to do that with the standard Access toolbar "Delete" ... am I making sense?

If you can cipher out what I'm trying to accomplish and can think of a way to do that, could you please let me know?

Thank you very very much.
create a yes/no field in your table.
call it inactive
instead of deleting, you set this field to true
in your recordsource for your form, create a query that filters out inactive
J
May 18 '07 #2

missinglinq
Expert 2.5K+
P: 3,532
I've used J's approach before, as well as using a query to append the record to an archive table, then deleting the record from the active table.
May 18 '07 #3

Post your reply

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