By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,446 Members | 3,019 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,446 IT Pros & Developers. It's quick & easy.

output report in html

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
"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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.