S
swas
Hi,
I have a table with a Replication ID as the primary key ("ProductsID"). The
table, via a query, is viewed on a form. Within an event, if I have code such
as:
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClone
rs.MoveFirst
Do While Not rs.EOF
Call FunctionX(rs!ProductsID)
rs.MoveNext
Loop
End Sub
If I call FunctionX("{7FA4E025-1139-4DA6-8782-CD30690C856B}") manually from
the immediate window, as an example, the function works fine.
But the rs!ProductsID code is passing "{guid
{7FA4E025-1139-4DA6-8782-CD30690C856B}}" to the function (With the "guid" and
extra brackets) and causing the function to bomb.
I've tried StringFromGUID but doesn't change it, and vice versa. The text
box on the actual form displays the guid correctly (Although not normally
visible). I could strip the extra characters, but I think I'm doing something
incorrect in the first place.
Help appreciated.
swas
I have a table with a Replication ID as the primary key ("ProductsID"). The
table, via a query, is viewed on a form. Within an event, if I have code such
as:
Dim rs As DAO.Recordset
Set rs = Me.RecordsetClone
rs.MoveFirst
Do While Not rs.EOF
Call FunctionX(rs!ProductsID)
rs.MoveNext
Loop
End Sub
If I call FunctionX("{7FA4E025-1139-4DA6-8782-CD30690C856B}") manually from
the immediate window, as an example, the function works fine.
But the rs!ProductsID code is passing "{guid
{7FA4E025-1139-4DA6-8782-CD30690C856B}}" to the function (With the "guid" and
extra brackets) and causing the function to bomb.
I've tried StringFromGUID but doesn't change it, and vice versa. The text
box on the actual form displays the guid correctly (Although not normally
visible). I could strip the extra characters, but I think I'm doing something
incorrect in the first place.
Help appreciated.
swas