473,805 Members | 2,007 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

output report in html

Hope I can find an answer here. I am using Access 2000. I know I have no
controll over my column spacing in an html document generated by Access 2000
using the "output to" command. I have read that the same goes for Access
2002. My question is, can it be done in Access 2003?? I have searched
Microsoft site and could not come up with an answer either way.

If the same goes for 2003 then I am open for suggestions. I am currently
outputing to a "snapshot" format but this requires my websites visitors to
have or download and install MS Snapshot. I need to avoid "tweaking" the
html doc. outside of access. If it helps, I am using MS Frontpage2000 as my
editor.

Thanks in advance!
Mark
Nov 12 '05 #1
5 2308
"Mark Elliott" <me******@ZZZme galink.net> wrote in message
news:10******** *****@corp.supe rnews.com...
Hope I can find an answer here. I am using Access 2000. I know I have no
controll over my column spacing in an html document generated by Access 2000 using the "output to" command. I have read that the same goes for Access
2002. My question is, can it be done in Access 2003?? I have searched
Microsoft site and could not come up with an answer either way.

If the same goes for 2003 then I am open for suggestions. I am currently
outputing to a "snapshot" format but this requires my websites visitors to
have or download and install MS Snapshot. I need to avoid "tweaking" the
html doc. outside of access. If it helps, I am using MS Frontpage2000 as my editor.

Thanks in advance!
Mark

Do you have any knowledge of writing code? If the built-in output procedure
isn't quite as you need it, then you could always write your own which will
format the html exactly as you want. By the way, are you using ASP for
this?

Fletcher
Nov 12 '05 #2
Not VB code. I am sure I can learn it easy enough. The export as html
command through the file menu works well, but I need to automate it more. I
don't want the user to have to choose the dir. I want the user to be able to
click on button and all else is done for them.

Mark
"Fletcher Arnold" <fl****@home.co m> wrote in message
news:bu******** **@sparta.btint ernet.com...
"Mark Elliott" <me******@ZZZme galink.net> wrote in message
news:10******** *****@corp.supe rnews.com...
Hope I can find an answer here. I am using Access 2000. I know I have no
controll over my column spacing in an html document generated by Access 2000
using the "output to" command. I have read that the same goes for Access
2002. My question is, can it be done in Access 2003?? I have searched
Microsoft site and could not come up with an answer either way.

If the same goes for 2003 then I am open for suggestions. I am currently
outputing to a "snapshot" format but this requires my websites visitors to have or download and install MS Snapshot. I need to avoid "tweaking" the
html doc. outside of access. If it helps, I am using MS Frontpage2000 as

my
editor.

Thanks in advance!
Mark

Do you have any knowledge of writing code? If the built-in output

procedure isn't quite as you need it, then you could always write your own which will format the html exactly as you want. By the way, are you using ASP for
this?

Fletcher

Nov 12 '05 #3
Sorry, I was not using asp..... I played with asp a little today but was
unable to accomplish what I need. I am just an html "developer" so the whole
method of posting report results to the web is new to me. I have used access
quite a bit and html quite a bit, just never together. Untill today, I have
never used asp.

Mark

"Fletcher Arnold" <fl****@home.co m> wrote in message
news:bu******** **@sparta.btint ernet.com...
"Mark Elliott" <me******@ZZZme galink.net> wrote in message
news:10******** *****@corp.supe rnews.com...
Hope I can find an answer here. I am using Access 2000. I know I have no
controll over my column spacing in an html document generated by Access 2000
using the "output to" command. I have read that the same goes for Access
2002. My question is, can it be done in Access 2003?? I have searched
Microsoft site and could not come up with an answer either way.

If the same goes for 2003 then I am open for suggestions. I am currently
outputing to a "snapshot" format but this requires my websites visitors to have or download and install MS Snapshot. I need to avoid "tweaking" the
html doc. outside of access. If it helps, I am using MS Frontpage2000 as

my
editor.

Thanks in advance!
Mark

Do you have any knowledge of writing code? If the built-in output

procedure isn't quite as you need it, then you could always write your own which will format the html exactly as you want. By the way, are you using ASP for
this?

Fletcher

Nov 12 '05 #4
Excellent, I will do that! In the meantime, I am using the "output to"
command. The biggest problem is that the table on the finished html doc. is
set to 100% thus messing up my column spacing. I was able to somewhat
overcome this by displaying the html doc. within a frame and I adjusted the
frame to a "respectabl e" width. It is still not up to my standards but the
boss will be happy. I appreciate all your help. I guess it is definately
time to learn asp. ;)

Mark

"Fletcher Arnold" <fl****@home.co m> wrote in message
news:bu******** **@titan.btinte rnet.com...
"Mark Elliott" <me******@ZZZme galink.net> wrote in message
news:10******** *****@corp.supe rnews.com...
I will be playing with both options today. I read about asp yesterday and tried it a little, but I do not have my page uploaded to a web server yet and it will only display the column headers. Is there anything that
needs to
be set up at the server level?? I will be using a third party server.

Mark

Hi Mark

At the risk of stating the obvious, the machine which hosts your web pages
must be running Internet Information Services (IIS). That is a

fundemental difference between a pure HTML site and one created with ASP - the ASP pages are processed by the software running on the server and the results are sent back to the client browser in HTML. You cannot do anything useful with ASP pages unless you (or a 3rd party) are running this software. The easy thing to do would be to ask this 3rd party "Do you support ASP?"

Don't forget that some versions of Windows (e.g. XP Pro, 2000 Pro) come with IIS which you can set up from the control panel. If you are going to do any ASP work, I would strongly recommend having your own machine to test with
such as a 'normal PC' with Win XP Pro on it. That way you get hands-on
experience with setting up and configuring IIS.

Fletcher

Nov 12 '05 #5
Thanks guys!

My DB will be read only at the website level anyway. I will be posting a
boat inventory that my sales dept. will be able to update without my
intervention. They can just make the changes on an access form and a small
app. on the server will upload the pages at specified intervals. I will be
studying .asp as well so I can hopefully do something better. I'd like the
sales dept to be able to included photos as well.

Mark

"Chuck Grimsby" <c.*******@worl dnet.att.net.in valid> wrote in message
news:7e******** *************** *********@4ax.c om...
On Thu, 22 Jan 2004 12:55:04 +0000 (UTC), "Fletcher Arnold"
<fl****@home.co m> wrote:
"Mark Elliott" <me******@ZZZme galink.net> wrote in message
news:10******* ******@corp.sup ernews.com...
I will be playing with both options today. I read about asp yesterday and tried it a little, but I do not have my page uploaded to a web server yet and it will only display the column headers. Is there anything that needs to be set up at the server level?? I will be using a third party
server.
At the risk of stating the obvious, the machine which hosts your web

pagesmust be running Internet Information Services (IIS). That is a fundementaldifference between a pure HTML site and one created with ASP - the ASP pagesare processed by the software running on the server and the results are sentback to the client browser in HTML. You cannot do anything useful with ASPpages unless you (or a 3rd party) are running this software. The easy thingto do would be to ask this 3rd party "Do you support ASP?"
Don't forget that some versions of Windows (e.g. XP Pro, 2000 Pro) come withIIS which you can set up from the control panel. If you are going to do anyASP work, I would strongly recommend having your own machine to test with
such as a 'normal PC' with Win XP Pro on it. That way you get hands-on
experience with setting up and configuring IIS.


In addition to your comments above, Fletcher, I add that
Access on a website works, but remember that it's not really ment to
do so. Remember to give write permissions to the anonymous account
used for the website to the directory where the database resides.
Otherwise, the DB will be read-only.

WinXP (Pro or Home) isn't required. PWS runs ASP just fine on a Win98
machine.

I also like to recommend to people to read up on what the global.asa
file is, and what can be done with it. A lot of people spend a lot of
time changing things all over a website (like connection strings) that
can be easily stored *once* in the site's global.asa file.

Of course, if one can, .Net is the way to go.... For web apps,
anyways!

Nov 12 '05 #6

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

Similar topics

1
1829
by: Wolfgang | last post by:
XSLT transformations by default seem to pass name space attributes into the root element of their output (example below). QUESTION: Is it possible to control this, i.e. not genrating a name space attribute in the root of the output, or generating other attributes in the root? The following illustrates the case. The XSLT script specifies an output root element
3
2329
by: Dalan | last post by:
Perhaps someone has experienced this problem. I developed an Access 97 Runtime database on a Windows 98 SE machine. I have three reports that can be optionally copied to a floppy disk or hard drive through use of a macro: Output To, Report, the name of the Report, Rich Text Format, Output location and file name, and Auto Start - No. The process has worked flawlessly when running the macro on Windows 98 SE under Access 97 SR2b on the host...
15
13348
by: Mark C | last post by:
All, I have exhaustingly been looking through the newsgroups in search of a way to systemically output an Access 97 report to a pdf file using the full version of Adobe Acrobat. I want the user to be able to click a button and have the Access report saved as a pdf in a directory specified by me the programmer. I have seen a posting by John Baker promoting a web-sight that has an mde that one can reference in any database but after 30...
10
1537
by: George | last post by:
Hi, I have a report which shows all records from database into the browser. The final HTML comes out about 5 Meg. It takes 1 minute 5 seconds for transfer to show up when i hit the page with IE The trace info shows that output was done within 1 second and then i guess it took so much time (> 1 minute) for it to actually be transferred to IE. I am doing test on the same machine. IIS and IE are on the same machine and I believe the actual...
2
2163
by: Will Rickards | last post by:
In my web application there is an interactive report. Then there need to be a printable version a pdf. So I found this java tool csstoxslfo and the java fop tool from apache that will take my xhtml and css and convert it to pdf. Problem 1) I designed the aspx page to produce the xhtml as output. So how do I save that rendered page to a file on the server? I think it involves overriding the Render method. I wrote some code which...
2
2542
by: scott.k.fraley | last post by:
....and the SELECT thats trying to pull from said Query doesn't like it one bit! ;) I'm working on this project (in Access 2002) and there is a report who's RecordSource is the following SELECT; SELECT xTab.FirstOfPRIORITZTN_STATUS_NAME, xTab., iif(IsNull( xTab. ), 0, xTab.) AS ,
0
1526
by: sundowner225 | last post by:
Could someone help me with an output problem? I have an access database that I need to create some xls output from. Basically, I have three tables: Faculty_Table: Fields=ID,Name, Type, Degree, Additional Comments Courses_Table: Fields=ID, CourseName, CourseTitle, Section GradCourse_Table: Fields=ID, CourseName, CourseTitle, Institution
7
2964
by: KiwiGenie | last post by:
I have a form which lists selected records, there could be anything from 1 record to all records selected. I want to output a report for each record as HTML. I want each file to take its name from a certain field (RecipeName), so can't simply put a page break in the report. Would it be possible to create a loop which opens the report hidden, then exports it to HTML, then closes the report, and does this for each selected record? Or would all...
11
4408
by: gnewsgroup | last post by:
In my web application, I would like to dynamically display the progress of a process, something like: Collecting user input ... Saving user profile ... Generating report in PDF ... Dispatching report to user email ... This is something like the installation progress display of DotNetNuke or the Oracle's web-based enterprise manager.
0
9716
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9596
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10604
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10356
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9179
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7644
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
1
4316
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3839
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3006
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.