dear ISV's
i am trying to print label in the report using vba. with some conditions for printing.
for example:
if one of the input value is above the stored value in the table(database)
i want a warning message or Error message or exit:
which i want something look like this " Plz enter the correct value" and should exit .
But now my current situation is this , when i enter the value above the stored value in table. it allow me in to the report.
But the report showing the result like this for the above condition:
"#error"
Plz give me some sample expressions for error message
regards
Niyaz
pl help ,how to give warnings or Error Messages in Access Reports
KatyG
Per the support engineer:
If you are using the office version before office 2003. You can make a form by vba to insert the data into database, do data validation in the form. If the data is not validate, the form promote a message box tell user the reason why. Insert data directly in database is only for very perfessional programer use.
But if you have office 2003, that would be very easy to do this:
In Access 2003 table design view, we can set the Valiadation Rule and Valiadation Text. The Valiadation Rule is a fomular, you use this fomular to valiadate the data user inputed. The Valiadation Text is the text will promote, when the data is not valiadate. They are just what you need.
The engineer also included a screen shot that I can't post here. If you'd like to see it please email me at budsup@microsoft.com.
-brenda (ISV Buddy Team)