You are here:

Using MS Access/disable a form an a specific time

Advertisement


Question
QUESTION: How to disable MS access form after certain duration
Dear sir,
I want to disable a ms access form on a specified time.
Any idea?
thank you

ANSWER: What do you mean by specified time? Shut down the form after a certain hour of the day? Disable the database after a certain number of days? I need more information.

---------- FOLLOW-UP ----------

QUESTION: hy, i mean that i want that at a given day (example: on 01/01/2014)
i want the ms access project to stop working(no user can access it except me as administrator and i can change the stopping date) like this at the end of the year he need me to open the project for the following year.

Answer
You could put a little code in the OnOpen event of a form:

If Date() > #1/1/2014# then

Then do whatever you want: shut down Access, pop up a warning message, close the form, etc. Of course if your database isn't properly SECURED then the user can just bypass your startup form/macro and remove that code. I show how to lock down and secure your database in my ACCESS SECURITY SEMINAR.


Be sure to visit my web site and watch my FREE 2-hour-long Microsoft Access Video Tutorial

Cordially,
Richard Rost
599CD Computer Training

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Richard Rost

Expertise

I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site, and free Access 101 tutorial.

Experience

I am the president of AccessLearningZone.com and 599CD.com. I specialize in Microsoft Access Tutorials. I have been teaching Access in the classroom since 1994, and online since 2002.

Education/Credentials
I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com

©2016 About.com. All rights reserved.