Solved

Adding Code to VB HTML Output

Posted on 2013-12-02
16
590 Views
Last Modified: 2014-01-05
We have Scheduled Tasks that run every 15 minutes to update our Intranet reports, giving our employees one-click access to HTML reports.

Using the following VB code in an Access form's Open Event procedure:

DoCmd.OutputTo acOutputReport, "rptOEDailyOrdersTaken", acFormatHTML, "\\bordenfp\intranet\reports\qryOEDailyOrdersTaken.htm", True

Is it possible to add code such as the following to force this page to auto-refresh?

<meta http-equiv="refresh" content="5">
0
Comment
Question by:slamond
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
16 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39691043
<meta http-equiv="refresh" content="5">  means every 5 seconds.  That could be a lot of network traffic plus that's a pretty short time to view a page.
0
 
LVL 43

Expert Comment

by:Rob
ID: 39691045
Not without trying to code access to open the HTML and Add it manually.  It may or may not be possible in your environment but I would serve these HTML files via a webserver and server side script like php.  It opens up a lot more possibilities as you can read the requested report and embed it in a page that refreshes as often as you need.
Another simple solution would be to use an iframe.  Create a "wrapper" page for each report that just has the basic HTML layout with your meta refresh tag but also an iframe in the body of the HTML with its src attribute pointing to the HTML report.
Make sense?
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39691050
you  can open the webpage after the update

DoCmd.OutputTo acOutputReport, "rptOEDailyOrdersTaken", acFormatHTML, "\\bordenfp\intranet\reports\qryOEDailyOrdersTaken.htm", True

'this will open the page
followhyperlink  "\\bordenfp\intranet\reports\qryOEDailyOrdersTaken.htm"

another way is add script to your page to refresh it automatically on timer
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 53

Expert Comment

by:Scott Fell, EE MVE
ID: 39691070
I suggest using your vb code to dynamically generate the html file http://msdn.microsoft.com/en-us/library/microsoft.visualbasic.filesystem.writeline(v=vs.110).aspx

Now when you use javascript to refresh the page, you are not taxing the db.  You just want to keep in mind how often the refresh will happen at one time.  Do you have 100 people using this or 1000?
0
 
LVL 21
ID: 39691753
slamond,

You said: "We have Scheduled Tasks that run every 15 minutes to update our Intranet reports"

Having a refresh rate must faster than 15 minutes would be a lot of wasted trips to get the same web page.  A 5 second refresh means there are 180 refreshes between each 15 minute scheduled task run. I would start with a refresh of 300 second or longer to see if that works.

If it were my project I would go with  tagit's suggestion of a wrapper page. Very simple to do.

I would have the wrapper page be named qryOEDailyOrdersTaken.htm. I would update the Access app to output to the file  to a new name. Something like: qryOEDailyOrdersTaken_data.htm. Have the wrapper page show this file.

By having the wrapper page use the original file name I would expect all the users to already have a working link. Nothing else to update.
0
 

Author Comment

by:slamond
ID: 39704330
I will try tagit's idea ASAP. Just posting a reply so the system doesn't flush my question.
0
 
LVL 48

Expert Comment

by:Martin Liss
ID: 39747159
I've requested that this question be deleted for the following reason:

Not enough information to confirm an answer.
0
 
LVL 21
ID: 39747160
tagit's (not sure what happened to it since tagit no longer has a post here) suggestion of a wrapper page works. I use the iFrame solution now..

@MartinLiss, There are a lot  of old posts that refer to a poster's name that no longer appear. The older post are becoming confusing to follow! Are there data issue with the EE database?
0
 
LVL 43

Expert Comment

by:Rob
ID: 39747459
I'm still here but yes very confusing. I second the objection.
0
 
LVL 21
ID: 39747536
I see Rob Jurd (tagit) is back. I swear it only said Rob Jurd earlier without the original user name suffix of  (tagit) . Whatever cause the change really helps clear things up.
0
 
LVL 43

Expert Comment

by:Rob
ID: 39747543
Its called changing my last name to have the username in brackets. ..
0
 
LVL 21
ID: 39747553
@Rob Jurd (tagit), that is brilliant. Hope everyone else will do the same.

Thanks for the Tip!
0
 
LVL 43

Expert Comment

by:Rob
ID: 39747559
No prob :) I think a few simple things were overlooked with the profile updates!
0

Featured Post

Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Suggested Courses

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question