microsoft access training - how do you manipulate
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training - How do you manipulate text in rejections?

microsoft access training - How do you manipulate text in rejections?

resolvedResolved · Low Priority · Version Standard

replyReply Tue 17 Jul 2007, 08:54Delegate Dan said...

Dan has attended:
Access Intermediate course

How do you manipulate text in rejections?

for example: rejection reason below.

The field <name> cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field. (Error 3314)

How do you manipulate the text so it is more user friendly, i.e. the text should read - 'please enter order number'

thanks

For upcoming training course dates see: Pricing & availability

replyReply Tue 17 Jul 2007, 15:38Trainer David said...

RE: How do you manipulate text in rejections?

Hi Dan,

I would do this using vba. You will need to write some code to validate the input into a form. If the input is not valid you can then display a message box which will display the error message that you want.

Hope this helps
David

 


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard