Search results

is this after update event and can you give example please - field name is PartNo and SerialNo

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...

AHHH great thanks, i didnt even think of the nameing in the fields section.. cheers.. i did say i was rusty lol

yes i do but seems coding seems to have changed since i last used it on access 2013 😂😂

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...

sorry i maybe should have mentioned but wanted to keep as simple as possible actually there are no invoices or charges involved and stock simply gets delivered and collected all stock is owned by another company and we simply store and ship for them. all these are is for our records only

Hi all, I will keep this as simple as i can so not to confuse anyone i hope lol I am trying to create a database to log all stock items coming in and going out to and from carriers or couriers as currently this is all done manually. When goods come in this can be 1 item or 20 items and they...

Hi all, I have a query and report that shows invoices with invoice date obviously ? My accountant wants data from the last 3 months records ? March,April and May invoices and next time June, July and August i want the criteria so code will simply show the last from months only and...

Access 2010 Hi all, We have a list of unique numbers on our database and then someone comes to do audit with what should be the same as ours so looking for a way that when we import their list it looks at ours and shows any queries for missing or extra items ? The code is the unique number...

Hi all, I am creating a simple database to keep records of stock movements. We have parts that come in and out of our warehouse all which will be scanned at time of movement. I am thing I will need a few tables and relationships for this and this is the main advise that I will be...