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

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

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


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

Replies have been disabled for this discussion.