Oct 4, 2010 #1 cstuart79 Technical User Nov 2, 2009 171 US Anyone have VBA code for opening another Access database (via hyperlink) and closing current Access database?
Anyone have VBA code for opening another Access database (via hyperlink) and closing current Access database?
Oct 4, 2010 1 #2 dhookom Programmer Jun 24, 2003 22,497 US 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 Upvote 0 Downvote
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
Oct 5, 2010 Thread starter #3 cstuart79 Technical User Nov 2, 2009 171 US great stuff, but i'm using 2007 access Upvote 0 Downvote
Oct 5, 2010 1 #4 PHV MIS Nov 8, 2002 53,708 FR Something like this ? Application.FollowHyperlink "\path\to\database.mdb" Application.Quit Hope This Helps, PH. FAQ219-2884 FAQ181-2886 Upvote 0 Downvote
Something like this ? Application.FollowHyperlink "\path\to\database.mdb" Application.Quit Hope This Helps, PH. FAQ219-2884 FAQ181-2886
Oct 5, 2010 Thread starter #5 cstuart79 Technical User Nov 2, 2009 171 US worked like a charm....thanx! Upvote 0 Downvote