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

How to delete multiple records on a form?

P: 24
Hi All,

I have an existing inventory database that I'm trying to make changes to. The database only has 1 table with the following fields:

PartNumber
ItemDescription
Category
Location
Owner
SerialNumber.

Currently I'm using the delete button to delete a single item. However this is not really efficient if I have to delete 300 disk drives. I do have the add multiple copies working thanks to Bytes! So, I'd like to do the same thing for the delete but with a twist.

I created a seperate command on my form called 'cmdDeleteMultiple' and an unbound text box called 'NumberDeleted'. (I only did this in Design View). However I would like for the 'cmdDeleteMultiple' and 'NumberDeleted' to be greyed out or hidden when the 'SerialNumber' field is populated. The 'SerialNumber' field has text as the Data Type.

Is this possible?


Thanks,

Kevin
Sep 17 '08 #1
Share this Question
Share on Google+
1 Reply


P: 24
More questions about this....

How will the delete command know what to delete when it has to delete multiple copies? The copy command selects the record and just creates a duplicate but the delete is much different because it will have to know which record to delete.

Thanks,

Kevin
Sep 18 '08 #2

Post your reply

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