Cliff67
Registered User.
- Local time
- Yesterday, 18:52
- Joined
- Oct 16, 2018
- Messages
- 175
Hi All
I'm trying to get access to link to the Back End tables, no problems there..usually
StrTable is a passed table name ("Tbl_Version")
I've set a variable VarRet as Variant and I'm using
VarRet = CurrentDb.TableDefs(StrTable).Fields(0).Name
If Err <> 0 Then
CheckLinks = False
Else
CheckLinks = True
GoTo VerifyLinksDone
End If
(checkLink is a Boolean flag) this checks for a failure. If it can't determine the name of the first field in the table then it must be a bad link
however, when stepping through the code I get a error 3265 - Item not found in this collection.
Does any one know what I'm missing? been going through this most of the day :banghead:
many thanks in advance
Cliff
I'm trying to get access to link to the Back End tables, no problems there..usually
StrTable is a passed table name ("Tbl_Version")
I've set a variable VarRet as Variant and I'm using
VarRet = CurrentDb.TableDefs(StrTable).Fields(0).Name
If Err <> 0 Then
CheckLinks = False
Else
CheckLinks = True
GoTo VerifyLinksDone
End If
(checkLink is a Boolean flag) this checks for a failure. If it can't determine the name of the first field in the table then it must be a bad link
however, when stepping through the code I get a error 3265 - Item not found in this collection.
Does any one know what I'm missing? been going through this most of the day :banghead:
many thanks in advance
Cliff