Search results

  1. S

    Solved Can I use Dlookup/DMIN lookups within VBA where part of the criteria is looking for a 'null' value in a field?

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

    Solved Can I use Dlookup/DMIN lookups within VBA where part of the criteria is looking for a 'null' value in a field?

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

    Solved VBA - Looking up a 'Auto Number' Primary key off a scanned variable.

    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!
  4. S

    Solved VBA - Looking up a 'Auto Number' Primary key off a scanned variable.

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

    VBA code for relinking 'new' tables from back end(.accdb) to front end database.

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

    VBA code for relinking 'new' tables from back end(.accdb) to front end database.

    Oooo not heard of that before taking a look now thankyou will update shortly once I've digested this info!
  7. S

    VBA code for relinking 'new' tables from back end(.accdb) to front end database.

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

    Loop until a value is null

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

    Loop until a value is null

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

    Solved If statement to check if a text box holding a % is at 100.00%

    got it working funnily enough changing it to single instead of integer was the solution haha. Thankyou @arnelgp
  11. S

    Solved If statement to check if a text box holding a % is at 100.00%

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

    Solved If statement to check if a text box holding a % is at 100.00%

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

    Solved Dlookup with multiple NUMBER/Integer Criteria.

    Doh that makes sense! Thanks everyone working great now!
  14. S

    Solved Dlookup with multiple NUMBER/Integer Criteria.

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

    No filtering if a text box has a Null value.

    Works beautifully! Thanks so much mate! :D Exactly what i needed! Have an awesome day !
  16. S

    No filtering if a text box has a Null value.

    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!
  17. S

    Record Locking

    Hmm i cant seem to control my records from within VBA at all at the end. Says saving is not available and it wont let me create a new record either.
  18. S

    Record Locking

    Ah I see so if i've finished with the form i could get around this by telling it to go to a new record and then updating the yes/no box perhaps as the form would no longer be using the record?
  19. S

    Record Locking

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

    Front End Database not able to create a 'new record' on one machine

    Fantastic thanks i'll look at doing this ASAP this morning thankyou! Will come back shortly
Top Bottom