Recent content by meanster99

Thanks vbaInet - in my ignorance I hoped it would be an easy fix! Thank you for taking a look at it and for the validation link. I look forward to your response later...

Hi guys, It seems no one can help me with this issue! Therefore, does someone know of another postcode format validation that I could use that has been tested in Access 2007 running on Windows XP? Many thanks in advance....

I have used the following code to validate UK postcodes in an Access 2003 database. Everything works fine with no apparent problems. However, I have given the database to a friend who has Access 2007 - when he tries to enter a postcode (in the postcode field on a form, that has the function set...

great advice mailman - I always follow that naming advice but never thought about it for modules!

Hi dcb - I have worked out what the problem was - my stupidity! I had named the module dMsgbox aswell as the function which was causing the compile error. Many thanks for all your help with this. It took a while I know, but you perservered with me. Lekker!

Thanks dcb thats exactly it! You are a legend. The only shortcoming it has at the moment is that it only works if I put the function in the form rather than have it as a public function in a module. If I have it in a module I get the error message : expected variable or procedure, not module...

Strangely, that doesn't work for me. I am using your original Msgbox function you provided for me. I am looking to create the same message box as the code below produces but using your function so that I get the xp style buttons: If MsgBox("Changes have been made to the record for: " _ &...

Thanks dcb - I did use call but didn't use the brackets as I should have done which is why it didnt work. I have tried playing about with the dmsgbox and fmsgbox functions dcb and CDrake gave me to include the field names I need to display but I can't get them to appear where I want them. Any...

Thanks guys. Wazz - thats excatly what I had tried but I get the error message: expected variable or procedure, not module DCrake - I can call your function and it works as it should but is it possible to include field values in the msgbox like I do below with ordinary msgbox statements: If...

Hi dcb Many thanks for taking the time to write this function. I can sort of see what it is doing but I am a complete noob with vba and I dont know whether this goes in a module or in a form and how I actually use it! Any pointers would be greatly appreciated!

Unfortunately not Wazz. It makes no sense to me - why is it only when I use msgbox in vba that the OK/Yes/No/cancel buttons appear in the old flat style. However, the following code displays a msgbox that does have the XP style buttons, even though if I just use msgbox and not the Eval...

Hi guys, I have searched for an hour now but to no avail! Can anyone tell me how I enable the XP style for my Msgbox buttons? Any command buttons I create on forms are in the XP style but when I use Msgbox in VBA they appear in the old flat (ugly) style. It must be a simple thing to do - I...

Its OK - I have found the problem. I needed to reference the Microsoft Office 11.0 Object Library - I don't know how I missed it - I checked the references three times!! (as it is nearly always the problem with this type of error)

I copied and pasted all of the code from the Northwind sample database that allows you to add/change an employee's photo. I checked I have all the same references and have declared all variables but I still get the error "Compile Error: Variable not defined" at ...

You dont necessarily need to use vba for this - you could use conditional formatting. Select [UnitsOnHand] and then choose conditional formatting (format menu). It should be self explanatory but you will need to enter : Field Value Is Less Than [ProdReorder] (and color it how you want) HTH