Recent content by burma

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