473,320 Members | 1,691 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,320 software developers and data experts.

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 2275
"Mark Elliott" <me******@ZZZmegalink.net> wrote in message
news:10*************@corp.supernews.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.com> wrote in message
news:bu**********@sparta.btinternet.com...
"Mark Elliott" <me******@ZZZmegalink.net> wrote in message
news:10*************@corp.supernews.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.com> wrote in message
news:bu**********@sparta.btinternet.com...
"Mark Elliott" <me******@ZZZmegalink.net> wrote in message
news:10*************@corp.supernews.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 "respectable" 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.com> wrote in message
news:bu**********@titan.btinternet.com...
"Mark Elliott" <me******@ZZZmegalink.net> wrote in message
news:10*************@corp.supernews.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.*******@worldnet.att.net.invalid> wrote in message
news:7e********************************@4ax.com...
On Thu, 22 Jan 2004 12:55:04 +0000 (UTC), "Fletcher Arnold"
<fl****@home.com> wrote:
"Mark Elliott" <me******@ZZZmegalink.net> wrote in message
news:10*************@corp.supernews.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
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...
3
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...
15
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...
10
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...
2
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...
2
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...
0
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,...
7
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...
11
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.