[AccessD] String Help

Martin Reid mwp.reid at qub.ac.uk
Tue Sep 19 13:45:51 CDT 2006


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
 
 


More information about the AccessD mailing list