formating uniqueidentifier

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????
 
G

Guest

Change this line of code:
filcli=me.idcliente
to
filcli=Replace(Replace(me.idcliente,"{",""),"}","")
 
A

alejandro

i write your line i only obtain
????????


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top