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 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
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
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
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
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! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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,...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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...
| |