Windows 7 64bit 
Access 2007
I have a DB that we track our wires in the building where they are going from and to. When we are adding new equipment we need to reserve a group of numbers so we can label our wires then input the data at a later time. Obviously we can't have 2 different wired with the same number or that would create havoc. In the past we would just pull a group of numbers out of thin air and see if that range was in use but that has created huge gaps in our numbering. The DB that I have we can look up gaps in numbers so we can utilize those numbers. what I am having issues with is being able to reserve the numbers in 1 shot instead of having to go in and create a new record individually for each wire number. I tried to attached a sample of our DB but I cannot get it smaller than 22mb no matter how much I delete out of it. Any help would be useful as I have been searching for 3 days just trying to figure this out. Sadly I don't know much about Access but everyone else here knows even less
Reply With Quote
