Access MouseOver?

[cyberdwarf]

Anyone got any idea how to imitate a mouseover event in Ms Access 2002/2003?

I have the feeling I'm probably onto a loser here...
TIA

Steve

[pks00]

mouseover? do u mean do something when u move the mouse over a certain control?

U cud have a look at the MouseMove event

[cyberdwarf]

I don't think that will give me what I'm looking for.

I need to track which detail row the mouse cursor is over, within a scrolling form of multiple records...

Can't see how to pick up the Primary Key, for example, of the particular row under the mouse cursor...

Thanks anyway

Regards

Steve

[Rabbit]

I don't think there's a way to do what you want.

[pks00]

You can pick up the cursor positions using api functions like GetCursorPos. But for what you what, identifiying records, that I dont think is feasible.
The records displayed could be different records displayed so you cant even sort of fix it.

[NeoPa]

We've been here before CyberDwarf (Mouse & Subform)

Please visit this thread to see why we would rather you didn't double-post (Please do Not Double Post ).

Use the X & Y parameters of the MouseMove event procedure to determine where on the form the mouse is.
As pks00 says, associating this with an individual record showing on the screen at that time, is a lot more difficult and I'm afraid I don't have an answer for you. I'm sure we'd all be interested to hear from anyone if they find, or can provide, an answer to this.

[missinglinq]

Is the Primary Key showing on the form, and if so exactly what do you want to do once you've identified it?

[Rabbit]

We've been here before CyberDwarf (Mouse & Subform)

Please visit this thread to see why we would rather you didn't double-post (Please do Not Double Post ).

Use the X & Y parameters of the MouseMove event procedure to determine where on the form the mouse is.
As pks00 says, associating this with an individual record showing on the screen at that time, is a lot more difficult and I'm afraid I don't have an answer for you. I'm sure we'd all be interested to hear from anyone if they find, or can provide, an answer to this.

The problem is that the mousemove event doesn't trigger in a continuous form for either the form header/footer or the current record it is on. Plus it doesn't trigger if it's actually moving over a control so you'd have to check to see if the x and y position are within the outermost limits.

[NeoPa]

Doesn't look like this'll be an easy one then, you reckon?

[Rabbit]

Doesn't look like this'll be an easy one then, you reckon?

I think so. Sounds pretty difficult.

Perhaps global variables and the mouse move event to keep track of where the mouse cursor is. You'll also need to leave some form space both above and below the controls because if you're moving the mouse from control to control the mouse move event will never trigger.

The record set will also need to be sorted and ranked so it can lookup the correct record depending on the Y coordinate.

Edit: This will be impossible if there's a scrollbar, because even though you scroll down, the actual coordinates don't change at all. So unless there are only a few records, it's not going to work.