 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / April 2008Save As HTML - automate - Access 97
Hi, Friends. I'm hoping someone will help me think through this problem. I want to automate the 'Publish to the Web' wizard in Access 97. When you select 'File' and 'Save As HTML' the wizard pops up to gather information from the user. I presume this information is turned into parameters that are passed to a DLL or EXE. Is it possible to call that function and pass parameters programmatically? I certainly would be grateful for further information. Function name and documentation would be most welcome. Thanks. Mark **************** Context... Access 97 database working very well for 10 years. Now client wants (more or less) live web output. Saving certain reports as static HTML (to the web server) works very well manually. Data in tables change througout the work day. Ultimate goal... Live web access to reports (executable producing dynamic reports, bigger project). Short term goal... To automate the Save As HTML so it recreates the web page reports every 15 minutes. I have code in place to run a function every 15 minutes. I just don't know what the function would be called. Hi Mark, look up help for OutputTo Method SendObject Method a quick way to get help is this: press CTRL-G to goto the debuG (Immediate) window type/paste the command you want to look up press F1 or, click on the keyword with your mouse and press F1 Warm Regards, Crystal * (: have an awesome day :) * > Hi, Friends. > [quoted text clipped - 34 lines] > I have code in place to run a function every 15 minutes. I just don't know > what the function would be called. Ah, Crystal. That looks like just what I was after. I'll do a little testing and let you know. Thanks. Mark > Hi Mark, > [quoted text clipped - 55 lines] >> I have code in place to run a function every 15 minutes. I just don't >> know what the function would be called. you're welcome, Mark ;) happy to help Warm Regards, Crystal Access Basics (Access MVP site) http://www.accessmvp.com/Strive4Peace/Index.htm 8-part free tutorial that covers essentials in Access * (: have an awesome day :) * > Ah, Crystal. > [quoted text clipped - 65 lines] >>> I have code in place to run a function every 15 minutes. I just don't >>> know what the function would be called. Crystal, The OutputTo calls have been working beautifully for about 24 hours now - recreating 70-100 static pages every 15 minutes. Many happy folks on this end. Thanks so much. Mark > you're welcome, Mark ;) happy to help > [quoted text clipped - 78 lines] >>>> I have code in place to run a function every 15 minutes. I just don't >>>> know what the function would be called. Hi Mark, very glad to hear that! thanks for letting us know, we love happy folks <smile> Warm Regards, Crystal Access Basics 8-part free tutorial that covers essentials in Access http://www.accessmvp.com/Strive4Peace/Index.htm * (: have an awesome day :) * > Crystal, > [quoted text clipped - 5 lines] > > Mark |
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.