473,396 Members | 2,115 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

save an HTML report...

I am generating a report in HTML, that my users can look over AND if
they want to, store in their own Access dbase.

Thing is, I do not know how to "read" that whole html page into a var
and store same in a field in Access.

Can anyone point me here?

Jim

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #1
4 1478
Buffer the HTML to a string first. You can then preview the page (in a new
window or wherever) using Response.Write strPageHtml and/or store the HTML
in the database in a normal char, varchar, text field.

Alan

"Jim Rudnick" <jr******@kkti.com> wrote in message
news:OM**************@tk2msftngp13.phx.gbl...
I am generating a report in HTML, that my users can look over AND if
they want to, store in their own Access dbase.

Thing is, I do not know how to "read" that whole html page into a var
and store same in a field in Access.

Can anyone point me here?

Jim

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 19 '05 #2

Hmmm...exactly what does "buffer the string" in this context mean?

The html report is the result of a query on another text file and it
will be pretty plain, but will have a table in it for sure.

So, how do I "buffer" same? I know how to write a string to a dbase,
just not how to read an onscreen .html page into that string???

;-)

Jim
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #3
Instead of just Response.Write'ing your content out, set up a local variable
and write the various bits 'n' pieces to it:

Dim strPageHtml

' Buffer the HTML to a local variable, strPageHtml
strPageHtml = ""
strPageHtml = strPageHtml & "<html>"
strPageHtml = strPageHtml & "<head>"
....
strPageHtml = strPageHtml & "</body>"
strPageHtml = strPageHtml & "</html>"
....

' Output the HTML - this will display the content on-screen.
Response.Write strPageHtml

I'm not suggesting that you'll be able to do this without reorganising your
code though. You might display the HTML content onscreen along with, say, a
small form at the bottom of the page. The form contains a hidden control
whose value is the strPageHtml variable you created when buffering the page.
The form is submitted when the user elects to save the report to the
database, and when this happens you post the value of the variable (the page
HTML) to the processor where it can be written to the database.

Alan
"Jim Rudnick" <jr******@kkti.com> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...

Hmmm...exactly what does "buffer the string" in this context mean?

The html report is the result of a query on another text file and it
will be pretty plain, but will have a table in it for sure.

So, how do I "buffer" same? I know how to write a string to a dbase,
just not how to read an onscreen .html page into that string???

;-)

Jim
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 19 '05 #4
By the way Jim, you should mangle your email address (assuming it's real) to
stop spambots picking it up in these newsgroups.

Alan

"Jim Rudnick" <deleted> wrote in message
news:%2***************@TK2MSFTNGP11.phx.gbl...

Hmmm...exactly what does "buffer the string" in this context mean?

The html report is the result of a query on another text file and it
will be pretty plain, but will have a table in it for sure.

So, how do I "buffer" same? I know how to write a string to a dbase,
just not how to read an onscreen .html page into that string???

;-)

Jim
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 19 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: 00steve | last post by:
Hi, I was wondering if anyone knew how to go about having a "save as HTML" option incorporated within a page. (I know the option is available from the file menu from within IE, but a client has...
1
by: J. Koskey | last post by:
Background: We have hundreds of codes = specific departments, but there are frequent changes/additions to the info. For users to look up definitions, we had set up a way in Access to create a...
6
by: jer | last post by:
I have created a subroutine that opens a report in design view, modifies the report (adds text boxes and grouping levels, etc.) then opens in preview mode. I want to be able to close the report...
7
by: joseph.inglis | last post by:
I have a web browser object on a form which I have set to edit mode and use the UCOMIConnectionPointContainer interface to hook in and catch events. All working sweetly. Except there...
3
by: mo | last post by:
I have an application that uses Reporting Services. When the user chooses to print a report, they are taken to a window that allows them to fill in parameters for the report. They then click a...
5
by: kanthi84 | last post by:
Hi Friends I am doing a project using requesthandlers and ejb. In that, the user is given a provision to enter his comments and suggestions in the text area provided in the html page. After...
6
by: Josetta | last post by:
Access 2003 I've been experiencing some problems with my "monster" database the last couple of days. I imported all objects into a new database yesterday, which pretty much stopped the crashing...
2
by: Ian | last post by:
I am trying to save the current record on a form before opening a report, doesn’t sound to hard does it? The code on a buttons on click event goes like this: DoCmd.DoMenuItem acFormBar,...
3
by: evenlater | last post by:
I have an Access application on a terminal server. Sometimes my users need to export reports to pdf, rtf or xls files and save them to their own client device hard drives. They can do that right...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.