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

[J. Koskey]

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

[Larry Linson]

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