Search results

rzw0wr this worked GREAT! thanks 1 question though With rsWireList .AddNew 'tell recordset we are going to add new records ![Wire Number] = intWireEnd ' input wire number into recordset. will be add to the bottom but does not matter 'If you need to change what you are adding...

my race car :) and have a good weekend yourself!

nope this weekend I will be racing :) again thanks SO much!

OMG thanks! lol I never would have figured that out on my own!

thank you so much for your help! I greatly appreciate it! I'll look at it tonight then get back to you on Monday :) damn how in the hell did you get it to compress that small :)

actually there is already a field for that. the field is called done. if it is a 1 then it is done, if it is a 2 then it is reserved ya All I need the script to do is in the done field add a 2 and in the wire number field add the wire number from x to y so say you want to reserve 5 numbers...

wow now that you point that out I just looked and ya you are right about the bug! I will have to look at that! now that we have the gaps I want to be able to pick say 20 or 40 numbers out of that gap and reserve those numbers so no one else can pick them.so in other words if we need 15 numbers...

There is another button on the choice form that I think I took off to simplify the DB for upload where they can search for missing gaps of numbers Edit: I looked again at the sample DB and the search is still on the choice form. and all those queries are needed to search for the gaps...

we have been using an old Lotus db program as for the starting and ending numbers those would be user selectable. basically a text box on the form asking what number you want to start with and how many numbers you want to reserve either that way or have the end user input the beginning number...

no! basically we would be reserving about 20 to 40 wires at a time. currently we have about 10k wires total. the issue is that we have gaps in the numbering say from 5000 to 5500 so we would like to fill those gaps so we might reserve wire number 5001-5040 and print out the labels. as we...

btw just gave you a thanks for the help :)

it is 8:00 here. I am in California. the sample BD I deleted out most of the wires just to make it a little smaller. we have over 10k wires here at the station. as for the wire number itself we put the number on each end of the wire when we pull it so we can look up where the wire is going...

ya dropbox is a service that allows you to upload files for others to be able to download. the DB is called sample.mdb

well now I should be at 10 :) https://www.dropbox.com/s/48cyr4o9w8cbn7b/sample.mdb

post ***** so I can be at 10 :)

still over the limit :(

I deleted all the records and extrA forms and zipped it up it was still 6mb which still exceeds the 2 mb limit for a zip file. Then I uploaded it to Dropbox and that's when I found out about the 10 post minimum for adding a link :(

in about 3 more posts I can add a link to my DB but I have no idea how to even get a DB to be only 2mb as per the sites requirements!

ok the good news is the single quote allows the script to run. the bad news is that nothing happens in the table! ok I didn't refresh! :( but what happens is under starting number I put in 20 and under wire number I put in 40 and there was only 1 record created with wire number being 40 Edit...

ok unfortunately like I said before I am not that good with access but I am learning. In trying to decipher and "reverse engineer" what you posted so I can make it work in my DB I got stuck in a couple of places. so to test this I created the most basic DB just to make sure it would work what...