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"

Hi,
try to post in IE or ASP group

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

"CondtllyFrmttd" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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"
>