Recent content by Alix

Thanks Mate ;) I appreciate Now how can i customise the error message:confused:

Thanks Mate But what code should i put there?!

Thanks guys But what you said is very professional i didnt understand is there any way to use VBA to do this (and easier)

I have a form with a field called Costumer Number i'm looking for a visual basic code (Or any MS Access properties) to help me make sure none of the customer number are repeated because they are unique. I appreciate any help you offer me

any help?!

Thanks Mate But actually i didnt use 'Input Mask', my data type for my field is number so normally i'm getting pre-made error message i was wondering IF i can costumise the error and replace it with my own one! any way thanks

Hi Guys I'm very newbie to access, i have some question about error messages. I my form i have a field with 'Number' properties, so when i input an alphabetic i've got an error which is great but how can i customise the error message? and then how can i change the error title which is "Microsoft...

Thanks Alot Works perfectly and you think now the form update the date itself?!

you mean the capital and small really makes difference? I'll double check it and let you know

I made a "Unbound text box" and used "=DateDiff("d",[Date of Request],Date())" as the text box control source and when i checked the my form there were " #Name? " Date of Request => is my field name which specifies the date of request that i want subtract it from my todays date. before i...

Thanks you Both I'll test it and let you know what was the result! Have fun

actually i dont know anything about those tuff you named i ment for example if todays date is "30/3/03" and the day that a paper recived is "10/2/03" so the difference is 20 days but tomorrow which is 1/4/03 if i dont check all fields the difference is still 20 days i want all my fields refresh...

Thanks alot You guys make life easier :)

All right I've already created the queries and reports when user clicks on the report icon a message box ask him/her to input some information like name, candidate number and etc and then it looks into my table and collect those information and set it as a report but i want my report to be...

Thanks alot, works properly sorry another question; is there any way to make it for further clicks for e.g first click red, second one yellow 3rd black etc