Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / April 2006

Tip: Looking for answers? Try searching our database.

Get report data into a web page and print multiple pages

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jbonifacejr - 12 Apr 2006 18:11 GMT
Yesterday I got the bad news that I can't open an instance of Access,
run a report, then close Access over ASP. So, I need to come up with an
alternative so that I can execute printing of "orders" over an ASP
page.

I know how to open the db connection, get the data I want into a table,
and I can present the data on the screen. The problem is that I want to
print out "orders" on individual pieces of paper. I can present the
orders on the screen separated by hr tags. I don't know what kind of
tags or markup to put on the page that will tell the printer that the
next segment of screen data should be printed to a new page.

Can someone tell me how to do that?

Thanks
jbonifacejr - 12 Apr 2006 18:18 GMT
Hate to answer my own question, but I think I've found it here

http://www.htmlgoodies.com/beyond/css/article.php/3470341

Looks like all I need to do is create the asp page and display my data,
and when I walk the recordset put one of the described page break
commands either before or after each record.
Lyle Fairfield - 12 Apr 2006 18:29 GMT
> Yesterday I got the bad news that I can't open an instance of Access,
> run a report, then close Access over ASP. So, I need to come up with an
[quoted text clipped - 11 lines]
>
> Thanks

http://msdn.microsoft.com/workshop/author/dhtml/reference/properties/pagebr
eakbefore.asp
Signature

Lyle Fairfield

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.