Search results

Actually, I do. Thank you for the sample, I'll take a look 🤠

I like your idea of having just ONE ribbon - I can use that. My main need though is to be able to load a ribbon programmatically AND have it display in the UI without having to restart the application. Thx

I don't think that will work for what I need: I need an application level ribbon. So even though I can load a ribbon using LoadCustomUI, and I can select that ribbon from from the File/Options menu, that ribbon won't actually display until I restart the application. Don't think there's a way...

I'm looking into that but here's a question: any way to load that one main ribbon programmatically without having to close and reopen the application? Thx

I have two ribbons in the USysRibbons table and they both work fine. However, I can't switch from one to the other without having to reopen the application. Anyone know if there's a way to do this without having to reopen the application? I also can't use a form to do this because once the...

🤜

Thanks y'all for what you've shared - it gives me a lot to work with 🤠

Doc_Man mentioned it might not be possible but I myself am able to add an accdb. I just discovered this which is interesting: In the db1 Immediate window I can go db2.Form_Form1.Visible = True and it opens the form. But if I put that in a module, it doesn't :unsure:

Thanks for that Doc_Man. I've used the IN clause before but I'm trying to see if I a referenced code library would be useful to me. Anyone know of an example showing how it could be used? My version of Access, 2021 MSO (Version 2409 Build 16.0.18025.20030) 32-bit, does allow me to add an...

So you're saying that db2 has to be open in order to refer to anything in it? No way to refer to its objects after simply adding a reference to it? Thx!

In db1 I add a reference to db2. db2 has a sub named Test1 and a form named Form1. How do I refer to Test1 and Form1 from VBA in db1? Thx!

I'm not really sure. I was thinking of having the main form record in a "header section" at the top, and related child records in rows below it. Like what a form/subform displays in Access. But for now, I'm just dumping the raw non-deduplicated data into Excel. Thanks

Thx!

Do you use CopyFromRecordset from the Access side or from Excel? Do you have an example? Thx

So I have the main form with the one record, and the subform with related records. I want to export the main form record as a header in Excel, and the subform records as rows below that. Anyone know how to do that or have an example? Thx

Anyone know if this is possible? Thx

I realize that but what about once the add-in is loaded? Can the add-in's ribbon be loaded once the add-in is loaded? I don't understand this. My ribbon xml has this Expression: =msgbox("Add-in loaded"). But even though the add-in is loaded, its ribbon still is not displaying. I was...

In the following add-in, if you open it up stand-alone, you can see the ribbon it contains. But if you install it, the ribbon doesn't display even after the add-in is loaded. Is there a way to load the ribbon dynamically in VBA when it's installed? Thx

No pass-throughs. There's just append queries only, and they all have to run. So I'm not worried about running anything that shouldn't be run. So you're saying leave out DoEvents? That would probably speed up the process but I don't want any query to not run. I'm also wondering if using ADO...

I'm running a bunch of saved append queries in a loop. The queries add records to linked SQL tables from local Access tables. Using DoEvents makes it take forever. Is there a better way? Is using StillExecuting the preferred way? Here's what I have so far. Thx On Error GoTo ErrHandler Dim...