Results 1 to 2 of 2
  1. #1
    sved is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2011
    Posts
    1

    Refreshing Daily Checklist

    Hello all, ive been having troubles creating some daily checklists with check-box's that would repopulate themselves each new day. the user needs to have the ability to add new tasks to it via another add new task form and have it show up on the check list form or do this directly from the tasks form. I've tried to make a form with a task text-box field with a check-box bound to it and make that a continuous sub form which lists the tasks and their check-box's. i cant seem to figure out the relationship between that and the main form where the user enters their information such as the date and the name of the user doing the checklist and still have the tasks refresh each new day. is there anyone out there who can suggest how i can create a daily check list that the user can add tasks to, refreshes itself for each new day, still keeps track of every day and run reports on what was done and not done? are there any examples or templates? I've had little luck so far reading through forums. any suggestions are greatly appreciated. thanks.

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    As far as the refreshing part, just use MSAccess's form OnTimer event. I refresh our calling lists every 5 seconds (ie. me.listCalls.requery).

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

Similar Threads

  1. Creating a checklist in Access forms
    By bhavani in forum Forms
    Replies: 1
    Last Post: 02-15-2012, 06:01 AM
  2. Link Tables Not Refreshing
    By goodguy in forum Import/Export Data
    Replies: 14
    Last Post: 01-04-2011, 12:49 PM
  3. Refreshing queries without opening them
    By trialpayjinn in forum Access
    Replies: 3
    Last Post: 07-01-2010, 05:04 PM
  4. Filling a table from a checklist
    By mr.wizzard in forum Access
    Replies: 3
    Last Post: 06-19-2010, 09:40 AM
  5. Refreshing comboboxes in a subform
    By KB_Dev in forum Programming
    Replies: 1
    Last Post: 04-07-2009, 12:12 PM

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