Wrox Programmer Forums
|
VB Databases Basics Beginning-level VB coding questions specific to using VB with databases. Issues not specific to database use will be redirected to other forums.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Databases Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 10th, 2004, 04:11 PM
Authorized User
 
Join Date: Aug 2004
Posts: 48
Thanks: 0
Thanked 0 Times in 0 Posts
Default Delete Printers Table

I want to create some code that will delete printers from my printers table and automatically move them to a deleted table. I want to have this code do everything automatically. I am going to create a form that will ask what printer I want to delete, and when I type the name of the printer, all of the information that goes along with that printer will move into a table called tblDeletedPrinters. We need to do this so that when we delete one of our printers, we can have the information in a table in case we need to run queries on the data. Can someone help me with this?


 
Old September 10th, 2004, 04:45 PM
Friend of Wrox
 
Join Date: Jul 2003
Posts: 128
Thanks: 0
Thanked 1 Time in 1 Post
Default

Chad,
I have a suggestion. Why not instead of deleting those records with
a field DELETED checked, just create a new query that will filter
without this record. Like a query named qryActivePrinters.
The advantage is less maintenance.
John








Similar Threads
Thread Thread Starter Forum Replies Last Post
How to delete all the records in a table Kai Lai Access VBA 2 March 15th, 2016 07:20 AM
Can't Modify or Delete table PatYoda SQL Server 2000 3 December 3rd, 2004 09:41 AM
Deleted Printers Table Teqlump Access VBA 1 September 10th, 2004 05:50 PM
Delete Table Teqlump Access 6 September 10th, 2004 04:25 PM
How to delete two or more lines in a Table??? thomaz C# 3 July 4th, 2003 02:24 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.