Results 1 to 2 of 2
  1. #1
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528

    open form At specific time


    I have a question
    How to form opens at a specific hour by hour timing computer and after 5 minutes and shuts itself down

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    What I do for things like this is dedicate an entire Access DB file to the task at hand. Have the form you want to open as the Startup form for the DB. After you have everything working with your new DB, you will want it to open at a specific time. For this, you can use windows task scheduler.

    To avoid complicated and or unnecessary security settings, I create a VB Script file to open the Access DB file. Double clicking the .VBS file will launch and open the access file. After you create and test your VBS file, you can have Windows Task scheduler launch the VBS file. You will want to adjust the settings of your new task in Task Scheduler to quit after a specific amount of time. Use advanced settings in Task Scheduler.

    Here is some sample syntax to create a .VBS file. Use Notepad and then change the extension of your text file to .VBS
    https://www.accessforums.net/access/...tml#post223969

Please reply to this thread with any new information or opinions.

Similar Threads

  1. open specific form after login
    By manojsikar1 in forum Forms
    Replies: 1
    Last Post: 11-21-2012, 08:54 AM
  2. Open form on specific record
    By iky123 in forum Forms
    Replies: 1
    Last Post: 04-11-2012, 09:56 AM
  3. Open form to specific record
    By Two Gun in forum Forms
    Replies: 7
    Last Post: 11-09-2011, 10:00 AM
  4. Open Form to Specific Record
    By batowl in forum Forms
    Replies: 1
    Last Post: 04-08-2011, 10:10 AM
  5. Open to specific form
    By ecpike in forum Forms
    Replies: 2
    Last Post: 06-12-2009, 08:32 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums