Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
Solved
Close Access Report using the timer
Posted on 2016-08-24
I have some users who have a problem leaving a report opened in Preview mode overnight. Trying to tell them not to do that is like talking to a brick wall sometimes. So what I want to do is have the report close the preview window after a specific amount of time. Can this be done when a report is opened in preview mode? This is how I open the report from my form. This form does stay open but in hidden mode until the user actually closes the report. Then the form is unhidden and they can then close the form also. I want to put a timer on the report so it closes after 5 minutes. So how can I set this up on my report?
Here is the code that opens the report from a command button on my form:
And here is the code that unhides the form once the user closes the report preview:
Here is the code that opens the report from a command button on my form:
Dim stDocName As String
TempVars.Add "strBOForm", Me.Name
stDocName = Me.cboReport
DoCmd.OpenReport stDocName, acPreview
DoCmd.RunCommand acCmdFitToWindow
Me.Visible = False
And here is the code that unhides the form once the user closes the report preview:
Private Sub Report_Close()
Forms(TempVars!strBOForm).Visible = True
End Sub
[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
-
3
- +1
6 Comments
Active today
Well the report has a timer event. IF you set the timer interval equal to 5*60*1000 (5 minutes) and code in the timer event:
EDIT: And note that your close event will still fire, resetting the visibility of the form, regardless of how the report is closed.
Private Sub Report_Timer()
DoCmd.Close acReport, Me.Name
End Sub
EDIT: And note that your close event will still fire, resetting the visibility of the form, regardless of how the report is closed.
Active today
You might also be interested in this MSKB article:
ACC: How to Detect User Idle Time or Inactivity
https://support.microsoft.com/en-us/kb/128814
It's a more generic approach to doing this. When Idle time occurs, most developers add a routine that closes down the app, usually by using the forms and reports collection to close each object that is open.
Jim.
ACC: How to Detect User Idle Time or Inactivity
https://support.microsoft.com/en-us/kb/128814
It's a more generic approach to doing this. When Idle time occurs, most developers add a routine that closes down the app, usually by using the forms and reports collection to close each object that is open.
Jim.
Active 6 days ago
Thank you Anders. That's exactly what I was looking for but I also wasn't sure if the code in the Report Close event would still fire or not.
@ Jim - I actually use that article to close down the DB after a certain amount of time. But I wanted this particular report to close after 5 minutes. The inactivity is set for an hour before it closes the DB all together.
@ Jim - I actually use that article to close down the DB after a certain amount of time. But I wanted this particular report to close after 5 minutes. The inactivity is set for an hour before it closes the DB all together.
Active today
lawrence,
if the app is set to automatically close at 1 hour, how can the users keep the report open over night?
Just asking.
Dale
if the app is set to automatically close at 1 hour, how can the users keep the report open over night?
Just asking.
Dale
Featured Post
Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses
Course of the Month7 days, 4 hours left to enroll
705 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.