Save Query as a HTML File

[ryguy7272]

I am trying to save a Query as an HTML file so people in my office, who do
not have Access, can view the results of various Queries. I thought that
anyone with an Internet Explorer Browser could open the HTML files that
Access creates, but they actually can not! As an alternative, is there a way
to save a Query in .PDF format?

Regards,
Ryan---

 

[ryguy7272]

Thanks Chris. I just tried your suggestion and it still doesn't work. Just
before the file opens, I see a message in the lower left hand corner of the
browser that says 'Databinding'. It works on my computer, because I have
Access but it doesn't seem to work on other's computers. Maybe this is the
way it is designed to work? Please respond if you get a chance.


Regards,
Ryan---

 

[ryguy7272]

Chris, you are right. I guess I saved it as a DAP file last time. I tried
it again, and saved it as a true HTML file tis time. Thanks so much!!

Regards,
Ryan---

--
RyGuy

And you're right about the others not being able to open it. You can't open
a DAP file - even though it's an HTM format file - unless you have the office
web components installed. The DAPs are designed that way, but a regular HTML
page export should be able to be opened by any browser.

Chris
Microsoft MVP

Databinding means it's a DAP, not an HTML page. The steps I suggested are
designed to create an HTML page, not a DAP page. When you save it as an HTML
file, are you getting an "Export Query '<my query name>' To... dialog window
which shows all the Access db files in the folder, or are you getting a "Save
as" dialog window?

Chris
Microsoft MVP

Thanks Chris. I just tried your suggestion and it still doesn't work. Just
before the file opens, I see a message in the lower left hand corner of the

[quoted text clipped - 10 lines]

Regards,
Ryan---

 

[Nicholas Meyer]

thanks ryan