Recent content by CedarTree

Has anyone had success running Access with API or HTTP calls to ADI? (Or even calls to co-pilot?) E.g., if you want to loop through several prompts stored in Access, or summarizing several docs where the filenames are stored in Access. (Or even using powerautomate as a go-between?) Some good...

Agreed that I was doing 1 record at a time in a loop... but still! Okay thanks all!

I tried Do Events and I think it's helping (?) Adding one at a time due to analysis in the mix for each record and the writing the results...

One at a time...

Hello. Running an insert query (for multiple records) via VBA (sql = "INSERT INTO...") Once in a while (randomly it seems), VBA loop will stop, and warn me it needs to be an updateable query. If I just F5 continue the sql execution, it works. Would a DO EVENTS help? Still weird! It feels like...

My larger code for reference... Sub subCreateDaoRecordsetFromExcelSheet() Dim db As DAO.Database Dim rst As DAO.Recordset Dim dbEngine As DAO.dbEngine Dim sPath As String Dim sql As String Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Sheet1") sPath...

Hello. Just playing around with running queries on Excel data (using DAO). I can create and use a recordset with no issues. But I get error 3073 (updateable query) when I try to execute this sql. Help please? db.execute ("UPDATE [Sheet1$] SET [Done] = 1")

I will try when I come up for air!

That seems to be it! Clearly an MS Access bug. Thanks!!!

That's the thing - the name of that form is completely new/mysterious to me. Could my Access install be corrupted?

Hello. I am getting a seemingly out of the blue issue where Access prompts me to unhide a specific form ("tmpAccMonacoHwnd"). It happens when I close other forms generally. I tried importing all Access items into a new DB and still getting the issue. If I click Cancel, no harm (but annoying). If...

Thanks - I even tried this on another computer with no luck.

Thanks - I guess I would need coding for Access to then grab that instance of Excel and set it equal to an object?

Is there a way to open Excel in safe mode from within Access?

Ha - was just trying that. No luck.