Req A Gentle Help

[Guest]

Hi,
I m new in MS Access. I want to change the mouse pointer into a hand Icon
when it moves over a control. I donot want to use a dummy hyperlink. I
already used a "mousecoursor(ID_Hand)" command but an error of "function or
subfunction not define" comes. the mouse move event has also a code of
changing fore color of control. I will be greatly thankful for a
COMPREHENSIVE reply.

 

[Rob Parker]

It sounds as if you're trying to use the MouseCursor() function from The
Access Web:

http://www.mvps.org/access/api/api0044.htm

If that's the case, have you copied all the code from that page into a
separate module in your database, and saved it (you need to give the module
a different name to the names of any of the function within it - I name the
module MousePointer)? If you haven't done so, you will get the error you
describe (or similar - when I check with Access 2002 the wording is slightly
different).

To call that function directly, you can simply put the following in the On
Mouse Move property of your control:
=MouseCursor(32649)

If you are running other code from the MouseMove event, you can call the
function within from your code, by using:
Private Sub Command2_MouseMove(Button As Integer, Shift As Integer, X As
Single, Y As Single)
'other code as required
MouseCursor (IDC_HAND) ' MouseCursor(32649) can also be used
here
End Sub

Note that the call using the public constant IDC_HAND will only work in
code; it will not work if the function call is entered directly in the
property box.

HTH,

Rob

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George