I recently converted from Access 97 to 2007, but cannot open my files... It displays "Run-time error 5" and asks to debug. The underlined line in italics below is where the problem lies.
Any suggestions on how to fix this? I am not very familiar with VB, so treat me as a novice...
Thanks!
For Each ctl In frm.Controls
strTemp = ctl.Name
strTag = Nz(ctl.Tag)
If strTag <> "" And strTag <> "DetachedLabel" Then
strLang = Left$(strTag, 1)
If strLang = "E" Then
intCtlLang = cLangEnglish
strTag = Right$(strTag, Len(strTag) - 1)
ElseIf strLang = "L" Then
intCtlLang = cLangLocal
strTag = Right$(strTag, Len(strTag) - 1)
Else
intCtlLang = langID
End If
Any suggestions on how to fix this? I am not very familiar with VB, so treat me as a novice...
Thanks!
For Each ctl In frm.Controls
strTemp = ctl.Name
strTag = Nz(ctl.Tag)
If strTag <> "" And strTag <> "DetachedLabel" Then
strLang = Left$(strTag, 1)
If strLang = "E" Then
intCtlLang = cLangEnglish
strTag = Right$(strTag, Len(strTag) - 1)
ElseIf strLang = "L" Then
intCtlLang = cLangLocal
strTag = Right$(strTag, Len(strTag) - 1)
Else
intCtlLang = langID
End If