cnn

  1. J

    EDIT Error Formula (VBA)

    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...
  2. B

    Input data to Access DB from excel vba

    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...
  3. B

    input data to access DB using excel vba

    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...
  4. C

    Problem with SQL in VBA

    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...
  5. C

    VBA sum problem

    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 =...
  6. B

    Excel VBA run query from SMS Access database

    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...
  7. I

    excel vba for access to repeat c/p

    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...
  8. N

    Loading access data in combo box vba

    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...
  9. G

    Import more than 1 record set @ a time from Access

    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...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top