Open Streets & Trips from Access Command Button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to open a saved Streets & Trips file from a command button in
Access 2003. I am currently using

Private Sub Open_Map_Click()

On Error GoTo Map_Macro_Err

Me![Text567].SetFocus

DoCmd.RunCommand acCmdCopy


Application.FollowHyperlink ("C:\Documents and Settings\us256756\My
Documents\My OHESD\_Access\Access Excel Map Files\All Acct Dist 3 04 05.est")
OHESD\_Access\Access Excel Map Files\All Acct Dist 3 04 05.est",
vbMaximizedFocus)
DoCmd.Maximize
SendKeys "^v", True
SendKeys "{enter}", True

Map_Macro_Exit:
Exit Sub

Map_Macro_Err:
MsgBox Error$
Resume Map_Macro_Exit

End Sub
 
I forgot to mention I would like to use a different command from hyperlink
because I get a warning message that stops the map window from opening. Is
their an open file command?
 
Back
Top