Find Jobs
Hire Freelancers

Add Code to MS Access To Close Out Users Who Are Inactive

$10-30 USD

Completed
Posted over 8 years ago

$10-30 USD

Paid on delivery
I have a frontend database that is distributed to several users. When these users forget to logout and go home at the end of a workday, I can't edit the backend database. I want the system to log/close out users who haven't been active for one hour. However, I want this script to terminate if logged in as "Developer or Coordinator" which is a password protectected form I've already designed. I will need an email sent containing the exact code and an explanation of how to adjust the times (in case I want to change from one hour to two hours). Here's something that may work (but needs to be nullified if developer is logged in): Public Function IsMDE() As Boolean Dim db As [login to view URL] On Error GoTo tagError Set db = CurrentDb If [login to view URL]("MDE") = "T" Then IsMDE = True End If tagNoProperty: [login to view URL]: Set db = Nothing On Error GoTo 0 Exit Function tagError: Select Case [login to view URL] Case 3270 ' Property not found IsMDE = False Resume tagNoProperty Case Else MsgBox "Error " & [login to view URL] & " (" & [login to view URL] & ") in procedure IsMDE of Module mdltt_FixReferences" End Select End Function
Project ID: 9109135

About the project

6 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Yes! I could also do this! It will be a new invisible form that will open at the same time the database does. But, it will count the idle time the user hasn't interacted with the database. If the idle time equals your desired time, then the database will be saved and closed
$35 USD in 2 days
5.0 (11 reviews)
4.0
4.0
6 freelancers are bidding on average $30 USD for this job
User Avatar
Hi Why you don't want to add time tracker in front end?- after one hours it's closed by itself. Regards Zura
$25 USD in 1 day
4.6 (37 reviews)
6.0
6.0
User Avatar
Hi I am interested in this project .I am an experienced MS Access applications developer. i can do this job for you. If interested in hiring me then please let me know so that we can discuss it further. Thanks regards Jawad
$35 USD in 1 day
5.0 (66 reviews)
5.6
5.6
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I set such a code, but it is distributed to each front db. Using the form OnTimer event procedure, the code checks the current active control to see if it has changed. If the active control has not changed in a period of time specified in the 'frmShutDown' OnOpen event procedure, then this application will shut down.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Hejupe St, United States
5.0
3
Payment method verified
Member since Dec 7, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.