On Click Open Hyperlink and Close Current DB 2

[cstuart79]

Anyone have VBA code for opening another Access database (via hyperlink) and closing current Access database?

 

[dhookom]

You might want to check Michael Kaplan's Shut One Open New add-in. I don't know if will work in whatever version of Access you are using.

Duane
Hook'D on Access
MS Access MVP

 

[cstuart79]

great stuff, but i'm using 2007 access

 

[PHV]

Something like this ?
Application.FollowHyperlink "\path\to\database.mdb"
Application.Quit

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cstuart79]

worked like a charm....thanx!