Log In
Register
Home
Power Query
January 30, 2020
Offline
Hi,
I give you my attached database in ZIP file
I had a Training tracker database all done and completed 3 months ago and when I use the listbox to select a employee
An error number is 2417024809 COULD NOT FIND THE SPECIFIED OBJECT PLEASE NOTIFY ADMININSTRATOR.
The respective data applies to the relevant textboxes and is correct is just this error that comes up.
The VBA password is Online
Instructions open ZIP file
Username Zayne
Passcode 2565
Interface TAB ----PRESS Maintec Staff Training Tracker
Brings up a list of employees in the list box. When you click a line to modify certain parameter the error occurs.
Im also wondering if this is an add-in problem of that's what it is???
Steve
See Answer
October 5, 2010
Offline
Hi Steve,
In lstLookup_DblClick you have this loop
cNum = 11
For X = 1 To cNum
Me.Controls("Reg" & X).Value = findvalue
Set findvalue = findvalue.Offset(0, 1)
Next
cNum is hard coded to 11 but there isn't a Reg11 control and the code errors at this point when trying to set a value for the non-existent Reg11.
Regards
Phil
Answers Post
1 Guest(s)
