Microsoft Access ACCDE ListBox DoubleClick doesn't work

Question

I just installed Access 2016 and created a simple form with a listbox.  User double-clicks an item in the listbox and it opens another form.

Functionality works fine in the .accdb but not in the .accde version.

Any ideas?

Answer 1

I had this same problem with a 2010 database 32 bit database.  Double click event worked in accdb but not in accde.  The fix is simple, open your accdb and then your VBA editor.  In the VBA editor, click Debug>Compile.  Now when you save your accde the double click should work.

Answer 2

Ok, first up, GREAT idea to remove the control, great idea to go the EXTRA mile and eliminate as MUCH as possible.

The basic BOTTOM line is a super simple line of code that is 100% hardcoded with the form does not work. (so suggesting’s to try MORE complex code is not the approach to find and fix this program).

Ok, so the simplest ONE line of code does not work:

Troubleshooting:

You have suggested that using an accDB works just fine? (yes/no?)

You have suggested that the code compiles fine, but running the compiled accDE does NOT work? (yes/no?).

Above being the case, then try launching Access first and THEN opening the accDE – does the code STILL fail?

If you are answering yes to all of the above (and many of my clients are), then you being bitten by a VERY nasty issue – the new 2016 format (internal).

The issue is due to the original database having been created in a version prior to 2016. The only real solution is to create a new blank database in 2016, and then import everything. Now, re-try the above steps/questions – and post back that it now works (bottoms to dollars, it will).

I assume for all testing you doing this on your one computer, and the accDE and that SUPER simple one line of code is failing on your computer.

Regards,

Albert D. Kallal (Access MVP)

Edmonton, Alberta Canada

Answer 3

Do you have anything in the On Click or any other event of the Listbox?

Answer 4

Private Sub List0_DblClick(Cancel As Integer)

DoCmd.OpenForm "frmName"

End Sub

Answer 5

What code is behind the event?