Results 1 to 15 of 15
  1. #1
    Join Date
    Jul 2014
    Posts
    5

    Question Developing a calendar

    I need some help designing a calendar that will visually designate dates that patients come in so that I can for instance visually see that a patient was in twice last week and three times the week before.



    Also, would like the calendar to differentiate types of patient visits. For example, an exam on Monday is a blue square, a regular office visit is a blue circle. Future appointments are a yellow circle and future examinations are a red square.

    I am not very far into learning about Access yet so point me in the direction of help is appreciated too.
    I found a calendar on the Microsoft site but don't know how they programmed it to put the blue squares on this one.

    PeterClick image for larger version. 

Name:	Calendar Q.JPG 
Views:	119 
Size:	29.6 KB 
ID:	17073

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    amrut is offline Expert
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    Dubai
    Posts
    614
    Can you provide the link to the site where you found the above calender ?

  4. #4
    Join Date
    Jul 2014
    Posts
    5
    Sure, I opened Excel, clicked on new and clicked on calendars. Any of the student calendars in there work the same as the one I pasted.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    There is no code in those calendar workbooks. There is no database. The cell coloring is Conditional Formatting.

    Building calendar in Access using normalized data is much more complicated.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    Join Date
    Jul 2014
    Posts
    5
    I would love it if you could show me how you know that.

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    How I know what?

    That the Excel used Conditional Formatting?
    Select a calendar cell then from the ribbon: Home / Conditional Formatting / Manage Rules
    That there is no code?
    Open the VBA editor and look.
    That there is no database?
    There are no records on the worksheets aside from what is in the calendar cells.

    Or that a calendar in Access with normalized data is more complicated?
    I have seen database with code for accomplishing this. Finding again is a challenge.
    See link in post 2. It's third link offers a database.
    Last edited by June7; 07-03-2014 at 02:14 PM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Quote Originally Posted by docpanderson View Post
    ...I am not very far into learning about Access yet so point me in the direction of help is appreciated too....
    Here are my two cents. Contact a local consultant to bid on designing an appointment app with a Calendar interface. Ask for an estimate with Automation of an existing calendar app like Outlook and an estimate for a stand alone app.

  9. #9
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    As J7 notes - a calendar form is surprisingly complicated to build from the ground up. Humans take it for granted because it is so common, but in fact varying from 28 to 31 days is complex... even the Mayans gave up after awhile.... then there is the size of each day field and how much info can really fit in there..... Following the links provided by J7 and searching one will find some shareware and some to buy - - but in all cases you are going to end up working with their definition of how the calendar should work as modifying these is extremely complex.... This is one form that I think Microsoft themselves should embed as a feature of the product - but alas I am not sure there is any development of this kind happening......

  10. #10
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,442
    As other have noted, calendars are tricky things with MS Access. I'm enclosing a database with a custom calendar to show you one approach.

    The conditional formatting will not work with my example because I'm using list boxes instead of subforms for each date. You could theoretically have subforms for each date but it would be really cumbersome, you might, however be able to change the background color of each subform, or, alternately have another shape around the date that would accept conditional formatting (either with VBA or the toolbar help)

    Anyway, it's just one method among many you could use.

    CalendarExample.zip

  11. #11
    Subwind is offline Can Only Learn
    Windows XP Access 2010 32bit
    Join Date
    May 2012
    Location
    Portsmouth, UK
    Posts
    61
    Click image for larger version. 

Name:	Calendar.png 
Views:	108 
Size:	28.4 KB 
ID:	17194

    I have a working one, I used and edited a code I found on the web but cannot remember where I found it...

    Let me know if you would like a copy of the code.

    ~Matt

  12. #12
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    I think the longest thread that I have ever seen, in an Access forum, was on this subject; I finally stopped following it when it approached 400 posts and was still far from a solution!

    There are times when off-the-shelf software, for a given task, just makes more sense than rolling-your-own, both money wise and time wise; and I would think that this is one of those!

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  13. #13
    djspod is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Mar 2015
    Posts
    164
    Hi Subwind,

    I would like a copy of the DB and code if you can share it?

    Thanks

  14. #14
    SmugglersBlues is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2013
    Posts
    8
    Access Solutions by Arvin Meyer and Douglas J. Steele have easy to follow instructions for building this type of weekly calendar. I have created it and heavily modified it for my needs.

    Quote Originally Posted by rpeare View Post
    As other have noted, calendars are tricky things with MS Access. I'm enclosing a database with a custom calendar to show you one approach.

    The conditional formatting will not work with my example because I'm using list boxes instead of subforms for each date. You could theoretically have subforms for each date but it would be really cumbersome, you might, however be able to change the background color of each subform, or, alternately have another shape around the date that would accept conditional formatting (either with VBA or the toolbar help)

    Anyway, it's just one method among many you could use.

    CalendarExample.zip

  15. #15
    tonycl69 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Nov 2012
    Posts
    102
    Hi there subwind, if you are still around and have that code I would be grateful if you could let have it, cheers.

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

Similar Threads

  1. Developing MS Access Template
    By Abdullah Khan in forum Access
    Replies: 6
    Last Post: 06-12-2014, 02:55 PM
  2. Question on developing a querie
    By miner2007 in forum Queries
    Replies: 2
    Last Post: 10-23-2012, 06:16 AM
  3. Replies: 1
    Last Post: 09-07-2011, 02:21 PM
  4. Developing a complex module
    By Alex Motilal in forum Modules
    Replies: 4
    Last Post: 09-01-2011, 10:03 AM
  5. Replies: 1
    Last Post: 02-22-2010, 10:37 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