Search results

  1. B

    Export main form record along with subform records to Excel?

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

    Is it possible to have C:\ and subfolders be a Trusted Location?

    Anyone know if this is possible? Thx
  3. B

    Any way to load a ribbon stored in an add-in?

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

    Best way to execute querydefs in a loop using DoEvents?

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

    Proper way to setup a Yes/No/Null field in table and form?

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

    Possible to detect incoming connections to an Access db?

    Does anyone know a way to detect whether an incoming connection is made to an Access db, or if a someone links to it? Thanks
  7. B

    Problem with accdb association on user's desktops

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

    Can an add-in run code automatically when loaded?

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

    Solved Access 2003 command bar manager?

    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
Top Bottom