Forum Discussion
Microsoft Forms error after update.
This is a system we use that pulls information from a data system. The compile error I get is "Method or data member not found." This started happening after a system update. I don't know much about ...
No luck with different files. I even commented those lines out and uncommented where they are set equal to specific dates and that didn't work.
Sorry, even though you mentioned the error was in the initialize procedure, I overlooked that procedure. It's more likely that DTPStartTime and DTPEndTime refer to controls on the userform itself. When looking at the userform, open the properties window (view/properties window) and then click on the start/end time controls and see if the name has been changed (assuming those controls exist at all).
- The userform does not pop up anymore when the excel file is opened. I just get an error stating "Could not load some objects because they are not available on this machine." Does this indicate an issue with my computer or the computer the database is on?
- Are you missing any reference libraries (in vba editor, click tools/references and see if any are marked "Missing").
You might also check to see if the solver add-in is loaded - I've read it can sometimes cause that error (in excel, click file/options/add-ins/go and uncheck solver if it is loaded). If it's not that, I would try unloading other add-ins one at a time to see if they are the problem.
Failing that, I would try repairing office through the control panel (programs and features, right click and select repair).- No references marked as missing.
Solver Add-in is listed. When I got to manage Add-ins I tried selecting and unselecting and still no difference.
I used a remote connection to run this excel file on the PC that the database is on and it seemed to work so the issue is definitely on my pc.