formating unique identifier

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

Tom van Stiphout

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.
 

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