formating unique identifier

  • Thread starter Thread starter alejandro
  • Start date Start date
A

alejandro

this is the format of the uniqueidentifier
{F48A2758-E8C2-42E4-A199-89CA353F6AE6}
i need to quit the {} characters for put this
"F48A2758-E8C2-42E4-A199-89CA353F6AE6"
in the filcli variabel for this line

the actual code is


Dim filcli As Variant
filcli=me.idcliente
Me.pedidos.RowSource = "exec filcli @cliente='" & filcli & "'"

whats i make wrong????
 
On Mon, 5 Nov 2007 18:17:27 -0200, "alejandro" <[email protected]>
wrote:

Try this:
Me.pedidos.RowSource = "exec filcli @cliente='" & Mid$(filcli, 2,
Len(filcli)-2) & "'"

-Tom.
 
Back
Top