Recent content by monk_1987

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.

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'

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

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.

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

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

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

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

You're a legend! Thanks.

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

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

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

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

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 ;)

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