Forum

An Error is 2417024...
 
Notifications
Clear all

An Error is 2417024809 could not find the specified object

4 Posts
2 Users
0 Reactions
178 Views
(@stevenbehr1)
Posts: 92
Estimable Member
Topic starter
 

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

 
Posted : 26/05/2020 4:36 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

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

 
Posted : 26/05/2020 6:41 am
(@stevenbehr1)
Posts: 92
Estimable Member
Topic starter
 

Arrr ....Yes you are right! Damn 

 

Thanks

 

Steve

 
Posted : 27/05/2020 6:18 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

😉 no worries

 
Posted : 27/05/2020 6:54 am
Share: