Inserting a Date Picker and a Calculated Field (1 Viewer)

HangoutGuy · Aug 6, 2019

Good day,

I am in charge of creating a company-wide resource database which keeps track of employees, their projects, when projects are due and so on and so forth.

I would like to know if it is possible, and how to, add a date picker that would let me know that time left on a given project.

Lets say in the date picker I choose 8-12-2019. I would like for a list of projects to pop up with how many weeks are left. Lets say I have 50 projects in total, I want to know for all 50 how many weeks are left from a date picked by me.

I know how to do this in a query with the criteria data field, but my boss would like to have a simple date picker that would ultimately pop up and show the projects and the weeks left for each project.

Thanks!

theDBguy · Aug 6, 2019

Hi. Welcome to the forum! I am not sure I am following what you're trying to do. Are you saying you want to display a calendar and show in each date how many projects are left?

arnelgp · Aug 6, 2019

you use this formula to as how many weeks remain.

DateDiff("ww", datePickerDate,[projectTargetDate])

HangoutGuy · Aug 6, 2019

Hi sorry for the poor articulation.

I would essentially like a drop down menu/calendar that I can click on a particular month and day and I would be shown the weeks left in all the projects.

For instance, If I were to choose 8/6/2019 from the calendar, the weeks left and name of project would be displayed.

If Project 1 had an end date of 8/13/2019 and Project 2 an end date of 8/20/2019, I would like a display that shows:

Project 1 -- 1 week
Project 2 -- 2 week

theDBguy · Aug 6, 2019

HangoutGuy said:
Hi sorry for the poor articulation.

I would essentially like a drop down menu/calendar that I can click on a particular month and day and I would be shown the weeks left in all the projects.

For instance, If I were to choose 8/6/2019 from the calendar, the weeks left and name of project would be displayed.

If Project 1 had an end date of 8/13/2019 and Project 2 an end date of 8/20/2019, I would like a display that shows:

Project 1 -- 1 week
Project 2 -- 2 week

Hi. Thanks for the clarification. Yes, you should be able to use a query for that. Try using Arnel's suggestion and let us know how it goes.

HangoutGuy · Aug 6, 2019

theDBguy said:
Hi. Thanks for the clarification. Yes, you should be able to use a query for that. Try using Arnel's suggestion and let us know how it goes.

Hi. Yes I know about that formula and I have the query set up to do what I would like. What I want to know, though, is if I can for instance put a calendar UI of some sort onto a form that I can just click a date, have it run the query with that formula, and display the information.

theDBguy · Aug 6, 2019

HangoutGuy said:
Hi. Yes I know about that formula and I have the query set up to do what I would like. What I want to know, though, is if I can for instance put a calendar UI of some sort onto a form that I can just click a date, have it run the query with that formula, and display the information.

Ah, I see. Okay, take a look at some of the calendar demos available. You should be able to modify it to do what you want. But as I was saying earlier, which is what I thought you were asking, it wouldn't be too hard to simply display all that information on the calendar itself, so you won't really have to click and open anything because it's all displayed already. Try searching for an example of an appointment or events calendar.

HangoutGuy · Aug 6, 2019

theDBguy said:
Ah, I see. Okay, take a look at some of the calendar demos available. You should be able to modify it to do what you want. But as I was saying earlier, which is what I thought you were asking, it wouldn't be too hard to simply display all that information on the calendar itself, so you won't really have to click and open anything because it's all displayed already. Try searching for an example of an appointment or events calendar.

Do you have any recommendations or tutorials to look up? I've been struggling to find free tutorials/templates in regards to events planning.

theDBguy · Aug 6, 2019

HangoutGuy said:
Do you have any recommendations or tutorials to look up? I've been struggling to find free tutorials/templates in regards to events planning.

Have a look in here and let us know if you don't find anything useful.

arnelgp · Aug 6, 2019

isladog has a professional looking calendar. search here "a better datepicker".

isladogs · Aug 6, 2019

This is what arnelgp referred to: A Better Date Picker

theDBguy · Aug 6, 2019

theDBguy said:
Have a look in here and let us know if you don't find anything useful.

Here's an image of an appointment calendar I found here. You should be able to modify it to show remaining weeks per project instead of appointment times. Hope it helps...

Pat Hartman · Aug 6, 2019

Access has a built in calendar. If all you want is a date picker, I would use that. To use it on an UNBOUND control, you must set the format of the control to a date data type. Then choose the option to show date picker for dates on the control's property sheet - I think this option is on the format tab but I don't have Access open so I may be hallucinating.

isladogs · Aug 6, 2019

The built in date picker control works but has limitations. For example you cannot select a month or year other than by moving back/forward one month at a time. Fine if you need a month close to today's date. Not so if you want e.g. Jan 2010

The many alternative date pickers such as mine have been created to overcome such issues and/or to offer additional functionality

Pat Hartman · Aug 6, 2019

Colin,
Maybe you could make a deal with MS since yours is clearly superior

I only suggested the built in function because it "works" and doesn't require any code and might be all the poster needs.

isladogs · Aug 6, 2019

Hi Pat
That made me laugh. There are lots of better date pickers/calendars out there which need minimal code. In my case, it needs one line.
However I also use the built-in date picker when it will do the job perfectly well.

Inserting a Date Picker and a Calculated Field (1 Viewer)

HangoutGuy

Registered User.

theDBguy

I’m here to help

arnelgp

..forever waiting... waiting for jellybean!

HangoutGuy

Registered User.

theDBguy

I’m here to help

HangoutGuy

Registered User.

theDBguy

I’m here to help

HangoutGuy

Registered User.

theDBguy

I’m here to help

arnelgp

..forever waiting... waiting for jellybean!

isladogs

MVP / VIP

theDBguy

I’m here to help

Attachments

Pat Hartman

Super Moderator

isladogs

MVP / VIP

Pat Hartman

Super Moderator

isladogs

MVP / VIP

Similar threads

Users who are viewing this thread