Results 1 to 4 of 4
  1. #1
    birpal is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Posts
    19

    Creating a calendar as a main menu - data in each date, month and year


    I was wondering if it would be possible creating a calendar as a main menu in which i can select a date in a calendar and open that date's form. Each date in every month will have a form including future ones (even though they may be blank). Also I would like to search for data across dates, months and years if i need to search for a specific filter. The reason i seek this format is i use each day 30 entry divider for the work i need to complete in that day.

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I found this dB years and years ago. It is in A2K format (I think) as it is a mdb file. I'm sure it could converted to accdb format and be modified to meet your requirements.

    Note: this dB does have issues that needs to be addressed - one of which is how variables are declared.
    One declaration is
    Code:
    Dim strSQL, strQRY, strSource, strBox, strTxt, strLst As String
    so even though the prefix is "str", only the last variable is declared as a string - the rest are Variants.



    I wish I could give credit to the creator, but there is no name I could find in the dB.
    Attached Files Attached Files

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    So the calendar dB I posted won't work for you? Hmmmmm........

  4. #4
    birpal is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Posts
    19
    Sorry not that it wont , just that i am very very new to access so I was just looking for answers it it was even possible before i took the endeavor of trying to learn and implement my design. You wen above and beyond my question so thank you.

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

Similar Threads

  1. creating a main menu page
    By DianneBeck in forum Access
    Replies: 1
    Last Post: 06-02-2015, 08:05 PM
  2. Calendar picker with month/year only
    By bbmak in forum Forms
    Replies: 1
    Last Post: 01-11-2014, 02:27 PM
  3. Replies: 4
    Last Post: 05-26-2013, 03:28 PM
  4. Year to DATE by Month
    By lugnutmonkey in forum Queries
    Replies: 1
    Last Post: 01-18-2013, 05:37 PM
  5. month year date
    By slimjen in forum Database Design
    Replies: 6
    Last Post: 04-17-2012, 01:02 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