Macro followed by Hyperlink

[Mary]

I want to set up a button that will run a macro that runs two queries, then
open a hyperlink to another Access database. Right now it takes two buttons
to accomplish this. The first button runs the macro, the second button opens
the other database. Is there a way to combine the hyperlink into the first
macro?

Thanks! Mary

 

[Steve Schapel]

Mary,

Yes, I expect this would be possible.

If you need more explicit help with this, please post back giving more
details of what you've got so far, in particular the macros running on
the Click events of the two command buttons.

 

[Mary]

The first is a macro which I converted to show the code:

Function UpdatePNMPCircuitData()
On Error GoTo UpdatePNMPCircuitData_Err

DoCmd.OpenQuery "UpdatePNMPData", acNormal, acEdit
DoCmd.OpenQuery "UpdatePNMPCircuitData", acNormal, acEdit


UpdatePNMPCircuitData_Exit:
Exit Function

UpdatePNMPCircuitData_Err:
MsgBox Error$
Resume UpdatePNMPCircuitData_Exit

End Function

The second is a hyperlink to the other database.

I'd like to combine the two so it's one step to run the macro and open the
other database.

Thanks for your help.

Mary

 

[Mary]

Nevermind, I just got it to work with RunApp followed by the path to
MSACCESS.exe and the path to the database. Thanks, Mary