Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2005

Tip: Looking for answers? Try searching our database.

Open Streets & Trips from Access Command Button

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve Cronje - 09 Mar 2005 05:15 GMT
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
Steve Cronje - 09 Mar 2005 05:29 GMT
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?

> I would like to open a saved Streets & Trips file from a command button in
> Access 2003. I am currently using
[quoted text clipped - 24 lines]
>    
> End Sub
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.