Search results

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.

Hello. Have coding in Access that opens up several Excel files, one at a time. Most files work fine. But some files cause Excel to crash. Turns out that they have v20.00 in the filename(?). Anyway, when I open the files manually, they also crash, unless I disable macros in Excel. So I disabled...

I suppose they would be... didn't know there was a cost!

Hello. IT policy is now limiting macros in Macro settings. They mentioned we could use a digital signature for our end-users. Any advice/suggestions on how to go about doing that? Thanks!

Nope. No use of recordsetclone anywhere.

I randomly will get this error when a form has been open for a while (whose underlying data is linked to an external data source, e.g., Sharepoint). I click Okay a couple of times, and life goes on as usual. The underlying data queries that support my forms/subforms are super simple - not using...