I know this has been discussed before but a search on this topic produced no results.. Sooo.. I would like to have my Access 97 database print a report every hour automatically.. Apparently the users find it hard to push a button once an hour.. Can this be done without using the windows scheduler? Thanks..
![]() |
There are isolated problems with current patches, but they are well-known and documented on this site. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
Print a report every hour automatically
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Print a report every hour automatically
- This topic has 6 replies, 4 voices, and was last updated 23 years, 11 months ago.
Viewing 1 reply threadAuthorReplies-
WSMarkJ
AskWoody Lounger -
WSgbanks
AskWoody LoungerApril 30, 2001 at 11:55 am #524595Hey Mark.. I messed with that a little.. I had it printing every 10 minutes or so.. Would you know how to make it print at a certain time.. Like 9:30.. I got this code from another post but it keeps failing (Run time error 13 type mismatch.. I used this on the ON timer event and set the Time interval to run every mintue but it failed..
From what I gather it should check the time see if it’s 8:00 if it is it print the report.. Don’t know why it failed though..If Format(Time(), “hh”) = 8 Then
docmd.openreport “ReportName”,acNormal,””,””
else
exit sub -
WSBrian Swann
AskWoody LoungerApril 30, 2001 at 12:06 pm #524596
-
-
WSVBNerd
AskWoody Lounger-
WSgbanks
AskWoody LoungerMay 1, 2001 at 12:14 am #524664I’ve experimented with the windows scheduler and it does work well but my users are completely clueless.. The whine and complain if the have to do anything.. I made a batch file that the user needs to run to update the database to a new version and they compalin about that.. I mean it is tough to type r:system.bat and the run command.. Sorry just venting.. But to use Scheduler I would have to go to each users pc about 30 and set the appointments.. Unless there is another way?
-
WSVBNerd
AskWoody LoungerMay 2, 2001 at 12:47 pm #524839Are you saying that each user has to run a report every hour?
At my place of employment, I have a separate PC that all it does it run jobs. I use WSH & VBScripts and put them in the scheduler. We have scripts that fire up Excel, generate some charts, and E-mail when it’s done. I haven’t done any VBScripts with Access but I’d be willing to bet that it’s possible. You could write the script to E-mail the report or better yet publish the report to a web. I don’t know all the details of your situation, so this is just my
-
Viewing 1 reply thread -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Microsoft vs Passwords
by
Alex5723
11 minutes ago -
Windows 11 Insider Preview build 26200.5516 released to DEV
by
joep517
3 hours, 12 minutes ago -
Windows 11 Insider Preview build 26120.3653 (24H2) released to BETA
by
joep517
3 hours, 13 minutes ago -
Two March KB5053606 updates?
by
Adam
8 hours, 18 minutes ago -
MS Edge Not Updating to v134.0.3124.95 (rel. 27-Mar-2025)
by
lmacri
4 hours, 27 minutes ago -
Intel® Graphics/Sound Driver updates for 7th-10th Gen Intel® Core™ Processor
by
Alex5723
2 hours, 53 minutes ago -
Is there a comprehensve way to tranfer ALL current Edge Settings into a new Edge
by
Tex265
14 hours, 55 minutes ago -
Transferring ALL info/settings from current Firefox to new computer Firefox
by
Tex265
16 hours, 17 minutes ago -
DOGE Wants to Replace SSA 60 Million Line COBOL Codebase in Months
by
EyesOnWindows
11 hours, 4 minutes ago -
KB5051989 Usb printer Post Ipp
by
licencesti
15 hours, 17 minutes ago -
Removing bypassnro
by
Susan Bradley
46 minutes ago -
Up to 30 seconds to show “Recent Topics”
by
PL1
19 hours, 38 minutes ago -
Sound changes after upgrade from W11 23H2
by
WStaylorpsepa
21 hours, 21 minutes ago -
Windows bug blocks BIOS updates for Lenovo ThinkPad laptops
by
Alex5723
1 day ago -
O&O Software – ‘World Backup Day’ Sale
by
unbob
20 hours, 44 minutes ago -
Still version 23H2?
by
WSbxcfilm
1 day, 1 hour ago -
Ubuntu 25.04 (Plucky Puffin) Beta released
by
Alex5723
1 day, 7 hours ago -
How to install App Store apps on an external SSD
by
Alex5723
1 day, 8 hours ago -
Where is Windows going?
by
Susan Bradley
1 hour, 6 minutes ago -
Installing Feature Update Windows 11 24H2
by
geekdom
2 days, 1 hour ago -
Windows 11 Insider Preview build 27823 released to Canary
by
joep517
2 days, 1 hour ago -
Windows 11 Hotpatch
by
Hackmuss
1 day, 9 hours ago -
System Guard service error still won’t be fixed
by
Susan Bradley
2 days, 2 hours ago -
Operation ForumTroll: APT attack with Google Chrome zero-day exploit chain
by
Alex5723
1 day, 20 hours ago -
Troy Hunt of HaveIBeenPwned Phished
by
Lars220
2 hours, 12 minutes ago -
Microsoft Windows security auditing Code 5061
by
mpw
2 days, 15 hours ago -
Can’t display images in incoming Outlook 365 emails
by
WScopwriter
1 day, 22 hours ago -
Windows 11 Insider Preview Build 26200.5510 early builds of 25H2
by
Alex5723
2 days ago -
0Patch : Micropatches released for SCF File NTLM Hash Disclosure Vulnerability
by
Alex5723
1 day, 23 hours ago -
Select multiple emails and they all open up!
by
CeeJay
3 days, 16 hours ago
Recent blog posts
- Removing bypassnro
- Where is Windows going?
- System Guard service error still won’t be fixed
- Third party add ins reminder
- MS-DEFCON 4: Mixed bag for March
- Classic and Extended Control Panel — no need to say goodbye
- Things you can do in 2025 that you couldn’t do in 2024
- Revisiting Windows 11’s File Explorer
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.