Thankyou for such a quick reply, Ah yes sorry I derped on my initial bottom code send it was indeed meant to be serialscan my apologies. Worked a treat! Very happy with that run some msgbox(SerialIDScanSearch) tests just under it to see if it pulled in the correct ID each time and passed 10/10...
Hey everyone,
I'm trying to set up a lookup on a table that logs some serial numbers for a little side project of mine. I log the serial numbers of items into a table called tbl_serialnumbers. However, I've been implementing the option of allowing Part Numbers to be used when a serial doesn't...
Thanks you two! I'm really sorry it took me a few days to reply was unwell so only just had the chance. I admit I feel very silly, my code directly below uses similar but for some reason I failed to apply this method on the Dlookup... Thanks very much! Have a great rest of your day!
Good evening all!
I hope this is ok to post, I've gotten a little stuck on my project. Basically, I'm setting up a barcode scanner for goods in and goods out project. I'm working on logging serial numbers for product allocation, so that when I scan a barcode it will run a few checks first just...
Ok i've followed the instructions here. Seems to be able to link the file again but doesn't seem to add any 'new' tables within the same file? tried testing it by making a new table and saving it with an obvious name and then loading the front end after saving and exiting but it won't add it to...
Hello all!
I'll start by saying although I've been using access and VBA now for a few years I'm still very new and this may be something super easy so I apologise if this is a very dumb question. I've been trying to find a solution to this for the last 2+ hours but can't quite find what I'm...
Sorry I should have taken the time to structure it better. Appreciate the help that makes a lot more sense I don't know why I didnt use a Dmax to begin with. Have a nice day.
Hello! I've got a really wacky weird problem i'm trying to solve. I'm trying to create a small loop thats going to generate the next number in line for a "linked purchase order" the first 3-4 digits will be the master purchase order number and the last digit is there to be an incriminate in case...
I'm not sure how to post pictures so i'll do my best to explain it. I have potentially 9 boxes that have %'s all are default at 0 to begin with. The PercentChecker has the control source of...
Hey all. I'm trying to write some code that checks if the % of a text box (formatted as a percentage with 2 decimal places) is at 100.00% but i cant seem to get it to work. :( I've tried a few things which i'll list after my code :).
PercentChecker is the text box holding the % and is...
Hey all! Hopefully something simple, I think i'm just brainfarting this code, i'm trying to use a Variable to store a Dlookup value. I want to look up the "Unit Price" of the selected item from my Purchase Orders Details table.
CurrentBuyPrice = DLookup("[Unit Price]"...