cnn

Hello Excel Masters, I need help in regards to my work. I am trying to create a EDIT Querry to be connected to MS Access but it seems my code won't push thru. The Save and Delete button of my work is already done. I just need the EDIT button to work. Here is my code. (it will be getting a...

Dear All, First of all I am not very sure that my question is excel related or access related, therefore I apologized posting in both group. I have code which is supposed to input data to access db however, it seems like If.. Then statement does not work. I tried to place if condition in my sql...

Dear Excel Gurus, I have code which is supposed to input data to access db however, it seems like If.. Then statement does not work. I tried to place if condition in my sql statement, still it does not work. Any help will be greatly appreciated. thank you guys in advance.Here is my code: Sub...

After below code runs, the result is 310, however the result of VBA code should be 321.3, all the digits after the decimal points were ignored in calculation. why does this happens? Pls download the 2 files from below site, and run the xlsm file after downloading....https://jmp.sh/71yC8Ti...

After below code runs, the result is 310, however the result of VBA code should be 321.3, all the digits after the decimal points were ignored in calculation. why does this happens? Many thanks for help. Dim cnn As Object, SQL$, s$, p$, f$ Set cnn = CreateObject("ADODB.Connection") p =...

I tried to run a query from an Excel worksheet. Below is my code but I think I am missing something here it does not work. I think my problem is the SQL code. Any help? I still got "Automation error" – ThanksBaha <code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas...

Hi. I not acutely proficient when it comes to programming but upon research I was able to come accross the below code that sometwhat fit my purpose. The code copys data in a TABLE in access and paste in an excel worksheet called Sheet1 starting from cell b1. Is it possible to have the code...

Hello guys, I would like to know if it is possible load data from access into combo box? I have bunch of columns in access, each of them is one word, and they repeat, so I would like to include e.g. 20 most frequent ones in combo box - to get something like a drop down menu? Do you...

Good Afternoon, I have created some code to pull a query from Access to Excel which works, but I now want to pull more than 1 query through at a time. So when "Current Week" is selected in a drop down Excel should pull 4 queries into Excel. I am using the following code I have created, but...