formating uniqueidentifier

  • 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????
 
Change this line of code:
filcli=me.idcliente
to
filcli=Replace(Replace(me.idcliente,"{",""),"}","")
 
i write your line i only obtain
????????


Klatuu said:
Change this line of code:
filcli=me.idcliente
to
filcli=Replace(Replace(me.idcliente,"{",""),"}","")
 
Back
Top