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

Some videos you may like

This Week's Hot Topics

Top