Search results

  1. M

    Solved Expression Builder for address on Report

    You're a legend!!! I have figured it out and it works a treat. For anyone else that wants to know, replace the comma ( , ) in the code with a semicolon ( ; ) and it works a treat.
  2. M

    Solved Expression Builder for address on Report

    Thanks for the reply and the code example. Appreciate you taking the time. When I put it in I get the error 'The expression you entered contains an invalid syntax'
  3. M

    Solved Expression Builder for address on Report

    Hello First off, I didn't write the code below, I took it from one of the Microsoft templates, so I am not 100% what it all does, as I am not the best at Access. However, it works very well if every field in the address boxes are filled in. The problem occurs when there is a null value in one...
  4. M

    Solved @;[Red]"(Required)" problems!

    Excellent. Thanks for the article - without sounding too much like a geek 'That's absolutely amazing'! I did not have a clue that was possible. Thanks again.
  5. M

    Solved @;[Red]"(Required)" problems!

    Works perfectly now! Thanks very much. Just out of interest, why does this now work? What do the other 2 ';' do? Thanks
  6. M

    Solved @;[Red]"(Required)" problems!

    Hello (yet again) I have been using one of the access templates (Northwind) to build an inventory system... While looking through the template I noticed a really cool feature that I have never seen before @;[Red]"(Required)" on the format of text boxes in the forms. So, I have since used it in...
  7. M

    Solved Loop through using OpenArg on main form and 2 sub forms deep

    Yeah, I was really struggling to find help on google because of it. I genuinely didn't think it was possible as nobody had seemed to ask it before. I'll post the answer in a bit to help other people who might have the same issue. Yes it is Welsh. I'm impressed you knew! Not many people have...
  8. M

    Solved Loop through using OpenArg on main form and 2 sub forms deep

    That works an absolute treat!!! Seriously, thank you very much! The amount of time I spent trying to sort that out!
  9. M

    Solved Loop through using OpenArg on main form and 2 sub forms deep

    Yeah, that's my bad. That shouldn't be there. I have deleted it now.
  10. M

    Solved Loop through using OpenArg on main form and 2 sub forms deep

    I have tried it and it's what is on there now. See image attached. - or maybe I am just not following what you're saying. I tried the text box after update, but I was getting this error 'runtime error 2465 application-defined or object-defined error' I have also attached another 3 images of...
  11. M

    Solved Loop through using OpenArg on main form and 2 sub forms deep

    Thanks for this - I've not experienced writing code in access like this before. Makes sense what you're saying.
  12. M

    Solved Loop through using OpenArg on main form and 2 sub forms deep

    Yes, that all works fine, but when I click on a record from the listbox in the main menu form, it loads up all the records with IDORDERPROSESS (which can be multiple - see listbox in image attached). The first record in the listbox is the one displayed in the tab 'Cyffredinol' but I have no way...
  13. M

    Solved Loop through using OpenArg on main form and 2 sub forms deep

    OK - here you go, sorry took a while to get it down to a good size. Take it easy on me though, just an amateur user who's trying to keep my customers and orders in check ;)
  14. M

    Solved Loop through using OpenArg on main form and 2 sub forms deep

    Unfortunately, I cannot get it to work. I've wasted a whole day on it so far, not sure I am going to crack it!!!! I now get the error 'runtime error 2465 application-defined or object-defined error'. I can't see how it would work with what you're saying as I need the unique ID to open up a...
  15. M

    Solved Loop through using OpenArg on main form and 2 sub forms deep

    Thanks for this - The forms are linked. The difference between what you sent and what I have is that your second sub form default view is set up as a continuous form. I have mine set up as a single form in order to only see one of those records, depending on what the user has clicked in the...
  16. M

    Solved Loop through using OpenArg on main form and 2 sub forms deep

    Cheers for the quick reply guys. Yes, (my bad) they are linked through parent and child fields and not a query. It does give me the records that are all linked. The issue I have is in the last form (2nd sub form) in the chain has a one to many relationship and when I load up the form from the...
  17. M

    Solved Loop through using OpenArg on main form and 2 sub forms deep

    Hello I have spent the best part of the day on lockdown trying to sort an issue out - what I want to do is so simple, yet seems the most complicated thing I've come across so far in VBA. I have tried everything I can find online without any luck! So any help would be great. I am at...
  18. M

    Update query for stock levels

    Right. I see what you're saying now. Apologies... Just one last question then to clarify. Put the stock level in a query and create a transaction table which can trace the orders?
  19. M

    Update query for stock levels

    Thanks for the reply. The query does do the calculation for me. It just get the data from the table to see how much is currently in stock. Then I want the query to update that stock count (in the table) as it has been changed due to the order.
Top Bottom