Datalist

[skdn71]

Hello,

Could you please help with click event on datalist:

If I don't do a data search, the button works fine, but if I do a data search the button doesn't work.

Please help me

Thank you very much for your time

 

[Gasman]

Perhaps explain what it is meant to to?
If I do not search I get a new workbook.
If I do search I get to go to the db sheet?

 

[skdn71]

Explain:
the 3 button not working after the search found ( see ficture)

 

[Gasman]

TBH, this is a little beyond me.
However you appear to be duplicating code?

In PopulateDatalIst you have
licon
lnsur
ltertugas
lnamkeg
ltglkeg
lwayan
lview
ldownload
lhapus
lgaris

In PopulateDataListVersie1 you only have
licon
lnsur
ltertugas
lnamkeg
ltglkeg
lwayan

so
that + (lview) is one of the ones missing.
lview
ldownload
lhapus
lgaris

You should be calling all that as a sub, if that is the issue.

Edit:
You even have this as a comment?
' (Repeat for Lview, Ldownload, Lhapus, Lgaris) ?

I am not sure if all the set commands should be added as well?

 

[Gasman]

I would walk your code, as if you goto sheet and come back from that button on the sheet, the click event works again?

 

[skdn71]

I hope you can help me. Thank you for your time

 

[Isaac]

i'll try to look at this today after church

 

[Isaac]

You inherited this or took this from someone else, I assume, because there is plenty of sophisticated code in this book but you have no idea what you are even asking - if you can narrow it down to a test case (I typed this, and this ought to happen), in clear terms, I will try to help.

 

[Gasman]

@Isaac
All you actually need to do is ..............................

Click on +, you get a MSGBOX
Enter a character in the search tesxbox. No need to press the search button.
Now click on that + again, nothing happens.

Same applies to those other icons.

However, if you click the search button and get to another sheet, then click the blue button at the top of that sheet, you are back to the initial screen, and the + works again.

That is far as I got.

 

[Isaac]

That is kind of the type of thing that I was looking for thanks. The code is relatively sophisticated compared to what you usually see and involved but I'll try a little debugging and see where I get when I have more time

 

[Isaac]

I wouldn't have thought that a plus symbol was for searching, would never have guessed that..

 

[Gasman]

I wouldn't have thought that a plus symbol was for searching, would never have guessed that..

I do not think it is. I think that is just an intermediate step to see if it works, just a simple MSGBO, to be replaced with code (possibly to expand) that line?
Same with the other two, edit and delete?

 

[Isaac]

the first thing i had to do was disable all macros in excel, as the OP left the uploaded file in such a state that it's impossible to debug without doing so, UHH

 

[Isaac]

Guess I'm bowing out as well - I've never programmed in Excel such that controls were programmatically removed and added PLUS code assigned to those controls on-the-fly.
Could take me days to solve, and instead I've got dishes to wash, laundry to do, and Monday morning coming fast.

Good luck, sorry