Normal Topic print form to html - all records in results set (Read 425 times)
jyellis
Full Member
Members
***
Offline


No personal text

Posts: 114
Location: Dallas-Fort Worth Area
Joined: May 19th, 2003
print form to html - all records in results set
May 9th, 2007 at 12:10am
Print Post Print Post  
My client wants to "print form to html" but he wants to be able to print the search result set.

For example if his search results are 15 records.  He wants to end up with 15 different html files.  And he wants the html files name = LastName FirstName fields on records.  ie Ellis Judy.html

Of course, I have given him a button to "print form to html" for each record.  But he wants it automated for all the records plus give the filename too.

Any help would be appreciated.
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: print form to html - all records in results se
Reply #1 - May 9th, 2007 at 12:36am
Print Post Print Post  
Have a button to print the report, but then have it continue and rename the file to LastName & " " & Firstname.htm.

The trick will be how to know the name of the original file. 
You could print it to an empty directory, get a directory listing written to a text file, read the text file and parse out the filename.  Then you can do the rename, and move the file so the folder is empty for the next time.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: print form to html - all records in results se
Reply #2 - May 9th, 2007 at 12:46am
Print Post Print Post  
When I have to do stuff like this, I do it in a Mass Update and use File I/O to create the files.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged