Access 2010: ListBox (Forms 2.0) not working after Windows Update

After one of the updates attached was installed the following VBA-Code line causes an error on Windows 7 using Access 2010:

Me.lbCountries.AddItem rst("Country")

lbCountries is a  ListBox (Forms 2.0) using

  • class: Forms.ListBox.1
  • OLE: Microsoft Forms 2.0
  • MultiSelect: Multi
  • ListStyle: Option

The code is still working using Win8 (x64) and Access 2013. On Win7 (x32) and Access 2010 the following error is displayed: Object doesn't support this property or method (Error Code 438)

After manual deinstallation of the mentioned updates the VBA-code executes as expected. ListBox seems to be unusable after one of the updates. All other workarounds trying to fill the ListBox cause the same error.

Fast Help is very appreciated.

April 1st, 2015 7:06am

Hi BYN-DEVs,

Based on your description, your code was ok and it seems that the root cause was the update. This is a forum for discussing Access development related questions like Access form developing. And your issue is related with the Office Product issue, I will move this thread to the more related forum.

Reference:
http://social.technet.microsoft.com/Forums/en-US/home?forum=officeitproprevious

Thanks for your understanding.

Best Regards,

Edward

Free Windows Admin Tool Kit Click here and download it now
April 1st, 2015 10:49pm

After one of the updates attached was installed the following VBA-Code line causes an error on Windows 7 using Access 2010:

Hi, BYN,

Some times it happens, after some updates some features don't work properly. Two ways to solve it; first, recreate the object or uninstall the update that caused problem. Moreover, you can wait till new update comes and solve it automatically.

April 1st, 2015 10:58pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics