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
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
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...
I'm creating a new Yes/No/Null field in a table. Null means unchosen. When the user leaves the form that has the field, they have to make a choice of Yes or No. What's the proper way to set this up? I don't think I want a rule in the table as I want to handle that in the form.
Here's my...
I'm running into the problem of opening accdb's in the wrong version of Access on user's machines. This seems to happen most with machines that have both 2010 and 2016/365 installed. Anyone have a decent workaround to that, like a script or batch file? Even a hardcoded shortcut such as...
I have an Access file that does one thing when it opens: it displays the message "hello". I then install the file as an add-in. When I open another Access file, let's call it Add-in Test A.accdb, the add-in is there in the Add-ins menu but the "hello" message doesn't display unless I click it...
Hello - I'm looking for a tool that can create and/or document custom Access 2003 mdb command bars, buttons, etc. It needs to show the command executed, whether it's a macro, sub, function, or popup. Anyone know of such a tool? Thanks