[AccessD] String Help

Mark A Matte markamatte at hotmail.com
Tue Sep 19 14:16:07 CDT 2006


Martin,

I thought your were changing then launching the site...So here's my stab at 
it.

Good luck,

Mark A. Matte

Private Sub Command0_Click()
Dim site As String
site = 
"http://MySite12/_layouts/ViewEdit.aspx?List=%7B2A82A404%2D5529%2D47DC%2DAE13%2DAC1D9BC0A84F%7D&View=%7B357B4FE6%2D44CF%2D4275%2DB91F%2D46558301579B%7D"
site = Replace(site, "%7B", "{")
site = Replace(site, "%2D", "-")
site = Replace(site, "%7D&", "%7D")
site = Replace(site, "%7D", "}")
OpenIE site
End Sub


Public Function OpenIE(vURL As String)
On Error GoTo ErrorHandler
IEObj.Visible = True
With IEObj
..Visible = True
..Navigate vURL
Do Until Not .Busy
DoEvents
Loop
End With
Exit Function
ErrorHandler:
On Error GoTo ErrorHandler2
Set IEObj = Nothing
Set IEObj = CreateObject("InternetExplorer.Application")
ErrorHandler2:
Resume Next

End Function


>From: "Martin Reid" <mwp.reid at qub.ac.uk>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: [AccessD] String Help
>Date: Tue, 19 Sep 2006 19:45:51 +0100
>
>Given the string shown below does anyone know how to using VBA
>
>Before you can use the GUIDs from the address as arguments in this macro 
>action, you must replace each %7B string with the { character, replace each 
>%2D string with the - character, and replace each %7D string with the } 
>character. Do not include the & (ampersand) character that follows the %7D 
>string in the list GUID.
>
>
>
>The string would be of the form
>
>http://MySite12/_layouts/ViewEdit.aspx?List=%7B2A82A404%2D5529%2D47DC%2DAE13%2DAC1D9BC0A84F%7D&View=%7B357B4FE6%2D44CF%2D4275%2DB91F%2D46558301579B%7D
>
>
>This is out of the Access 2007 help file. Your response will be published 
>by the way as I cant do it.
>
>Martin
>
>
>
>Martin WP Reid
>Training and Assessment Unit
>Riddle Hall
>Belfast
>
>tel: 02890 974477
>
>


>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com





More information about the AccessD mailing list