troubleshooting Question

how to Recycle unused Numbes in Device tracking Data base (inventory)

Avatar of jacob wallace
jacob wallace asked on
Printers and ScannersMicrosoft AccessDesktops
8 Comments2 Solutions124 ViewsLast Modified:
ok im so im not an access guru. but i have made and inventory tracking system specifically for desktops and printers using auto numbering and a naming convention of WLHWS"000" so i have everything i need my data base to do but one thing. i hope you can help. i have set up a macro ( i think its called ) that when the device status changes to Decommissioned, to delete record.. but we want that name in the auto numbering sequence to select the next available name/number. example Device names 001-010 is active. i decommission 005. new device comes in and i enter it in the data base., but.. next avaliable name is 011 when i need it to be 005. i hope it make sense. anything would help thanks.
ASKER CERTIFIED SOLUTION
als315

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros