Results 1 to 8 of 8
  1. #1
    workindan is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    8

    dynamic array for calendar

    I'm wondering what the best way is to create and array where a user can select or de-select multiple dates before submitting a query. I already have a calendar that can detect which date is selected / de-selected.



    The variable "DateSerial(intYear, intMonth, DayIndex)" is receives a value each time a date is clicked on.

    I've created a public array "queryDate(1 to 50)" for the days they might want to select(up to 50 days). The question I have is what's the best way to manage the array as the user clicks on or clicks off dates before submitting the calendar? How do I sort and include/exclude dates in the array as the user clicks and unclicks dates? (Ideally I'd like to have them just add by clicking, but I have to plan for user error when they need to uncheck the wrong date).

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    do don't need to do any thing when the users select or deselect a date, just get the list of dates when submitting.

  3. #3
    workindan is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    8
    No, if there's days selected from multiple months, the form resets every time the month selection is changed. That idea would only work if the user selected days within a single month.

  4. #4
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    I see.

    you can put a list box by the side of you calendar, put all selected dates in the list box. User select dates from calendar, remove dates from the list box. This is easy for the user and easy for you to design.

  5. #5
    workindan is offline Novice
    Windows XP Access 2003
    Join Date
    Jun 2010
    Posts
    8
    Perfect! That'll work great. Have a great weekend, weekend

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Excellent! Are you ready to follow the link in my sig and mark this thread as Solved?

  7. #7
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    I marked it as solved

  8. #8
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Thanks Dan.

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

Similar Threads

  1. Access 2007 Array issue
    By phpuser123 in forum Access
    Replies: 1
    Last Post: 11-04-2010, 01:10 PM
  2. can i put the result in array?
    By dada in forum Programming
    Replies: 1
    Last Post: 08-19-2010, 07:17 PM
  3. Array of labels in runtime
    By ngruson in forum Programming
    Replies: 1
    Last Post: 08-19-2010, 07:30 AM
  4. Building Array
    By jgelpi16 in forum Forms
    Replies: 12
    Last Post: 03-22-2010, 12:33 PM
  5. How to use array? [ solved] Thanks.
    By wasim_sono in forum Programming
    Replies: 0
    Last Post: 10-20-2006, 12:00 AM

Tags for this Thread

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