Hi - this was working fine yesterday morning and for several months prior. Today, it breaks on any code relating to the combo boxes on the user form. Nothing has changed in the code or on the form.
Any ideas why code would stop working for combo boxes?
Please Login or Register to view this content.
Last edited by ker9; 05-07-2014 at 01:21 PM.
What do you mean by "breaks"? Just stops? Causes an error (if so, what)?
Remember what the dormouse said
Feed your head
Sorry, I should have added this.
Using debuger it stops on the first line of that routine
Run-time error '380':
Invalid property value
Just started doing it yesterday for no apparent reason
VB7
Last edited by ker9; 05-01-2014 at 08:59 AM.
If nothing has been changed on the form or in the code, I'd start by closing Excel, searching for any .exd files (these are temp files relating to userforms and controls) on your computer - you need to include hidden folders in the search - and then deleting them. Then try it again.
I cleared the .exd files. No change.
My VBA references appear to be fine (I have a snapshot I refer to)
I'm set to break on unhandled errors (not all errors)
I have a master version of this file, which I copied and had the same problem.
I have a previous version of this file, which now breaks in the same place.
What could have changed?
Where did you clear the .exd files from? There should have been at least 2 folders.
Can you post a copy of the file, after removing any confidential data?
There were several .exd files in the users/me/AppData/Local and AppData/Roaming
It's a monstrous file with lots of confidential stuff in it.
The weirdest thing is it was working - now none of the versions work.
We have a copy of it on SharePoint and that version isn't working either. It doesnt work for someone besides just me.
I tried deleting one of the combo boxes and recreating it. No change, doesn't work.
Did you have any windows/office updates installed in the last couple of days?
Good question - I'm emailing IT right now. They do this stuff in the background and we don't usually know about it.
It would appear that IT has done something - I don't know what, not sure if they know. But the reports that worked yesterday do not work today for me or anyone else on any other PC.
Any suggestions appreciated. If we figure it out, I will post it.
Thank you!
EDIT: Is it possible some dll or something like that got deleted?
Last edited by ker9; 05-01-2014 at 12:38 PM.
Unlikely - I think the errors would be very different. Usually this sort of thing is caused by a DLL update and deleting the .exd files cures it.
You could try unregistering and re-registering the fm20.dll
IT has told me that they have not made any changes.
I moved a copy of the master original to my home computer and I have the exact same problem. It will not do anything with the combo boxes. The items referenced below do exist.
This code was working and now it won't work - same as code posted above.Please Login or Register to view this content.
This is crazy. I've been fussing with this and searching the internet almost all day.
Unregistering and re-registering the FM20.dll seems to have fixed the problem! Wish I would have tried it sooner. Why would this stop working all over the company?
EDIT: Unfortunately, it seems like it only works for one run, then it's busted again. If I unregister/re-register again, then it works once.
Any ideas on that?
Last edited by ker9; 05-01-2014 at 03:34 PM.
I'm not sure. Try renaming the file and then running a repair of Office to get a new one put in place.
I've renamed the file, done a repair on Office. Open Excel and it works until I close Excel. If I open again, it stops working. These combo boxes are on a user form (not a sheet). Other Excel files with combo boxes on user form or on sheet are working. The file with the problem has not been modified since last September, but it stopped working for everyone in the Company. The master file also stopped working and two other files that were based on this file stopped working.
IT ran a script (or something) the night before it stopped working. This script is related to Outlook/email - it removes all .pst files and any emails older than 15 months. They swear it did not do anything that should cause this problem.
We are still trying to figure this out so if anyone has any ideas they would be appreciated. Thanks!
I would try exporting the form, removing it from the workbook and saving the file, then register the fm20.dll and re-import the form. I'd also suggest running Code Cleaner on your project.
If that doesn't work, I can only suggest rebuilding the whole form in a new project, and then importing it. If that fails too, it may require rebuilding the workbook.
Hi - thank you. I will try that. I don't understand how every saved version of this report (in two completely different and unrelated locations-and different versions old/new) could go bad overnight and stop working for everyone. It's very weird. Anyway, I'll let you know how it goes. Thanks very much for your help!
The problem was apparently unrelated to combo boxes, but that is where it appeared to keep bombing.
The following runs when the form initializes:
Those values that it attempts to insert are invalid as the values in the table only go through 4/2014. So it broke on 5/1/14. Once the table was updated to go through 2015 it started working again. To avoid this in the future, the table was updated through 2017 and a message box was added to workbook open that will appear on 5/1/18 notifying the need to update the table.Please Login or Register to view this content.
Thank you for all your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks