Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting Access form into ASP files

Status
Not open for further replies.

ScottNomus

Programmer
Jun 27, 2001
33
US
I have tried several different things to get a Access form to function as a ASP form. Everything looks right except when I click on a button it will not do anything but refresh itself.

I noticed that when I export a form from Access it creates ActiveX Objects and class ID
*****SEE THE FOLLOWING*****
*****LogIn_Form.asp********CODE*******
<HTML>
<HEAD>
<META HTTP-EQUIV=&quot;Content-Type&quot; CONTENT=&quot;text/html;charset=windows-1252&quot;>
<TITLE>LogIn Screen</TITLE>
</HEAD>
<BODY>
<%
Session.timeout = 20
If IsObject(Session(&quot;WebCustomer_conn&quot;)) Then
Set conn = Session(&quot;WebCustomer_conn&quot;)
Else
Set conn = Server.CreateObject(&quot;ADODB.Connection&quot;)
conn.open &quot;WebCustomer&quot;,&quot;&quot;,&quot;&quot;
Set Session(&quot;WebCustomer_conn&quot;) = conn
End If
%>
<OBJECT ID=&quot;LogIn_Screenalx&quot;
CLASSID=&quot;CLSID:812AE312-8B8E-11CF-93C8-00AA00C08FDF&quot;
STYLE=&quot;TOP:0;LEFT:0;&quot;>
<PARAM NAME=&quot;ALXPATH&quot; VALUE=&quot; Customer/LogIn Screenalx.asp&quot;>
</OBJECT>

</BODY>
</HTML>

****NOW HERE IS THE SECOND FILE EXPORTED***********
****LogIn_formals.asp******************************
(HOW CAN GET THIS TO WORK*******
<%
Session.timeout = 20
If IsObject(Session(&quot;WebCustomer_conn&quot;)) Then
Set conn = Session(&quot;WebCustomer_conn&quot;)
Else
Set conn = Server.CreateObject(&quot;ADODB.Connection&quot;)
conn.open &quot;WebCustomer&quot;,&quot;&quot;,&quot;&quot;
Set Session(&quot;WebCustomer_conn&quot;) = conn
End If
%>
<SCRIPT LANGUAGE=VBScript>
<!--
Sub LogIn_Screenalx_OnLoad()
End Sub

Sub open_log_in_Click()
Window.Location.Href = &quot;Frm_password.asp&quot;
End Sub

-->
</SCRIPT>
<DIV ID=&quot;LogIn_Screenalx&quot; STYLE=&quot;LAYOUT:FIXED;HEIGHT:684;WIDTH:894;&quot;>
<OBJECT ID=&quot;Label77&quot;
CLASSID=&quot;CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0&quot;
STYLE=&quot;TOP:553;LEFT:102;WIDTH:726;HEIGHT:67;ZINDEX:0;&quot;>
<PARAM NAME=&quot;BackStyle&quot; VALUE=&quot;1&quot;>
<PARAM NAME=&quot;BackColor&quot; VALUE=&quot;12632256&quot;>
<PARAM NAME=&quot;Caption&quot; VALUE=&quot;Historical Information is only maintained online for 90 days
Should you need older data contact your account manager&quot;>
<PARAM NAME=&quot;ParagraphAlign&quot; VALUE=&quot;3&quot;>
<PARAM NAME=&quot;ForeColor&quot; VALUE=&quot;16711680&quot;>
<PARAM NAME=&quot;FontHeight&quot; VALUE=&quot;240&quot;>
<PARAM NAME=&quot;Font&quot; VALUE=&quot;MS Sans Serif&quot;>
<PARAM NAME=&quot;FontName&quot; VALUE=&quot;MS Sans Serif&quot;>
<PARAM NAME=&quot;Size&quot; VALUE=&quot;18876;1742&quot;>
<PARAM NAME=&quot;SpecialEffect&quot; VALUE=&quot;0&quot;>
<PARAM NAME=&quot;VariousPropertyBits&quot; VALUE=&quot;8388635&quot;>
<PARAM NAME=&quot;FontEffects&quot; VALUE=&quot;2&quot;>
</OBJECT>
<OBJECT ID=&quot;open_log_in&quot;
CLASSID=&quot;CLSID:D7053240-CE69-11CD-A777-00DD01143C57&quot;
STYLE=&quot;TOP:451;LEFT:408;WIDTH:120;HEIGHT:42;TABINDEX:1;ZINDEX:1;&quot;>
<PARAM NAME=&quot;BackStyle&quot; VALUE=&quot;1&quot;>
<PARAM NAME=&quot;Caption&quot; VALUE=&quot;&Log In&quot;>
<PARAM NAME=&quot;ForeColor&quot; VALUE=&quot;1279872587&quot;>
<PARAM NAME=&quot;FontHeight&quot; VALUE=&quot;200&quot;>
<PARAM NAME=&quot;Font&quot; VALUE=&quot;MS Sans Serif&quot;>
<PARAM NAME=&quot;FontName&quot; VALUE=&quot;MS Sans Serif&quot;>
<PARAM NAME=&quot;Size&quot; VALUE=&quot;3120;1092&quot;>
<PARAM NAME=&quot;SpecialEffect&quot; VALUE=&quot;0&quot;>
<PARAM NAME=&quot;VariousPropertyBits&quot; VALUE=&quot;10&quot;>
<PARAM NAME=&quot;FontEffects&quot; VALUE=&quot;4&quot;>
</OBJECT>
<OBJECT ID=&quot;intro&quot;
CLASSID=&quot;CLSID:978C9E23-D4B0-11CE-BF2D-00AA003F40D0&quot;
STYLE=&quot;TOP:277;LEFT:138;WIDTH:654;HEIGHT:156;ZINDEX:2;&quot;>
<PARAM NAME=&quot;BackStyle&quot; VALUE=&quot;1&quot;>
<PARAM NAME=&quot;BackColor&quot; VALUE=&quot;12632256&quot;>
<PARAM NAME=&quot;Caption&quot; VALUE=&quot;Welcome to Nomus's interative customer web page.
If you would like to join our select group of customers that are able to inquire on the status of their inventory items, call your account manager at
1-800-849-5748.&quot;>
<PARAM NAME=&quot;ParagraphAlign&quot; VALUE=&quot;3&quot;>
<PARAM NAME=&quot;ForeColor&quot; VALUE=&quot;16711680&quot;>
<PARAM NAME=&quot;FontHeight&quot; VALUE=&quot;240&quot;>
<PARAM NAME=&quot;Font&quot; VALUE=&quot;MS Sans Serif&quot;>
<PARAM NAME=&quot;FontName&quot; VALUE=&quot;MS Sans Serif&quot;>
<PARAM NAME=&quot;Size&quot; VALUE=&quot;17004;4056&quot;>
<PARAM NAME=&quot;SpecialEffect&quot; VALUE=&quot;0&quot;>
<PARAM NAME=&quot;VariousPropertyBits&quot; VALUE=&quot;8388635&quot;>
<PARAM NAME=&quot;FontEffects&quot; VALUE=&quot;2&quot;>
</OBJECT>
<OBJECT ID=&quot;ExitButton&quot;
CLASSID=&quot;CLSID:D7053240-CE69-11CD-A777-00DD01143C57&quot;
STYLE=&quot;TOP:505;LEFT:408;WIDTH:120;HEIGHT:42;TABINDEX:0;ZINDEX:3;&quot;>
<PARAM NAME=&quot;BackStyle&quot; VALUE=&quot;1&quot;>
<PARAM NAME=&quot;Caption&quot; VALUE=&quot;E&xit&quot;>
<PARAM NAME=&quot;ForeColor&quot; VALUE=&quot;2147483666&quot;>
<PARAM NAME=&quot;FontHeight&quot; VALUE=&quot;200&quot;>
<PARAM NAME=&quot;Font&quot; VALUE=&quot;MS Sans Serif&quot;>
<PARAM NAME=&quot;FontName&quot; VALUE=&quot;MS Sans Serif&quot;>
<PARAM NAME=&quot;Size&quot; VALUE=&quot;3120;1092&quot;>
<PARAM NAME=&quot;SpecialEffect&quot; VALUE=&quot;0&quot;>
<PARAM NAME=&quot;VariousPropertyBits&quot; VALUE=&quot;10&quot;>
</OBJECT>
<OBJECT ID=&quot;powerpoint&quot;
CLASSID=&quot;CLSID:D7053240-CE69-11CD-A777-00DD01143C57&quot;
STYLE=&quot;TOP:638;LEFT:342;WIDTH:252;HEIGHT:40;TABINDEX:0;ZINDEX:0;&quot;>
<PARAM NAME=&quot;BackStyle&quot; VALUE=&quot;1&quot;>
<PARAM NAME=&quot;Caption&quot; VALUE=&quot;View Samples of Our Work&quot;>
<PARAM NAME=&quot;ForeColor&quot; VALUE=&quot;2147483666&quot;>
<PARAM NAME=&quot;FontHeight&quot; VALUE=&quot;160&quot;>
<PARAM NAME=&quot;Font&quot; VALUE=&quot;MS Sans Serif&quot;>
<PARAM NAME=&quot;FontName&quot; VALUE=&quot;MS Sans Serif&quot;>
<PARAM NAME=&quot;Size&quot; VALUE=&quot;6552;1040&quot;>
<PARAM NAME=&quot;SpecialEffect&quot; VALUE=&quot;0&quot;>
<PARAM NAME=&quot;VariousPropertyBits&quot; VALUE=&quot;10&quot;>
</OBJECT>
</DIV>


*******I thought I could export from Access with very little problem******I WAS WRONG********************
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top