Replicator ID Coding

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael Kintner - 28 Feb 2007 16:31 GMT

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

Reply to this Message

David W. Fenton - 28 Feb 2007 17:31 GMT

> 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
[quoted text clipped - 10 lines]
>
> Very confusing.

See:

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

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

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message

Michael Kintner - 28 Feb 2007 17:59 GMT

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
[quoted text clipped - 16 lines]
>
> Also, check out the GUIDToString() and StringToGUID() functions.

Reply to this Message