Recent content by monk_1987

  1. 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.
  2. 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
  3. 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...
  4. 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...
  5. 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!
  6. 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.
  7. 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...
  8. 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.
  9. 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...
  10. 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 ;)
  11. 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...
  12. 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...
  13. 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...
  14. 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...
Top Bottom