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 strongm 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. mgifford

    How to give users ability to sort columns

    O.K., I have a start on the code for this function but am stuck. I am getting the following error: Microsoft OLE DB Provider for ODBC Drivers (0x80040E21) ODBC driver does not support the requested properties. /pr-obs/default_sort.asp, line 84 Here is the code for this. What am I missing...
  2. mgifford

    How to give users ability to sort columns

    I have an interface that uses VBScript to write to an Access DB and displays records in a table on our intranet. They are records for PR events and observers we have for our medical helicopters. Each record has all the information for the event written to a database but the main summary page...
  3. mgifford

    Sorting Data

    It is records from a database for PR events and observers we have on a medical helicopters. Each record has all the information for the event written to a database but the main summary only shows basic info (i.e. Type, Date, Base Location, Name). They want to sort the columns by the headers...
  4. mgifford

    Sorting Data

    I have script that writes to a table on our intranet. I'd like to give the users the option to sort by the column header (i.e. Sort by Name, Sort by Date). I would also like to give them a sort feature so they can sort by specific parameters (i.e. Sort by Date from 01/01/09-01/31/09). Can...
  5. mgifford

    Time/Date Stamp

    I want to display the time and date a record was last edited. How can this be accomplished?
  6. mgifford

    ASP FormMail

    Alright, that worked. It showed that the e-mail was sent in the To line and the properties showed the correct e-mail addresses, however, the e-mails were never received. They were not captured by the SPAM blocker. What now?
  7. mgifford

    ASP FormMail

    Thanks! The HTML works perfectly! However, the Mailer.Addrecipient = Request.Form("email") still did not work. I get an error page when adding this piece of code.
  8. mgifford

    ASP FormMail

    With Mailer.Addrecipient = Request.Form("email"), I get a "Page Not Found" error.
  9. mgifford

    ASP FormMail

    I got my forms to work and e-mail properly but have two questions: 1. How do I have it a copy sent to the person who fills the form out? It doesn't work to do Mailer.Addrecipient = Request.Form("email_address"). 2. How can I make the email be sent in HTML format? It did not work to set...
  10. mgifford

    Problem w/ HTML e-mail

    semailaddress = Session("UserID") & "@cc-ems.com" semailaddress2 = Request.Form("Email2") If Request.querystring("action")="send" then sBody = "<html>" sBody = sBody & "<head>" sBody = sBody & " <meta http-equiv='Content-Type' content='text/html'>" sBody = sBody & "</head>" sBody =...
  11. mgifford

    Problem w/ HTML e-mail

    I have set up a trade form for our employees using VBScript that sends an e-mail in HTML. It comes through fine w/ all three sections (i.e. Partner 1, Partner 2, Administrative Approval). When you reply to the e-mail (using Word as the e-mail editor - If you do not use Word as the e-mail editor...
  12. mgifford

    Type Mismatch

    I am trying to pass information to a new page that will be printer friendly and am getting a type mismatch. Here's what I have: <a href='printobs.asp?mode=edit&key=" & (rsPRObs("Key")) & "'> I want to be able to display all the fields in a more condensed version. What am I doing wrong?
  13. mgifford

    Printing a Form

    No, I have the form set up on our intranet writing the data to an Access database. The user has the ability to add an event using the form, view a list with basic details of a scheduled event and then click to view complete details of each individual event which opens up the form again. I need...
  14. mgifford

    Printing a Form

    That's a great idea! That's exactly what I had in mind but not sure how to do it. Now, where do I start? Do you know where I can find information about coding a custom print button and populating a text/html file? Thanks so much!
  15. mgifford

    Printing a Form

    I tried that and it still cuts off. I assume it is because the form fields at larger than what I have set the table and cell widths at. Does anyone have any other ideas about my options for creating a printer friendly version of a form? The user has to be able to print the data once the...
  16. mgifford

    Printing a Form

    I have a form set up and want to give the user the option to print it without cutting off the right side of the table. Is there any other way to do this besides making the table less than 100%?
  17. mgifford

    StripString Double Quotes and Carriage Return

    I need to strip out double quotes and carriage returns in my text fields on a form. Here's what I have for the function to replace " " with ' ': '--------------------------- Function StripString( sPassed ) Dim sReturn, i, iLen, sChar, sLookFor iLen = Len(sPassed) sLookFor = Chr(34) For...
  18. mgifford

    Display list w/ today's date only

    Thanks for the tip! Still learning new things everyday!
  19. mgifford

    Display list w/ today's date only

    THANK YOU, THANK YOU, THANK YOU!!!! I knew it was something simple but couldn't find an example of it in any of my other pages or books. BLESS YOU!!!
  20. mgifford

    Display list w/ today's date only

    I need to create a select statement where the only things listed are where the date field matches today's date only. What else do I need? sSQL="Select * from PRObs Where [Date] = ??????How do I only display the current date match??????

Part and Inventory Search

Back
Top