Results 1 to 7 of 7
  1. #1
    austinl is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    4

    "Rolling Calender"

    Hello,



    I have a table in access with a bunch of records. Some of these records have dates while others do not. What i want to do is have a calendar in access which shows the next seven days that contains any of the records with dates within these next 7 days to appear. It should be linked with the table, so if a date is updated in a table, it automatically adds/removes it from the table. Any ideas how to do this with minimal coding (don't have any experience with coding in Access at all).

    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    normally, you dont remove records from the table. They stay forever.
    but the query would have the criteria:

    where [datefld] between Date() and Date()+7

    this will always show you records from today for 1 week.

  3. #3
    austinl is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    4
    Oh sorry, I don't want to remove any records from the table. All I want is a calendar that shows the next seven days in the week. Any records within the seven days are to be shown on this calendar within access.

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    access doesnt really have a calendar (like Outlook)
    but it can show you 7 days as rows (down in a select query)
    or 7 columns (across in a Crosstab query)

  5. #5
    austinl is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    4
    Any way i can format it to look like a calendar in rows, so like the headers are the dates (Monday, January 1st format), with it populating with the records underneath the correct date?

  6. #6
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    make Q1, to pull the data you want,
    then make a crosstab query , using Q1 to view it as a row.

    (use the query wizard if you need)

  7. #7
    austinl is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    4
    Hello,

    So I've had a change in vision in what I want with it this. I was wondering if there was a way to pull data with dates into the Calendar Control 10 in access?

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

Similar Threads

  1. Replies: 12
    Last Post: 10-01-2018, 02:40 PM
  2. Replies: 3
    Last Post: 06-06-2018, 08:26 PM
  3. Replies: 2
    Last Post: 12-23-2015, 09:32 PM
  4. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  5. Replies: 1
    Last Post: 09-03-2014, 03:27 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