Excel VBA Data Entry Application with SQL database (Part-2)

[@GaganDeep-mj5hi]

Very nice and helpful

[@PKAnExcelExpert]

Thanks

[@seydoudioubate49]

Useful ! Thank you so much for what you are doing. 🙏🙏🙏🙏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@seydoudioubate49]

@@PKAnExcelExpert You most welcome

[@abdellahanba4403]

Top

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@TheSteveMorganShow]

Hi I am getting this error run time error data source name not found and no default driver specified when trying to run the program any thoughts

[@brenthalbach3645]

How can I populate a Listbox or Combobox from a recordset without the Support sheet? I have made it work with rs.getrows but it doesn't work if there are Null values. I'm trying to do it with the .additem but cant figure it out. Can you assist with this? Any assistance would be greatly appreciated.

[@ranishinde9220]

Hello sir, I got error at sub show_data() and error is expected function or variable... Please guide me sir

[@fatihcelep4158]

i am using without login and password option(windows authendication) so what should ı write on line cnn.Open Connection_String, "sa", "asd" vba give me alert '' failed login '' because of this

[@Cordycep1]

I think it call integrated security, use "INTEGRATED SECURITY=sspi;"

[@alexninorueda]

I have the same problem

[@rajb4549]

Anyone still looking to solve this - the following works Const Connection_String As String = "Provider=sqloledb;Data Source=[yourservername];Initial Catalog=[your database name];Trusted_connection=yes;" ' cnn.Open Connection_String, "sa", "abcd" cnn.Open Connection_String

[@az_fezz]

@@rajb4549 Man thank you that helped me a lot

[@datacleaningchallenge2029]

Having errors on this line Dim sql query As String

[@PKAnExcelExpert]

Don't use space in variable name. Take is as sql_query