Replicator ID Coding

[Michael Kintner]

I am having a problem with Invalid Data type when trying to add a new record
with a ReplicatorID in it. I get a Data Type Converion Error.

rs!TankID = CStr(Forms![TankInfo]![TankID])
or
rs!TankID = Forms![TankInfo]![TankID]

Both statements give me the same error.

TankID is a ReplicatorID, if I display the field TankID it shows
{000001CF-0000-0000-0000-000000000000}

Very confusing.

Thank you in advance for your help,
Mike

 

[David W. Fenton]

I am having a problem with Invalid Data type when trying to add a
new record with a ReplicatorID in it. I get a Data Type Converion
Error.

rs!TankID = CStr(Forms![TankInfo]![TankID])
or
rs!TankID = Forms![TankInfo]![TankID]

Both statements give me the same error.

TankID is a ReplicatorID, if I display the field TankID it shows
{000001CF-0000-0000-0000-000000000000}

Very confusing.

See:

http://trigeminal.com/usenet/usenet011.asp?1033

Also, check out the GUIDToString() and StringToGUID() functions.

 

[Michael Kintner]

Excellent, thanks for the info, that worked.

I would have rather not use GUID's, however the application is on its way to
SQL server where GUID is needed to autocreate a new record. Unless you know
of other ways to auto create a new record in SQL with a unique ID number?
The only way I found is using SQL's uniqueidentifier with (newid()). Is
there something better?

Mike

I am having a problem with Invalid Data type when trying to add a
new record with a ReplicatorID in it. I get a Data Type Converion
Error.

rs!TankID = CStr(Forms![TankInfo]![TankID])
or
rs!TankID = Forms![TankInfo]![TankID]

Both statements give me the same error.

TankID is a ReplicatorID, if I display the field TankID it shows
{000001CF-0000-0000-0000-000000000000}

Very confusing.

See:

http://trigeminal.com/usenet/usenet011.asp?1033

Also, check out the GUIDToString() and StringToGUID() functions.