Search results

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

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

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

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

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

Hi! Quick question I want to run a query that used as a datasheet table as a subform. I'd like the sheet to display all records if a CustomerID box is Null but filter IF the box has a value to just that customer ID. Is this possible? Thankyou have a fantastic day!

Hi all, i'm trying to understand record locking and how to use it correctly within my new form. The designs a bit....strange managing customer accounts with a sub form that allows the user to put an order through as well. It seems to work really really well however on my submit button Access...

Hey all! I hope this is the correct place to ask my question sorry if its not! I've got an odd problem i'm trying to solve..... I have a fairly complicated form that is for handling Batch creation of products, adjusting stock levels and updating pricing. At the end of this process I use the...

Hey all hopefully a quick question and quick answer. I've used plenty of 'yes/no' msg box prompts before but i'm wondering its its possible to change the text of yes/no to give slightly more control over the question i'm asking my user. I want to ask in my message box if the user wants to refund...

Hi everyone! I've tried searching the forum here and have been a fairly long time lurker but sadly i'm running into a bit of trouble understanding something i imagine is very basic for all of you experts :(. I've been working on a database for sometime now nearly every day and am trying to add...

Hi Everyone! I'm fairly new to access I started in January this year when the whole work from home phase happened and i used access as a little mini project for myself to learn to help my own workflow improve which has suddenly taken off to be used within a mini department at my work. I'm...