Search results for query: *

this is an steel inventory database for example if I had a steel flat bar when received was 240"long . I needed a piece that was 36" long I return to stock 204" long . the next day I use up 120" inches and return 84" to stock now six months later I call up this piece...

The 3 field I'm looking at are second returned length, first returned length and received length. I want query to start with second ... field and when is it see's it emty to go on to the first ... field and if its empty to go to th receivrd field . any help wold be greatly appreciated I have a...

Will keep on Trying ,thanks a million until next time my friend

Morning Paul I've tryed your code no success .?? What data type should i be using @ this time it is text

Will Do And Let you Know in the morning Thanks

next value in a three digit sequence. I'll use a PLate for example . the plate will be inputed into the database using the plate stock order entry form . a Copy of the Purchase Order will be sent to the receiving . A couple days later the order comes in the receiving dept. go to the receiving...

Looks good But room for error by typing in the last three digits. Do you have any secrets on how I can get a good VB source code for Baycar Code Field. and on how to install it I'm very green when it comes to VB codes and In where and when to install it. Thanks again for you help

Well it was easy I got it to work just before receiving your e-mail thanks . Now if I may is their an other way to make my year,month, number code to work with out Vusal Basics????? As I do have over 3000 pieces in stock at this time and the number were typed in so I don't want this affected...

Ok! created a a append query append to new table called used inventory with the same field as the main inventory table. In the Field called "NO" under append My choice was "used inventory.*" the asterisk is giving me an error can't match the field and "8 " under...

Perhaps still not clear I have One "field" called Baycar Code being 03-12-999 this code was typed in excel now i've transfered all of the inventory to access. 03 is the year 12 is the month 999 is the pc of steal coming into stock.This code number would be great to be set automatic ut...

Ok Paul here's a little more info It not Stell But Steal industry Ha! ha! The product code is year, month, and number of piece that came in that month. I've looked @ many Visual Basic code for this field but yet to make it work for me. but I do have a field called "No" , using numbers...

I'm in the stell industry so fo excample lets say have 30 pcs of angles that tha are the same size each has a different code number to identify it now i've used one piece completely .In lieu of deleting this pc from stock I need to transfer it to an other table . I have a NO field in my table I...

first field is year and -month togethersecond field is an autonumber I Want it to automaticly istall in the new field called "Code" Now the product is inputted as a purchased Item I would like mY "code" to input at the receiving form after I called Up the product using the...