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!

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

Search results for query: *

  1. bikebanditcom

    problem with query

    working on this statement and am getting <error> Microsoft VBScript compilation error '800a03ee' Expected ')' /pbc/reporting/xlReports/TMPz49damvdu9.asp, line 8 </error> the sql: <code> set compReport = pbcDB.execute(&quot;SELECT tblLots.lotNum, tblSales.saleDate...
  2. bikebanditcom

    problem with query, expected end of statement error?

    i get the following error from this page: Microsoft VBScript compilation error '800a0401' Expected end of statement /pbc/reporting/TMPavoprmttwj.asp, line 13 rs = &quot;SELECT tblSalesmen.salesmanName, tblSales..... heres the query SELECT tblSalesmen.salesmanName, tblSales.saleDate...
  3. bikebanditcom

    creating a recordset with multiple criteria

    i need help creating a recordset with three criteria, search by region, supplier, and then by a date range. the tables can be found here. http://www.wecantlose.com/relationships2.htm any help is appreciated. thank you dan
  4. bikebanditcom

    viewing saved access queries in asp

    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...
  5. bikebanditcom

    ASP to Excel Problems

    i am trying to generate a excel chart from a recordset that can be saved (i'd be nice if it would save and display) but i can deal with having the user hit file - save as. the following is my page can anyone tell me why the chart comes up blank? <%@LANGUAGE=&quot;VBSCRIPT&quot...
  6. bikebanditcom

    can't get my query to work

    can anyone help me with the following code for a query, i am trying to get it to spit out a cancelled sales report, i have two tables, one is tblsales, the other is tblSalesPackages, now the status of the sales have to be at the package level because often one package may cancel while the others...
  7. bikebanditcom

    problems with cdo

    ok, i have a loan app that im trying to mail using cdo, (its the only option i have with the clients host, using w2003 server, so no cdonts) anyhow, my problem is that i can get the page to send the email, however i dont know how to get all the loan fields into the body of the msg, can anyone...
  8. bikebanditcom

    login to a site via a prompt

    i have a site i've built that i put together a login page to login to the member side, however the client wants a prompt box rather than an entire page, how do i set up a login via a msg box prompt rather than thru a login page? Any ideas? thanks dan
  9. bikebanditcom

    loop thru dynamic form elements

    I have the following javascript, that as you can see dynamically generates two fields, i'll be adding two more fields that will be dependendent on the first two fields, i haven't worked out the dependendent drop downs, but i need to know how i can loop thru this code in vbscript on my...
  10. bikebanditcom

    loop thru dynamic form elements

    I have the following javascript, that as you can see dynamically generates two fields, i'll be adding two more fields that will be dependendent on the first two fields, i haven't worked out the dependendent drop downs, but i need to know how i can loop thru this code in vbscript on my...
  11. bikebanditcom

    can't get my asp page to email

    can any one help? im trying to get my page to email form results to me, however i can't get it to work the following two pages are used to proceess the form.. the html form <HTML> <HEAD> <SCRIPT LANGUAGE=JavaScript> <!-- function DoctorElements() { var i,j; for (i=0; i <...
  12. bikebanditcom

    looping thru an array and inserting the data with JS

    the following post was made to a question of mine, however i can't get the code to work and have yet to hear back from that post, can anyone help me with the final part of this bit of code, what i need is to know how to write the sql statement and declare which fields to insert into in the...
  13. bikebanditcom

    inserting records from a for...next statement HELP!!

    i have a form that has a dynamic portion, so the form works, the variables are passing as i'm writing them to the screen on the take_returns.asp page. my problem is that i don't know how to write the insert statement for this loop. could anyone help please, i had it written another way, but...
  14. bikebanditcom

    problem looping

    I have the following code trying to look thru an array and then save each item from the array as one record, but instead its loading for example all partNumber's into one record a piece, then it does the same with each. any ideas on how to get it all to insert as one record? thanks ahead of...
  15. bikebanditcom

    help with passing form data

    Ok, So i have a form that has this button &quot;Add a part&quot; which adds a new line of form fields to the sheet, but it names each one for example partNumber is renamed to PartNumber_0, all the way thru 1, 2, 3, 4, so on. below is the javascript i'm using to create the new rows dynamically...
  16. bikebanditcom

    problem with passing from data

    Ok, So i have a form that has this button &quot;Add a part&quot; which adds a new line of form fields to the sheet, but it names each one for example partNumber is renamed to PartNumber_0, all the way thru 1, 2, 3, 4, so on. below is the javascript i'm using to create the new rows dynamically...
  17. bikebanditcom

    searching the database for a certain time period

    Guys, i'm trying to display results from a recordset based on a date range the user provides in two text boxes. the following bit of code is my recordsets defined, anyone have any idea how to do this? thanks <% Dim rsAuditInfo__MMColParam rsAuditInfo__MMColParam = &quot;1&quot; If...
  18. bikebanditcom

    Incoming Email issue with outlook

    The problem is that we have a couple of customer service reps answering the same email address, what we've been doing is accepting all emails at one station, then exporting them and importing them on the other computer. What we'd like to do is have them both accept emails but we aren't sure of...
  19. bikebanditcom

    can't delete items from my outlook

    I can't delete items from outlook anymore, i must drag them to a folder, delete that folder, then delete it from my deleted items to get rid of the damn thing. anyone have any idea as to why my outlook is doing this? thanks dan
  20. bikebanditcom

    Extensive If..Then..statements..not working please help!

    below is a very extensive if...then statement i just finished, and it seems to be valid but i'm not getting any calculations, i'm writing every form field to the screen on my page that processes the form and inserts it into the database, the problem is the three fields that are in the calc are...

Part and Inventory Search

Back
Top