deleted queries
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Deleted queries

Deleted queries

resolvedResolved · Medium Priority · Version 2007

replyReply Tue 24 Jun 2008, 16:12Delegate David said...

David has attended:
Excel Intermediate course
Excel Advanced course
Access Intermediate course
Access Advanced course

Deleted queries

I want to save the deleted queries in order to have a record of the detailed queries

For upcoming training course dates see: Pricing & availability

replyReply Wed 25 Jun 2008, 11:45Trainer Stephen said...

RE: Deleted queries

Hi David

Thank you for your question

Your best bet would be to first run the query as a make table or append query and write the data to be deleted to a seperate table in which you can store archive data

You could then run the delete query

Hope this is useful

Regards

Stephen

replyReply Wed 25 Jun 2008, 12:31Delegate David said...

RE: Deleted queries

Thanks Stephen, I'll try this. David

 

Please browse our web site to find out more about
microsoft access courses and other Microsoft training courses.

Access tip:

Closing form after a certain time period

To make a form close automatically after a certain time period, you need to assign the close function to a macro.

Save the macro and ope up the form in design view. open the Properties sheet.

In the TimerInterval property enter the length of time you want the form open for. This should be in milliseconds, so for instance if you want the form open for 5 seconds enter 5000, for an minute enter 60000.

You now need to attach your macro (to execute the Close action) to the OnTimer event property of the form.



View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard