ACC2000: ListBox MouseDown bug?

[Havard Ravatn via AccessMonster.com]

I'm developing a database application running on a Microsoft SQL Server 2000 with Microsoft Access 2000 as front-end.

In one of my forms I use a ListBox showing files on a IIS-filestore linked to the records in the form recordsource. The user can right-click on any record in the Listbox and choose "View File" from a right-click menu to show the file selected.

For some reason it is not possible to select records using mousebutton-leftclick in the ListBox after the MouseDown event have been executed the first time. Selecting records with the left mouse button in ListView-boxes, Combo-boxes, DropDown-boxes and Listboxes in ALL forms in the database is not possible. It is still possible to select records using the keyboard.

Access must be restarted for the left mouse-button to function normally again. Using a Requery in the MouseDown-event seem to solve the problem, but then you loose focus on the selected form record.

Any ideas on how to solve this problem?

 

[Van T. Dinh]

Have you applied all the Service Releases / Service Packs on your Access
installation?

The original release of Access 2000 was very bugsy and you need to apply the
Service Releases / Service Packs to get Access to work well. You should
also update your OS with SRs / SPs also.

Also try a new mouse ...

--
HTH
Van T. Dinh
MVP (Access)

I'm developing a database application running on a Microsoft SQL Server

2000 with Microsoft Access 2000 as front-end.

In one of my forms I use a ListBox showing files on a IIS-filestore linked

to the records in the form recordsource. The user can right-click on any
record in the Listbox and choose "View File" from a right-click menu to show
the file selected.

For some reason it is not possible to select records using

mousebutton-leftclick in the ListBox after the MouseDown event have been
executed the first time. Selecting records with the left mouse button in
ListView-boxes, Combo-boxes, DropDown-boxes and Listboxes in ALL forms in
the database is not possible. It is still possible to select records using
the keyboard.

Access must be restarted for the left mouse-button to function normally

again. Using a Requery in the MouseDown-event seem to solve the problem, but
then you loose focus on the selected form record.