Solved Previous code not working Search and Export an excel sheet.

[smtazulislam]

I would like to export selected rows data in an excel.
Before it working well. Today update to import a dialogs box then facing "Not IsNothing" not working.
Where I have wrong.

 

[smtazulislam]

Any help ?

 

[arnelgp]

you change IsNothing() with IsNull()

 

[smtazulislam]

you change IsNothing() with IsNull()

now search button stop to work and when I try to export selected data then given error 2522

 

[arnelgp]

try this.

 

[smtazulislam]

try this.

When I click search button then RESULT list is empty.
and export button same message again...

 

[arnelgp]

you check your query if correct or not.

 

[smtazulislam]

you check your query if correct or not.

Yes I checked. But nothing wrong their maybe.

 

[arnelgp]

you Run it. did it show anything?

 

[smtazulislam]

you Run it. did it show anything?

Yes, form is opened. when click search button then empty in result list . even try also without select any combo box same. empty

 

[arnelgp]

you Run your Query, does it bring anything?

 

[smtazulislam]

you Run your Query, does it bring anything?

Query open and nothing missing.

 

[arnelgp]

this is the query i get, Nothing, no record.

 

[smtazulislam]

UPDATE!

 

[arnelgp]

see this one

 

[smtazulislam]

see this one

Thank you very much. Now search button is work good. But Export button is same as before.
What I need when search result is display in the list box then I choice some rows and selected rows bring to export in excel...

 

[arnelgp]

see again. it will save in MyDocuments (Export.xlsx)

 

[smtazulislam]

see again. it will save in MyDocuments (Export.xlsx)

Thank you very much Sir, Nice work.
One more question. If I would like to SAVE an excel file in FIXED path (D:\3. EMPLOYEES Department) AND file name is "Export Current date"
What to do there ?

 

[arnelgp]

try again.

 

[smtazulislam]

try again.

thank you very much. Great...