Wouldn’t it have been easier to set the User ID from section 12.4 in Options?
Tom
From: Dave Scott [mailto:d.w.sc...@shaw.ca]
Sent: 06 February 2014 07:20
To: legacyusergroup@LegacyUsers.com
Subject: [LegacyUG] Fwd: Microsoft Query to set UserID's
Hello All,
I have resolved this issue
I thought these tables had gone. I don't have any in V8.
Graham
Sent from my iPad
On 6 Feb 2014, at 07:20, Dave Scott d.w.sc...@shaw.ca wrote:
Hello All,
I have resolved this issue. The User ID is stored in a field called UserRef
in the table tbIR. It was easy to create an update query
The User ID I'm creating has the first four letters of the Surname appended by
the four digit RIN (formatted to have leading 0's). I don't believe that the
Option 12.4 allows for different text.
Dave
Legacy User Group guidelines:
http://www.LegacyFamilyTree.com/Etiquette.asp
Archived
] Fwd: Microsoft Query to set UserID's
The User ID I'm creating has the first four letters of the Surname appended by
the four digit RIN (formatted to have leading 0's). I don't believe that the
Option 12.4 allows for different text.
Dave
Legacy User Group guidelines:
http
Hello All,
I have resolved this issue. The User ID is stored in a field called UserRef in
the table tbIR. It was easy to create an update query to populate the User ID
field for all my records.
Sorry to have bothered anyone.
Dave
Begin forwarded message:
From: Dave Scott
5 matches
Mail list logo