Results 1 to 2 of 2
  1. #1
    LaughingBull is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Location
    Toledo Ohio
    Posts
    143

    creating a weekly appointment calendar with 30 min appointments in access 2016 64bit

    I need help with the VBA code to create this calendar. I have never created a calendar before and I am not a professional. If someone would be kind and patient to help me with this I would greatly appreciate their help.


    I can download a monthly calendar but I don't know how to edit the code to make it into a weekly calendar. I have searched for the code to create a weekly calendar with no findings.
    attached is a view of what I want the calendar to look like.
    we can discuss more of the specifics off line if you are willing.
    Thanks in advance for considering helping me with this DB.
    Click image for larger version. 

Name:	calendar view.jpg 
Views:	28 
Size:	130.4 KB 
ID:	29150

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    youd have a table tApps:
    name, ApptDate, ClientArrive, Note

    once you add items, it can then be displayed (as a grid) via Crosstab query. But not quite as you show.
    A grid that complex may need a 'report' table, that looks like the above, but gets loaded via a series of append queries.

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

Similar Threads

  1. weekly appointment calendar access 2016
    By LaughingBull in forum Access
    Replies: 1
    Last Post: 05-17-2017, 02:48 PM
  2. Replies: 0
    Last Post: 09-10-2016, 11:55 AM
  3. Access - Outlook Appointment shared calendar
    By Guerra67 in forum Access
    Replies: 1
    Last Post: 09-21-2014, 07:26 PM
  4. Replies: 1
    Last Post: 05-31-2013, 02:04 AM
  5. Exchange calendar appointments
    By avarusbrightfyre in forum Import/Export Data
    Replies: 1
    Last Post: 10-31-2011, 12:15 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