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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to give users ability to sort columns
...Set rsAccess = Server.CreateObject("ADODB.Recordset") 'Open the connection... cnX.Open "PRObserverDSN" nLevel = 0 sSQL="Select * from Access where [UserID] = '" & Session("UserID") & "'" rsAccess.LockType=1 rsAccess.CursorType=1 rsAccess.CursorLocation=2 rsAccess.Open sSQL, cnX...- mgifford
- Post #4
- Forum: Microsoft: ASP (Active Server Pages)
-
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...- mgifford
- Thread
- Replies: 4
- Forum: Microsoft: ASP (Active Server Pages)
-
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... -
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... -
Time/Date Stamp
I want to display the time and date a record was last edited. How can this be accomplished? -
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?- mgifford
- Post #7
- Forum: Microsoft: ASP (Active Server Pages)
-
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.- mgifford
- Post #5
- Forum: Microsoft: ASP (Active Server Pages)
-
ASP FormMail
With Mailer.Addrecipient = Request.Form("email"), I get a "Page Not Found" error.- mgifford
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
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...- mgifford
- Thread
- Replies: 7
- Forum: Microsoft: ASP (Active Server Pages)
-
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 =... -
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... -
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? -
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... -
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! -
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... -
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%? -
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... -
Display list w/ today's date only
Thanks for the tip! Still learning new things everyday! -
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!!! -
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??????
