RE: [LegacyUG] Fwd: Microsoft Query to set UserID's

2014-02-06 Thread Sysadm
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

Re: [LegacyUG] Fwd: Microsoft Query to set UserID's

2014-02-06 Thread Graham Love
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

Re: [LegacyUG] Fwd: Microsoft Query to set UserID's

2014-02-06 Thread Dave Scott
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

RE: [LegacyUG] Fwd: Microsoft Query to set UserID's

2014-02-06 Thread Sysadm
] 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

[LegacyUG] Fwd: Microsoft Query to set UserID's

2014-02-05 Thread Dave Scott
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