.execute

  1. Paul Ked

    ADODB Error - "Cannot update. Database or object is read-only."

    Hi all I'm getting the above error on a new PC I'm setting up, it doesn't happen with the other PC's in use with the same code! With CreateObject("ADODB.Connection") .Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=K:\KKDB.accdb;" .Execute "INSERT INTO TestOpen...
  2. R

    Please help - last hope - Image to word

    Hi all I know it's my first post so please forgive me but I am in need of some help. I have been working on the code below and it's driving me insane. I'm trying to copy an image from 'Sheet1' (users) cell 45 and paste into a word a document table (iii), but it's just left blank - everything...
  3. A

    How to Pass Number Variable to CurrentDb.Execute SQL Statement

    Hi, I'm working on a relatively old database that others created, and in order to deal with a duplicates issue I created a work-around by deleting all but one row on a specific problem table, tblRegisterCreation. In the code in my workaround, I want to write an IF statement that counts the...
  4. R

    Mailmerge macro does not work for some users

    Dear Forum Members, This is my first post though I have been visiting the site for help very often. I have a code where the word document asks for the recipient list and than sends email messages to the list in the spreadsheet. This works absolutely fine on my system and couple of my...
  5. P

    Problems with Excel returning .FoundFiles = 0

    In the code below (and in several previous variations of) I keep getting a value of 0 for .Execute and .FoundFiles. I have had several experiences where it has correctly returned the number of files in the folder one day, and zero the next, even though there have always been files in the...

Watch MrExcel Video

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