Results 1 to 2 of 2
  1. #1
    Travb81 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Aug 2014
    Posts
    18

    Advanced form design - calendar design, unbound controls

    I'm trying to design an interface, which displays 14 days of scheduling data as 14 columns,... and say 10 rows of installers.


    Each cell would display a piece of job data, or multiple if there were multiple jobs for that installer on that day.
    Clicking on a cell would launch a new form to allow the creation of a new item, or edit an existing item.
    And eventually, drag/drop one cell location to another to change the installer or date would be neat.
    The list of installers is dynamic and might change from month to month.

    My suggestion on how to achieve this, would be to use unbound text boxes, and a lot of code.
    14 x 10 = 140 cells, but I think 100 text boxes would be a start, there is not always a job on every day, and some jobs can span over multiple days. So one text box can have a width of say 3x cells.

    There is a similar solution that has been done this way:
    https://www.accessforums.net/showthread.php?t=77921

    I'm interested to hear any feedback/suggestions.
    Or if there is an easier way.
    Hoping the performance to grab the data, arrange the controls and paint the data would not be too slow.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,468
    The simple way is use a query in the date range,then use a Crosstab query on that. But it won't be as robust as the example.

    2nd way is make a 'report' table ,that has the columns, then run 7 append queries to fill the Days of Week.

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

Similar Threads

  1. Reset Position of Controls in Design View
    By ItsRoland in forum Access
    Replies: 5
    Last Post: 07-20-2018, 01:54 PM
  2. Replies: 8
    Last Post: 05-01-2017, 04:58 PM
  3. Replies: 4
    Last Post: 08-26-2015, 08:47 AM
  4. NOOB - moving controls in design view
    By brettnolan in forum Access
    Replies: 4
    Last Post: 04-24-2014, 05:37 PM
  5. Replies: 2
    Last Post: 06-22-2012, 01:32 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