Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Streets and Trips

Discussion in 'Information Technology' started by B, Jul 28, 2006.

Tags:
  1. B

    B
    Expand Collapse
    Guest

    Has anyone ever exported FROM Access to Streets and Trips, if so how? I
    would like to send my new appointments to S&T by clicking a button. Where
    does S&T keep this file, if I knew that I might be able to send the data.
     
  2. Loading...

    Similar Threads Forum Date
    India Langar Seva At Mumbai Streets Breaking News Nov 20, 2012
    Sikhs Living in Shanty Towns and Streets in UK Hard Talk Feb 29, 2012
    UK 'Trapped' Illegal Immigrants Sleep On Streets Breaking News Feb 24, 2012
    World Sikhs Take to the Streets to Demand Dignity and Respect at European Airports Breaking News Sep 21, 2011
    UK Destitute Punjabis dot London streets Breaking News Jan 28, 2011

  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    I wasn't aware that S&T is programmable, but MapPoint is and I've opened
    maps in Access from Access database stored addresses.

    Set a reference to MapPoint. The code might look something like:

    Dim oApp As Object
    Dim oMap As Object
    Dim oPush(1 To 2) As Object
    Dim oLoc(1 To 2) As Object

    Set oApp = CreateObject("Mappoint.Application")
    Set oMap = oApp.NewMap

    Set oLoc(1) = oMap.Find(Me.txtAddress & " , " & Me.txtCity & " , " &
    Me.txtState)

    If Not oLoc(1) Is Nothing Then
    Set oPush(1) = oMap.AddPushpin(oLoc(1))
    oPush(1).GoTo

    With oMap.ActiveRoute
    .Waypoints.Add oLoc(1)
    End With
    oMap.CopyDirections
    DoEvents
    Me.txtDir.SetFocus
    DoCmd.RunCommand acCmdPaste

    End If

    oMap.DataSets(1).ZoomTo
    oMap.CopyMap
    imgClip.Visible = True
    imgClip.Action = acOLEPaste

    lblMapInfo.Caption = ""
    Else
    lblMapInfo.Caption = "Address Not Found!"
    End If
    Set oMap = Nothing
    Set oApp = Nothing
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "B" <B@discussions.microsoft.com> wrote in message
    news:046AD216-6ACD-418C-8766-F46EE8E9BF6E@microsoft.com...
    > Has anyone ever exported FROM Access to Streets and Trips, if so how? I
    > would like to send my new appointments to S&T by clicking a button. Where
    > does S&T keep this file, if I knew that I might be able to send the data.
     
  4. B

    B
    Expand Collapse
    Guest

    Thanks, wish I bought MapPoint now. I will make this work for now and then
    buy it later.

    "Arvin Meyer [MVP]" wrote:

    > I wasn't aware that S&T is programmable, but MapPoint is and I've opened
    > maps in Access from Access database stored addresses.
    >
    > Set a reference to MapPoint. The code might look something like:
    >
    > Dim oApp As Object
    > Dim oMap As Object
    > Dim oPush(1 To 2) As Object
    > Dim oLoc(1 To 2) As Object
    >
    > Set oApp = CreateObject("Mappoint.Application")
    > Set oMap = oApp.NewMap
    >
    > Set oLoc(1) = oMap.Find(Me.txtAddress & " , " & Me.txtCity & " , " &
    > Me.txtState)
    >
    > If Not oLoc(1) Is Nothing Then
    > Set oPush(1) = oMap.AddPushpin(oLoc(1))
    > oPush(1).GoTo
    >
    > With oMap.ActiveRoute
    > .Waypoints.Add oLoc(1)
    > End With
    > oMap.CopyDirections
    > DoEvents
    > Me.txtDir.SetFocus
    > DoCmd.RunCommand acCmdPaste
    >
    > End If
    >
    > oMap.DataSets(1).ZoomTo
    > oMap.CopyMap
    > imgClip.Visible = True
    > imgClip.Action = acOLEPaste
    >
    > lblMapInfo.Caption = ""
    > Else
    > lblMapInfo.Caption = "Address Not Found!"
    > End If
    > Set oMap = Nothing
    > Set oApp = Nothing
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > "B" <B@discussions.microsoft.com> wrote in message
    > news:046AD216-6ACD-418C-8766-F46EE8E9BF6E@microsoft.com...
    > > Has anyone ever exported FROM Access to Streets and Trips, if so how? I
    > > would like to send my new appointments to S&T by clicking a button. Where
    > > does S&T keep this file, if I knew that I might be able to send the data.

    >
    >
    >
     

Share This Page