469,127 Members | 1,305 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,127 developers. It's quick & easy.

How to add extra code to an acOutputQuery function outputting to html

547 512MB
I use the following line to export a query to html.
Expand|Select|Wrap|Line Numbers
  1. DoCmd.OutputTo acOutputQuery, "Live_ Race_ Results", "HTML(*.html)", "c:\RTweb\WebResults.html", False, "", 0, acExportQualityScreen
How can i add the following refresh function to the html code when it is created, when the query is exported.
Expand|Select|Wrap|Line Numbers
  1. <meta http-equiv="refresh" content="5" >
please assist
Sep 12 '12 #1

✓ answered by zmbd

Along the same lines as TheSmileyCoder except use the built in
Expand|Select|Wrap|Line Numbers
  1. open dirpath$ for append as #1
  2. print #1 "your text"
  3. close #1
http://www.applecore99.com/gen/gen029.asp
-z

4 1661
TheSmileyCoder
2,321 Expert Mod 2GB
You could open the file as a textstream and then make the required modifications using the FileSystemObject in the Windows Script Host Object.
Sep 12 '12 #2
zmbd
5,400 Expert Mod 4TB
Along the same lines as TheSmileyCoder except use the built in
Expand|Select|Wrap|Line Numbers
  1. open dirpath$ for append as #1
  2. print #1 "your text"
  3. close #1
http://www.applecore99.com/gen/gen029.asp
-z
Sep 12 '12 #3
neelsfer
547 512MB
Sorry i am a bit lost here. Have you perhaps got an example of code on how to do that please
Sep 13 '12 #4
Rabbit
12,516 Expert Mod 8TB
@neelsfer, zmbd did post example code.
Sep 13 '12 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Tom | last post: by
1 post views Thread by Jurate | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.