MS Access Calendar

[truthlover]

Wow, that's great!

The only question I have is, it seems since the only table left is tbl_SurveyWorkO rder, that the dates needed for the calendar are no longer being accessed. (The dates in tbl_CrewSchedul e are the dates needed for the calendar, hence the queries).

Can a query be used to populate the calendar?

Thanks!

I was able to create a certain effect utilizing [ProjectID], [ProjectSurveyor], and [DateCreated], with test data. I assumed that Name referred to the Project Surveyor, if not Who? Look at the Attachment.

[ADezii]

Wow, that's great!

The only question I have is, it seems since the only table left is tbl_SurveyWorkO rder, that the dates needed for the calendar are no longer being accessed. (The dates in tbl_CrewSchedul e are the dates needed for the calendar, hence the queries).

Can a query be used to populate the calendar?

Thanks!

Can a query be used to populate the calendar?

This really complicates matters, since the code is really not meant to function in this manner to begin with, let alone based on a Query.

1. What is the name of the [Date] Field in tblCrewSchedule that is the basis for the Calendar?
2. What is the name of the [Name] Field, and in what Table does it reside? I'm referring to the Name Field that will be displayed in the Calendar along with the Project ID.
3. What is the name of the [ProjectID] Field, and in what Table does it reside? I'm referring to the Project ID Field that will be displayed in the Calendar along with the Name.
4. E-Mail me the Query (in a *.mdb Database) which will consist of these 3 Fields along with the Tables that comprise it. Display any relevant joins in this Query.
5. I'll attempt to work this Query into the Calendar in the same fashion, but I can't promise anything.
6. I'm assuming that you still have my E-Mail Address.

[truthlover]

Right now, the query I wanted the calendar to relate to is based on another query. I did that query on the fly (not realizing the problem it could cause for the calendar) and I'm thinking there has to be a better way to write the query.

So before I send you the file etc, let me go in and see if i can clean up and restructure a few things. (yes, I still have your email address, thanks)

This really complicates matters, since the code is really not meant to function in this manner to begin with, let alone based on a Query.

1. What is the name of the [Date] Field in tblCrewSchedule that is the basis for the Calendar?
2. What is the name of the [Name] Field, and in what Table does it reside? I'm referring to the Name Field that will be displayed in the Calendar along with the Project ID.
3. What is the name of the [ProjectID] Field, and in what Table does it reside? I'm referring to the Project ID Field that will be displayed in the Calendar along with the Name.
4. E-Mail me the Query (in a *.mdb Database) which will consist of these 3 Fields along with the Tables that comprise it. Display any relevant joins in this Query.
5. I'll attempt to work this Query into the Calendar in the same fashion, but I can't promise anything.
6. I'm assuming that you still have my E-Mail Address.

[truthlover]

Ok, I restructured the query based on the underlying tables. You should have received the file I sent.

Thanks!

Right now, the query I wanted the calendar to relate to is based on another query. I did that query on the fly (not realizing the problem it could cause for the calendar) and I'm thinking there has to be a better way to write the query.

So before I send you the file etc, let me go in and see if i can clean up and restructure a few things. (yes, I still have your email address, thanks)

[ADezii]

Ok, I restructured the query based on the underlying tables. You should have received the file I sent.

Thanks!

I'll check later this afternoon for the File, and hopefully look at it over the next few days to see what I can do. I'll be keeping in touch.

[truthlover]

Thanks, ADezii.

I think in the mean time, I'm going to show them your original calendar and see if they want to use it until we can tie it into the database.

If you have any questions, let me know.

I'll check later this afternoon for the File, and hopefully look at it over the next few days to see what I can do. I'll be keeping in touch.

[ADezii]

I do believe that I got the Calendar to derive its data from your Query Structure. The Calendar cannot work with Parameterized Queries, so I made an exact copy of qryCrewList and named it qryCrewList_2, without the Parameter Prompt. The Calendar draws its data from this Query. Do not Modify, Rename, Delete, etc, this Query since the code will crash. I strongly suggest that you do not modify any code at all in the Calendar Form unless it is done on a copy. Good luck and let me know how you make out.

NOTE: Please download the Attachment which contains the revised code.

[truthlover]

It's fantastic!! I imported it into the database and everything is working perfectly.

And while I dont yet know much about VBA, I can tell by the code it's what my husband would call "elegantly written".

I have one question... is there a way to get the name and project number to appear on the same line in the calander?

If not, or if it would be difficult, dont worry. But if it's a simple thing to do, it would just help not to mix up the person with the project number.

Thank you soooo much!!!

I do believe that I got the Calendar to derive its data from your Query Structure. The Calendar cannot work with Parameterized Queries, so I made an exact copy of qryCrewList and named it qryCrewList_2, without the Parameter Prompt. The Calendar draws its data from this Query. Do not Modify, Rename, Delete, etc, this Query since the code will crash. I strongly suggest that you do not modify any code at all in the Calendar Form unless it is done on a copy. Good luck and let me know how you make out.

NOTE: Please download the Attachment which contains the revised code.

[ADezii]

It's fantastic!! I imported it into the database and everything is working perfectly.

And while I dont yet know much about VBA, I can tell by the code it's what my husband would call "elegantly written".

I have one question... is there a way to get the name and project number to appear on the same line in the calander?

If not, or if it would be difficult, dont worry. But if it's a simple thing to do, it would just help not to mix up the person with the project number.

Thank you soooo much!!!

I have one question... is there a way to get the name and project number to appear on the same line in the calander?

Yes there is, just download the Attachment to see it. (Truthlover_Cal endar_3.zip).

[truthlover]

Perfect!

You know, I hadnt told anyone I had uploaded the calendar before I went to lunch, but when I got back everyone must have discovered it and were all thrilled.

ADezii, I dont know how to thank you for all your help and infinte patience.

Have a fantastic day!

Yes there is, just download the Attachment to see it. (Truthlover_Cal endar_3.zip).

[nspader]

Do you think there is anyway you could post a sanitised version of your db up for me to look at. I am trying to do something similar but different. I am having a hard time getting started with it. I think that this could be a really good place to start and work my way forward on what I need it to do. I would greatly appreciate it.

Nick

[truthlover]

If you're wanting to see the calendar application, just download the last file ADezii posted. That has the calendar as well as the tables/query it relates to.

If you want to see the whole db, I should warn you, though it started out clean and well-ordered, as more functions and applications were requested, the construction of the db ended up messy. And because I've had help with some of the coding (I dont know VBA) I've not been able to clean it up for fear of the whole thing falling apart.

Ok, so now you've been warned. If you still want to see it, send me a PM with your email address and I'll send it along.

Have a wonderful day!

Do you think there is anyway you could post a sanitised version of your db up for me to look at. I am trying to do something similar but different. I am having a hard time getting started with it. I think that this could be a really good place to start and work my way forward on what I need it to do. I would greatly appreciate it.

Nick

[JOrsak]

Yes there is, just download the Attachment to see it. (Truthlover_Cal endar_3.zip).

Hey, this is a really cool little calendar.

What are the chances of getting some help with further development? I need to be able to click on the day and schedule a specific time slot. 10 Minute increments would be perfect. I'd also like to be able to pull from an employee list to assign that specific time slot to an employee for appointments.

Would that be possible?

[ADezii]

Hey, this is a really cool little calendar.

What are the chances of getting some help with further development? I need to be able to click on the day and schedule a specific time slot. 10 Minute increments would be perfect. I'd also like to be able to pull from an employee list to assign that specific time slot to an employee for appointments.

Would that be possible?

Would that be possible?

I imagine it would be, instead of opening a Form based on a Table of Events for a specific Day, you would open a Form based on a Table of Appointments for that Date. The underlying Table would consist of Fields such as: [Activity], [Last Name], [First Name] (both derived from a Table of Employees), [Appt Date], and [Time]. You would need a Composite Primary Key based on the [Appt Date] and [Appt Time] Fields so that no 2 10-Minute Time Intervals could be utilized for the same Date. The [Appt Time] Field would consist of a Combo Box of Times based on 10 minute Intervals within a certain Range (8:00 A.M. to 5:00 P.M.). If you are 'really' interested in the concept, and are 'not' in any rush, let me know.

[typhoo]

I was able to create a certain effect utilizing [ProjectID], [ProjectSurveyor], and [DateCreated], with test data. I assumed that Name referred to the Project Surveyor, if not Who? Look at the Attachment.

ADezii
I love this calendar it is exactly what i am looking for, although, i need it to show projects my team are working on and show the events on the calendar from the start date to end date, so i can look at the calendar at a glance and see who is busy and when. does that make sense? hope you can help? thanks