Customer has 5 computers using WinXP Ver 2002 SP2
1 computer using a2003 (11.6566.8132) SP2
4 computers using a2003 (11.6566.6568) SP2
I have an Access Form and when the operator enters a field GotFocus event the following fires:
AppActivate GetPref(“NYS DAM Dog Licensing System Taskbar Name”)
The first time this is run on a computer it loads Login Screen asks for a User Name and Password and the operator continues and process Screen 1 on the internet then clicks back the the Access Form. This works OK.
The second and subsequence time this is run on same computer, same form different transaction it bypasses Login Screen and the operator process Screen 1 on the internet then clicks back the the Access Form. This works OK.
On the 1 computer using a2003 (11.6566.8132) SP2
Going through the above senerio, it asks for the Login Screen each time thus opening multiple tasks for the same website.
The Task Name is the same on all 5 computers
Is there a problem with the version of Access on this one computer?
Is there a setting in Internet Explorer that is not correct thus forcing a new login (new task) each time the URL is selected?
Thanks, John
Private Sub strTranDesc_GotFocus()
On Error GoTo ErrorHandler
If GetPref("POS Enter Dog License POS/NYS DAM DLS") Then
If Me.strTranCode2 = "D" Then
Select Case Me.strRevCode
Case "201", "202", "203", "204", "205", "208"
If Me.NewRecord = False Then ' 0=no New & Renewal, -1=yes Purebred
DoCmd.RunCommand acCmdCopy 'copies Tran Desc to clip board
AppActivate GetPref("NYS DAM Dog Licensing System Taskbar Name")
End If
End Select
End If
End If
ExitHandler:
Exit Sub
ErrorHandler:
If Err.Number = 5 Then 'run-time error 5, Invalid procedure call or agrument
Application.FollowHyperlink GetPref("NYS DAM Dog Licensing System"), , True
Resume Next
Else
MsgBox str(Err.Number) & Err.Description
Resume ExitHandler
End If
End Sub
