[AccessD] String Help

Use 

replace (MyString,"%7B","{")
replace (MyString,"%2D","-")
replace (MyString,"%7D","}")

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Tuesday, September 19, 2006 2:46 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] String Help

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