Hi DrB,
As always, thanks for your outstanding support.
I will look at the link you gave me. Meanwhile, to answer you questions.
1. The search results mean a record set generated by a SQL query. Same
thing you helped me out last time.
2. I want 2 options ... a. Display using HTML which WORKS fine now. b. Export the file to EXCEL.
Thanks for your help again...
hotflash
Last Activity: Apr 11 '09, 01:03 AM
Joined: Jan 7 '08
Location:
-
How to export search results into Excel format
Hi All,
Instead of displaying the search results such as names, phones, etc... on the screen, is there a way to export this information into an EXCEL format using ASP?
Please advise. Thanks for your help. -
Hi deric,
You are truly another HERO of this ASP forum. Everything works perfectly.
Thanks once again for your OUTSTANDING SUPPORT.Leave a comment:
-
Hi deric,
Thanks for your help. It looks like we are getting close now. This is the output that I got when I ran it. 3 issues. Thanks once again for your outstanding support.
1. The total is ALWAYS 1 instead of 2 because let's say Hotflash completes 2
records, etc.
2. For some reason the user keeps jumping around like Dr B jumps up to
Hotflash, Jha jumps up to Dr B.
...Leave a comment:
-
Hi Dr. B,
Haven't tried again lately. Honestly, I am new to the ASP world and this portion is way over my head and would appreciate if you can take a look for me. Please let me know if you can help. Thanks once again for your outstanding support.Leave a comment:
-
Hi Dr B (The Expert),
Thanks for your replying and hope you had a good holiday. I have been extremely busy on my daily projects as well. This is something very new to me and just want to do it for experience. Hope you can help me know. I know you can because you are the EXPERT on this stuff. Just want to make sure we are on the same sheet of music here.
Let's say there are 3 people in the team: myself (hotflash),...Leave a comment:
-
Thanks for your outstanding support and let me know if you have any luck or not.
Meanwhile, Dr B and CroCrew, any comments? Thanks.Leave a comment:
-
Hi Sanjeev,
Below are the files that I used for this search and display reports accordingly.
The MS Access fields are defined as follows:
RecordID: AutoNumber and Primary Key
CompleteDate: Date/Time
ProjectType: Text
Network: Text
Individual: Text (First and Last Name)
Thanks once again for your outstanding support.
...Code:<HTML>
Leave a comment:
-
Hi idsanjeev and DrBunchman,
Your recommendations sound EXTREMELY GOOD however, I am having problem to try to integrate them into the actual code that I used because I have case statements, etc for different type of search as well.
Is there a way, I can send you the 2 files that I used (1 search option, 1 display search result) for your recommendations ? Please advise or send me a PM message. Thanks once again for your...Leave a comment:
-
Hi Jeff,
I got the total records count for ALL individual show up correctly. What I want to do is to get a total count for EACH individual. Please see below and thanks for your help.
Current:
CroCrew
CroCrew
Jim
Jim
Total Records: 4
Want it to be:
CroCrew
....
....
Total = 2
Jim
....
.......Leave a comment:
-
Total Record Count per Individual
Hi CroCrew et. All,
I am currently working on a quick report that count a total of completed records per Individual. The code that I have will add up all Individual completed records and what I want is to get a total for each of the Individuals per month. For example,
CroCrew
....
....
Total = 2
Jim
....
....
Total = 2
Below is part of... -
Hi CroCrew,
Glad to hear that. So are you going to keep me posted about pulling the data (values) from MS Access Database? Thanks once again for your outstanding support.Leave a comment:
-
Hi CroCrew,
An EXPERT like you can burst this easily. Here is the link to the code. Thanks once again for your outstanding support.
http://www.codetoad.co m/asp/cool_chart.aspLeave a comment:
-
Cool Bar Chart code from codetoad.com Website
Hi All,
I found a very nice ASP bar chart code on the codetoad.com website. The author said, you can pull the values from a database as well. I am very new to the ASP environment and this stuff is way over my head.
Can any EXPERT give me a hand here? If you know of something even better please advise. Thanks in advance for your help. -
Hi CroCrew,
Don't know what WORDS that I can use for you but to make it short, you are REALLY AN ASP GURU.
By the way, I am in the middle of playing with a Case statement. Got stuck and wonder if you can help me out.
I can send you the entire HTML file and the ASP code for you to look at if you don't mind. Should be easy to fix for an EXPERT like you. Thanks.Leave a comment:
-
Hi CroCrew,
I have never used the code tag on this forum before and hope below is what you want to see. Sorry if it does not show up correctly. Thanks.
strSQL = "UPDATE PTSProjects SET "Code:html
strSQL = strSQL & " DeviceName = '"& strDeviceName &"', "
strSQL = strSQL & " Vendor = '"& strVendor &"',...Leave a comment:
-
Hi CroCrew and All,
Wow ... Other issue pops up after I used your statement. There are other fields such as strSQL = strSQL & " DeviceName = '"& strDeviceName &"', "
strSQL = strSQL & " Vendor = '"& strVendor &"', " that need to update as well. They STOPPED working when I used the new statements you provided.
Is there a way to define the Replace...Leave a comment:
-
Hi CrowCrew,
You are TRULY AN ASP GURU. Thanks for your OUTSTANDING SUPPORT.Leave a comment:
-
Hi CroCrew,
Thanks for your outstanding support. I put your command in but got the following error:
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
Please help. Thanks.Leave a comment:
-
Hi shweta123,
Thanks for your help. I have never used the replace command before. Below is the statement that I used to update. What would it look like with the REPLACE statement?
strSQL = "UPDATE TableProjects SET "
strSQL = strSQL & " WorkDescription = '"& strWorkDescript ion &"', "
Conn.Execute(st rSQL)
There are other fields that need...Leave a comment:
No activity results to display
Leave a comment: