Err.Description vs AccessError()

[Daniel P]

Hello

Could someone illuminate me on the difference between these two functions and which should be used to display error messages to the user

Also, I saw in another post the Error$() function and have no help information on it...what is it all about

Thanks

Daniel

 

[Allen Browne]

AccessError() shows you what the generic message is for a particular error
number. You can use this even when there has been no error.

Err.Description contains information about the error that occured. It may be
more specific than the generic message. For example, the generic message may
contain a pipe character as the place holder for a field name, whereas
Err.Description gives you the actual name of the field that generated your
error.

Error$ is a very out-of-date equivalent, dating from the days of Access
version 1 and 2. It works, but is there just for backward compatibility.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Could someone illuminate me on the difference between these two functions

and which should be used to display error messages to the user.

Also, I saw in another post the Error$() function and have no help

information on it...what is it all about?