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

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

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")

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

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

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!

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

Hello - I want to have a primary subform and then based on what a specific data field within that form is, e.g., "project type", have another subform appear or disappear. So, for example, if project type = "quantum mechanics" (QM), then QM subform would be visible. But if project type = "Time...

Hello - I have a choice field in SP, that has as one option this "---". In fact, that is the default value in SP when adding a new record, although (perhaps b/c of the format), it doesn't work so I have to go in and choose "---" as the choice for new records. I figured I would try to...

Hi... looking for best ways to use Windows task scheduler to open up Access (not hidden!), run a macro, and auto close. Say once a day. Use a batch file maybe? Sample code please? Thanks!!!

Hello - trying to run an update query on a linked Sharepoint list in Access. I can manually change SOME of the rows, but not all (get a valid values/data integrity error). I'm not aware of any validations within my list, the field I'm updating is a text field, and I can't see any obvious...

Hello - inherited an Access database with lots of tables that I suspect are not being used. How can I "audit" which tables are not not being referred to in any queries, modules, etc. so that we can slim down the DB (I would move the un-used tables to a backup DB just in case of course). Thanks!

Hello - I have an Excel workbook that has a complex structure, and so I can't just import the whole thing into Access using VBA. Rather, I want to import certain rows into a pre-existing Access table (all Cols exist in Access, but all Cols may or may not exist in Excel). I have coding working to...

Hello - using a file dialog (generally works fine) but it truncates a file name when I put in a default value with spaces. I've tried Chr(34)+DefaultPath+Char(34) and also tried replacing any spaces with %20. No luck so far. Any suggestions? Thanks!

Hello - I have a table as a linked table connected to SQL server. If I open the table directly in Access (not in a form), I can filter/sort. But if I open it in a form (where "Allow Filter = True"), I can't filter or sort??? What am I missing? Thanks!

Hello. Let's say I have a table of colors (red, white, blue, etc.) and another table that has People's names, their favorite color, and their least favorite. I can't seem to set up TWO (or more) relationships between the table of colors to the Fav field and the table of colors and the Least Fav...

Hello - I'm using Access VBA and the Adobe SDK to pull words from searchable PDFs. Works great (most of the time) but with larger PDFs, it seems to hit a performance wall where it will be extracting the same page for a long time. Sometimes, after 2 mins, it will move on. Other times it crashes...

Hello - I have a working model to grab data into Access using DAO.recordset from a database hosted on SQL server. Connection string works great. I even have a generic function to grab the recordset as long as I pass the sql statement to the function (see below please). How do I do the same thing...

Hello - we have an Access database and want to begin to migrate the data to MySQL for others to access the data (read-only for now) using a web portal. Looking for a connection string to use in VBA to link the tables in MySQL to Access. The MySQL database is hosted on siteground if that helps...

Hello. Using a DB that has been repaired / compacted. And I'm running a series of SQL statements that update one table based on another table. The VBA runs fine for almost every field but as I near the end of the process (field #47 of #49), I get error 3047 record is too large. Any suggestions...