 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2008Save Query as a HTML File
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---  SignatureRyGuy That sounds strange. Make sure the query is in datasheet view and has the focus, then File > Export. Select HTML Documents (*.html;*.htm) in the Save As Type combo box and name the file. The resulting file should be in HTML format, which any browser can read. Chris Microsoft MVP >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 [quoted text clipped - 4 lines] >Regards, >Ryan--- 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--- SignatureRyGuy > That sounds strange. Make sure the query is in datasheet view and has the > focus, then File > Export. Select HTML Documents (*.html;*.htm) in the Save [quoted text clipped - 12 lines] > >Regards, > >Ryan--- 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--- 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 [quoted text clipped - 10 lines] >>> >Regards, >>> >Ryan--- 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--- SignatureRyGuy > 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 [quoted text clipped - 18 lines] > >>> >Regards, > >>> >Ryan--- Glad you've got it working. They look a lot alike but now you know the difference. Chris Microsoft MVP >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!! [quoted text clipped - 7 lines] >> >>> >Regards, >> >>> >Ryan--- thanks ryan >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 [quoted text clipped - 5 lines] > Regards, > Ryan--- |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.