Forum Discussion
Microsoft Forms error after update.
It appears the problem is that it cannot find "DTPStartTime" (and I think you will have the same problem for "DTPEndTime"). Normally, these would be either property procedures or public module level variables within the form's code module and would be initialized/set by the procedure that creates the form (or maybe in a class initialization procedure that was deleted). In this case, it appears they reference a worksheet range that contains the values.
I'm guessing they've been deleted. If you have an older version of your file available, I would look at it to see what it was doing for the start and end times.
Edit: I attached an example of a userform using public property procedures to set/get a range variable and one that uses public variables. Look at the code in Sheet1 module to see how it is setting those properties before showing the form and then in the userform modules to see how it is storing the ranges that passed to the property procedures. But, these are a simple example, I don't know if your original file was doing anything to validate the information or use it for something else.
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).