473,320 Members | 2,112 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.

"Save as HTML" feature in Access 95 or 97??

Background: We have hundreds of codes = specific departments, but
there are frequent changes/additions to the info. For users to look
up definitions, we had set up a way in Access to create a webpage link
for each separate code. Back in an earlier version of Access - 97 or
possibly 95 - there was a command of <File><Save as HTML> which let us
select *all* of the 350+ queries and go through a wizard to save them
all as HTML.

Problem: This <File><Save as HTML> was no longer available once we got
Windows 2000. We'd like to migrate everything to a newer solution
using Access 2000, but we don't know a way that wouldn't be very labor
intensive. Just couldn't beat that "Select all queries" of the old
way.

I think the <File><Export><Save as type HMTL documents> has
possibilities - but is there any way to get it to automatically repeat
the process through 350+ queries? We aren't very good at macros, so
if that's the solution - we'll learn.

Thanks for any feedback. J. Koskey
Nov 12 '05 #1
1 1989
I'm not even sure what it would mean to save _Queries_ as HTML -- it makes
no sense at all to me. A web browser can't execute a Query, and there is no
HTML equivalent to a Query.

There is an option to save a Report's _output_ as HTML... perhaps it is the
results of the Queries that you were saving as HTML rather than the Queries?

Larry Linson
Microsoft Access MVP

"J. Koskey" <ko*****@uihc.uiowa.edu> wrote in message
news:61*************************@posting.google.co m...
Background: We have hundreds of codes = specific departments, but
there are frequent changes/additions to the info. For users to look
up definitions, we had set up a way in Access to create a webpage link
for each separate code. Back in an earlier version of Access - 97 or
possibly 95 - there was a command of <File><Save as HTML> which let us
select *all* of the 350+ queries and go through a wizard to save them
all as HTML.

Problem: This <File><Save as HTML> was no longer available once we got
Windows 2000. We'd like to migrate everything to a newer solution
using Access 2000, but we don't know a way that wouldn't be very labor
intensive. Just couldn't beat that "Select all queries" of the old
way.

I think the <File><Export><Save as type HMTL documents> has
possibilities - but is there any way to get it to automatically repeat
the process through 350+ queries? We aren't very good at macros, so
if that's the solution - we'll learn.

Thanks for any feedback. J. Koskey

Nov 12 '05 #2

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

Similar topics

4
by: Dariusz | last post by:
I have the following code which executes successfully to call the browsers "save as" box... //Screensavers if ($FileType == 'scr') { // We'll be outputting a screensaver header('Content-type:...
2
by: RickL | last post by:
I have an ASP application that uploads a specified file to the server. To retrieve the file, I simply assign the filepath and file to a hyperlink on the page. When you click "Save Target As" for...
27
by: Curious Angel | last post by:
I have a resume in PDF format and I want anyone who LEFT-OR-RIGHT clicks the link to force the file to be saved, and in any event _not_ opened. Since the PDF will be in his cache in any event, I...
6
by: Jon Davis | last post by:
I recently learned how to do an <OBJECT> alternative to <IFRAME> in current browsers using: <object id="extendedhtml" type="text/html" data="otherpage.html" width="250" height="400"></object> ...
1
by: J. Koskey | last post by:
Background: We have hundreds of codes = specific departments, but there are frequent changes/additions to the info. For users to look up definitions, we had set up a way in Access to create a...
0
by: COMantilles | last post by:
Hi, Hi created a simple function to open a word doc on server then save it to HTML, ok for the result except that i would like to save it to "filtered" HTML without office's tags (word 2002...
3
by: B-Dog | last post by:
I'm checking some files to see if the filenames are in a certain format and if not I want to pull up a dialog box that gives me a save as with the file that is in question. I have all the files in...
60
by: FAQ server | last post by:
----------------------------------------------------------------------- FAQ Topic - How do I prompt a "Save As" dialog for an accepted mime type?...
2
by: Accessed | last post by:
Hi All I cannot see for the life of me how to do a "Save As" when in table design ! Its not critical, but it used to be so handy when coding to be able to copy (then paste) the table name and...
1
by: craigslist.jg | last post by:
Hi, I've built a client side webpage for our internal users, which when loaded, generates some HTML within an iFrame. The HTML generated to the iFrame is then saved as HTML. I know it's useless...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
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
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.