Hi all, we use a scanner to scan part barcodes when booking in to stock
example of part number on label
PWR-C5-600WAC=
actual scan inputs in field as
1PPWR-C5-600WAC=
so as you can see it add 1P which is what we need to remove
same as serial
ART2509D1S9
actual scan
SART2509D1S9
so need to...
still getting errors, ive renamed subform to GoodsInwardDetails and also attached copy of mockup if you would be so good to see whats wrong with it please
so the subform is called "GoodsInwardDetails" and the field is called "SUNumber", how do i name these in focus?
is it GoodsInwardDetails_Subform or just GoodsINwardDetails?
Thanks
Hi all, a bit rusty as not used access in a while but decided to create new database so getting back to grips lol
anyway i have form called goodsinward and subform goodsinwarddetails
how do i move from field in form (after update) to field in subform ?
Ive tried these but getting error...
please see above there are a few examples and also what the stock is its basically just booking in part in and out with no costs, suppliers etc..just for our records what comes in and when sent out but muliple parts against 1 ref no in and same as going out
I've managed that bit before it's the actual sending out
So I create a box of mixed screws to send some where
Box of screws has a shipment no
And screws in the box can be
Su1
Su4
Su6
So rma on this part doesn't exist really
Every single screw will have an su number but the box they come in will have an rma number. If I got 2 boxes of screws then there would be 2 rma numbers but every screw needs a su number
Rma 1 box of screws no 1 with 3 screws
Su1
Su2
Su3
Rma 2 box of screws no 2 with 4 screws
Su4
Su5
Su6
Su7
😊😊
Ah right yea I will re do this.
The su number is like a licence plate for the part and we have a roll of stickers for these that we attach to all the parts out of the box and is very important as it seperates the parts so to speak as all the parts in the box could be same part number and not...
It's getting there but when i scan SU out it doesnt populate the part fields etc. ive attached if you could have a look please lol
I have attached database now and also a pdf that maybe explains it better hopefully lol
here is were i am at, the goods in works fine and it is now just when we are sending the parts out as getting duplicate error ?
we need the same as goods in for goods out but when we scan the su number this then pulls data in from the goods inward for part number and serial...ive tried...
Hi all,
I have attached a sample copy of database as trying to get back in to access again and a bit rusty !
Can someone help with this, i am sure its simple but i am missing something and if you could explain lol
So if you look at goods inward this is fine !
The problem is i am trying to...