.execute

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

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

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

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

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