Hover over to run a query and display results quickly

[Lateral]

Hi guys

I spent some time searching but have come up empty handed to I though that I would ask this wonderful forum!

Ok, I have an invoicing system that the user can add payments. The payments are in a table called "Payments" and are all linked to the invoice by the invoice's unique number.

Currently, the user clicks a Command Button that opens a form to allow them to enter the numerous payments....so far so good.

I would like to provide the user with the ability to simply hover over the same Command Button and a small query would be run to extract the appropriate payment records for the invoice and display them via a popup form that will disappear when the mouse moves from the Command Button....

Does anyone have any ideas????

Regards
Greg

PS: I'm using Access 2007.

 

[Galaxiom]

It won't be easy inside Access. There isn't any event like OnHover that would be ideal for the job. You could use the OnMouseMove Event to open a form to display the query data.

The OnMouseMove sub arguments include the mouse position so you can use these to open the form in the right place and move it as the mouse moves.

Check that the form is already open so that it doesn't rerun the entire process every time the mouse moves. Check if the mouse position is near the edge of the button so that the form can be closed as it exits.

There might be some better way using a Windows API but the Windows hover functionality in Access is poor at the best of times so it might not be worth pursuing.

 

[Lateral]

Thanks mate