How to use "UsrMsg"

[vepha]

Hi Everyone,

For some it may be a dumb question but can anyone tell me how to use
"UsrMsg()" from http://www.pacificdb.com.au/MVP/Code/UsrMsg.htm. I have tried
many ways but i couldnt get it work. Greatly appreicated your help. Thank you
all very much.
Regards;
vepha

 

[Steve Schapel]

Vepha,

First of all, you would need to copy/paste the code from Graham Seach's
article into a standard module in your application. Note that it
requires a Reference set to ADO.

Then, in the appropriate place in your application, you can write the
equivalent of this into a VBA event procedure:

Call UsrMsg("This is the text of the message you want to show to your
users.")

 

[Ana]

Something like?:

Dim UsrMsg As Module
Call UsrMsg("This is the text of the message you want to show to your
users.")

Ana

 

[Steve Schapel]

Ana,

No. "Dim UsrMsg As Module" doesn't mean anything or achieve anything.
Just drop that bit.

Perhaps you could explain what the problem is? Did you try what I
explained before? Didn't it work? What was wrong?