viewing saved access queries in asp

bikebanditcom · Oct 13, 2003

hello guys and gals,

im not quite sure what i need to do here, i have the following databse set up

http://www.wecantlose.com/relationships.htm

and what im trying to do is view data on an asp page, before getting to the page to view the material order report, you first come to a selection page, where you select one of the three, or all three, i'm not sure if this is possible, if its not then all three can be chosen ever time, no worries, however the first drop down is for region, the second is for supplier, and third is for a date range. i can set up a table that displays info based on one search term or form input, but i dont know how to do the date range, or make it based on all three. so anyhow, the report is to show any parts attached to any packages that are attached to any sales that have the VOO field in tblSales, the VOO is the deciding factor on whether or not the part can be pulled from inventory or ordered, the page comes out to the following: three html tables,
one for the "rough in parts", next for the "trim" parts, and the next for the "service call" parts. in all three i total the cost of the parts but line, then at the bottom of the page i total the cost of all the parts. so if this were in access, no problem, i could set up the query in a zip, but what i thought i'd be able to do is access a query like i could a table in my code, but im not sure how to do that, could anyone tell me or help me out with any of this? i'm not quite sure what to search for in the FAQ's , and i've tried just finding the FAQ's to browse thru, but i must be dumb because i cant find that section of the site. thanks for your help. below are my pages. thanks

dan

SELECTION PAGE

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="css/style.css" rel="stylesheet" type="text/css">
</head>

<body>
<h1>Material Order Report </h1>
Today is <%= Now %>
 Region 
<form name="matOrderReport " method="post" action="materialReport.asp">

<select name="Region">
<option value="">Select One</option>
</select>

Supplier 

<select name="supplier">
<option value="">Select One</option>
</select>

Schedule Date

<input name="date1" type="text" size="8">
To
<input name="date2" type="text" size="8">


<input type="submit" name="Submit" value="View Materials To Order">
 
</form>
 
<A href="default.asp">Home</A> | <A href="login.asp">Login</A>
| <A href="salesEntry.asp">Sales Entry</A> | <A href="salesEdit.asp">Sales Editing</A>
| <A href="scheduling.asp">Scheduling</A> | <A href="register.asp">Register
A New User</A> | <A href="dbControlPanel.asp">DB Control Panel</A> | <a href="<%= MM_Logout %>">Logout</a>
Copyright 2003 PBC Technologies Designed By <a href="mailto:dhayden@wecantlose.com">Dan
Hayden, Jr</a> 
<a href="

http://www.wecantlose.com">We

Can't Lose, LLC</a> 
 
</body>
</html>

REPORT PAGE
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<html>
<head>
<title>Material Order Report</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="css/style.css" rel="stylesheet" type="text/css">
</head>

<body>
<h1>Material Order Report</h1>
Today is <%= Now %>
Rough In
<form name="form1" method="post" action="#">
<table width="407" border="1" align="left" cellpadding="4" cellspacing="4">

<tr>
<td width="89" height="28" valign="top">Part Number</td>
<td width="71" valign="top">Part Desc</td>
<td width="29" valign="top">Unit</td>
<td width="53" valign="top">Unit Cost</td>
<td width="89" valign="top">Total Cost</td>
</tr>
<tr>
<td height="34" valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
</table>
 
 
 
 
Trim 
<table width="407" height="70" border="1" align="left" cellpadding="4" cellspacing="4">

<tr>
<td width="90" height="28" valign="top">Part Number</td>
<td width="70" valign="top">Part Desc</td>
<td width="32" valign="top">Unit</td>
<td width="55" valign="top">Unit Cost</td>
<td width="84" valign="top">Total Cost</td>
</tr>
<tr>
<td height="28" valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
</table>
 
 
 
 
Service Call

<table width="407" border="1" align="left" cellpadding="4" cellspacing="4">

<tr>
<td width="90" height="28" valign="top">Part Number</td>
<td width="70" valign="top">Part Desc</td>
<td width="32" valign="top">Unit</td>
<td width="55" valign="top">Unit Cost</td>
<td width="84" valign="top">Total Cost</td>
</tr>
<tr>
<td height="28" valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
<td valign="top"> </td>
</tr>
</table>


 
 
Total Part Cost For This Supplier : 
Total Cost For All Parts:
 
</form>
<form name="form2" method="post" action="xlReports/xlMaterialReport.asp">

<input type="submit" name="Submit" value="Save Excel Spreadsheet">

 
</form>
 
 
<A href="default.asp">Home</A> | <A href="login.asp">Login</A>
| <A href="salesEntry.asp">Sales Entry</A> | <A href="salesEdit.asp">Sales Editing</A>
| <A href="scheduling.asp">Scheduling</A> | <A href="register.asp">Register
A New User</A> | <A href="dbControlPanel.asp">DB Control Panel</A> | <a href="<%= MM_Logout %>">Logout</a>
Copyright 2003 PBC Technologies Designed By <a href="mailto:dhayden@wecantlose.com">Dan
Hayden, Jr</a> 
<a href="

http://www.wecantlose.com">We

Can't Lose, LLC</a> 
 
</body>
</html>

bikebanditcom · Oct 14, 2003

i've been playing around with the tables to make sure my scheduling works properly, heres the updated relationships,

http://www.wecantlose.com/relationships2.htm

can anyone help?

dan

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!

viewing saved access queries in asp

bikebanditcom

Programmer

bikebanditcom

Programmer

Similar threads

Part and Inventory Search

Sponsor