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

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • J. Koskey
    #1

    "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
    Tags: None
    • Larry Linson
      #2
      Re: &quot;Save as HTML&quot; feature in Access 95 or 97??

      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" <koskeyj@uihc.u iowa.edu> wrote in message
      news:6178114.04 04090630.5dd979 26@posting.goog le.com...[color=blue]
      > 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[/color]


        Comment

        Previous template Next
        Working...