C
CondtllyFrmttd
Hello. Im using MS Access 2003. My goal is to use a form that will
check inventory with the click of a button. In order to check
inventory, a username and password is required to log onto a website.
I can handle making an IF statement based on a user's computer's
number/name to log in different people.
The problem is recreating a session id. Using Internet Controls and
VBScript I can mix VBScript and VBA into a module. The SENDKEYS method
can be used but within the HTML a session id is created. I have a
feeling that there is a cookie that contains a random generator. If it
is not a cookie then it might be a style sheet.
The code is simple, it looks a little something like this:
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.Navigate ("https://fgv.ups-scs.com/fgv/admin_login.build_logon")
ie.Visible = True
Do Until ie.ReadyState = 4
Loop
AppActivate ("Internet Explorer")
SendKeys "USERNAME"
SendKeys "{TAB}" & "PASSWORD~"
SendKeys "%d" &
"https://fgvreports.ups-scs.com/reports/cgi-bin/upfcgi.exe~"
strPartNumber = Forms![PartnumberControl]
SendKeys "{TAB}{TAB}{TAB}{TAB}{TAB}{TAB}strPartNumber{ENTER}"
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Anyone have a clue? I am a rookie with HTML and JavaScript.
THe website's Source Code:
<TD width=466><!-- BEGIN Center column modules --><!-- BEGIN WELCOME
MESSAGE --><SPAN class=header>Flex Global View</SPAN><!-- END
WELCOME MESSAGE --><P><BR><NOSCRIPT><SPAN class=redErrorBold>JavaScript
is disabled on your browser. This site is best viewed with
JavaScript enabled. Please turn it back on and reload this
page.<BR><BR></SPAN></NOSCRIPT><FORM ACTION="/fgv/admin_login.action"
METHOD="POST" NAME="logOnForm"><INPUT TYPE="hidden"
NAME="p_session_id" VALUE="614681169581"><INPUT TYPE="hidden"
check inventory with the click of a button. In order to check
inventory, a username and password is required to log onto a website.
I can handle making an IF statement based on a user's computer's
number/name to log in different people.
The problem is recreating a session id. Using Internet Controls and
VBScript I can mix VBScript and VBA into a module. The SENDKEYS method
can be used but within the HTML a session id is created. I have a
feeling that there is a cookie that contains a random generator. If it
is not a cookie then it might be a style sheet.
The code is simple, it looks a little something like this:
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.Navigate ("https://fgv.ups-scs.com/fgv/admin_login.build_logon")
ie.Visible = True
Do Until ie.ReadyState = 4
Loop
AppActivate ("Internet Explorer")
SendKeys "USERNAME"
SendKeys "{TAB}" & "PASSWORD~"
SendKeys "%d" &
"https://fgvreports.ups-scs.com/reports/cgi-bin/upfcgi.exe~"
strPartNumber = Forms![PartnumberControl]
SendKeys "{TAB}{TAB}{TAB}{TAB}{TAB}{TAB}strPartNumber{ENTER}"
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Anyone have a clue? I am a rookie with HTML and JavaScript.
THe website's Source Code:
<TD width=466><!-- BEGIN Center column modules --><!-- BEGIN WELCOME
MESSAGE --><SPAN class=header>Flex Global View</SPAN><!-- END
WELCOME MESSAGE --><P><BR><NOSCRIPT><SPAN class=redErrorBold>JavaScript
is disabled on your browser. This site is best viewed with
JavaScript enabled. Please turn it back on and reload this
page.<BR><BR></SPAN></NOSCRIPT><FORM ACTION="/fgv/admin_login.action"
METHOD="POST" NAME="logOnForm"><INPUT TYPE="hidden"
NAME="p_session_id" VALUE="614681169581"><INPUT TYPE="hidden"