Find Jobs
Hire Freelancers

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

$10-30 USD

Terminado
Publicado hace más de 8 años

$10-30 USD

Pagado a la entrega
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
ID del proyecto: 9109135

Información sobre el proyecto

6 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 2 días
5,0 (11 comentarios)
4,0
4,0
6 freelancers están ofertando un promedio de $30 USD por este trabajo
Avatar del usuario
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 en 1 día
4,6 (37 comentarios)
6,0
6,0
Avatar del usuario
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 en 1 día
5,0 (66 comentarios)
5,6
5,6
Avatar del usuario
A proposal has not yet been provided
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Hejupe St, United States
5,0
3
Forma de pago verificada
Miembro desde dic 7, 2015

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.