Calendar Schedule idea/Help

W

whybrow23

Registered User.
Local time
Today, 12:28
Joined
May 20, 2011
Messages
38

Hi Guys
Hopeing someone might be able to help.
I’m wanting to build a database for a Vessel Schedule.
So the idea would be a data entry form with something like the follow details:

Name of Survey
Person in Charge
Date From
Date To
Year
Type – (so if Survey is selected, the colour would be Yellow or if Maintenance is selected, the colour would be Green)
And then some other details bits

I would then like to be able to open another form(Year Schedule Plan) along the lines of the attached picture. I can then select the year (2015 or 2018)and it would then show the selected years calendar and show the data that been entered, again abit like the attached.
Hope I make sense J
Anyone know if something like this is possible?

Thank you:)
 

Attachments

  • Schedule.png
    Schedule.png
    46.8 KB · Views: 1,279
Anyone know if something like this is possible?
Click to expand...

Yes...

But its one of those things that if you have to ask, its probably not achievable. For one, you didn't call it by its actual name (it's called a Gantt chart - https://en.wikipedia.org/wiki/Gantt_chart), which is fine--only project managers and the developer nerds who have been assigned to them know that.

These things are way difficult to achieve. You do have the correct table structure in mind, but that's 10% of the battle. You have to loop through all the data and then iterate through every cell of the Gantt Chart determining the value and color to make everything. The ones I have done were in Excel and Asp.net for the web. I can't even imagine doing it all in Access.

My advice would be try and get a different format--something columnar:

January
- 2 -23, Test Data 1
- 27 - 31, Test Data 2
February
- 1 - 13, Test Data 2
- 18 - 23, Test Data 3
...
 
Thanks Plog

I'll have a read up on Gantt Charts, but I don't think it's what's in my head :-)
 
It's what's in your attachment.
 
That's taken for a excel spreadsheet, but I see what your saying
 
Anyone know if something like this is possible?
Click to expand...

Yes it is possible to do with native Access controls and VBA code.

II have something on my site that may be what you need:

Schedule Grid - DesGrid (Click Here)

The company that originally deployed this product no longer supports it. The product has since given it to public domain soley as an "as is" device. Their information has been stripped out of the attachments and manual. This tool is what it is and is considered "skilled" to "advanced" for level of developer skills to manipulate successfully.

Basically, you're on your own with this one. But it is an excellent portrayal of Access' capabilities.

The download includes both Access 97 and Access 2000 formats of these two files:

1) Orchid (the demo)

2) DesGrid (the un-altered components)

Each contains a Month-Grid and an Hour-Grid. Also included is a PDF of the Manual.
Click to expand...
 
Hi ..

I Have a DB ApptCalendar2003 , which I downloaded from this forum. I have changed that based on my usage. I can mail you If you need that..











whybrow23 said:

Hi Guys
Hopeing someone might be able to help.
I’m wanting to build a database for a Vessel Schedule.
So the idea would be a data entry form with something like the follow details:

Name of Survey
Person in Charge
Date From
Date To
Year
Type – (so if Survey is selected, the colour would be Yellow or if Maintenance is selected, the colour would be Green)
And then some other details bits

I would then like to be able to open another form(Year Schedule Plan) along the lines of the attached picture. I can then select the year (2015 or 2018)and it would then show the selected years calendar and show the data that been entered, again abit like the attached.
Hope I make sense J
Anyone know if something like this is possible?

Thank you:)
Click to expand...
 
Here is a zip that includes a database supporting Gantt chart type report.
I did not create it. It was on a forum that I was visiting. Th author was Peter Hibbs, who I do not know. I did not get his explicit permission to post this, but it was on a public forum.

Good luck.
 

Attachments

santhosh23 said:
Hi ..

I Have a DB ApptCalendar2003 , which I downloaded from this forum. I have changed that based on my usage. I can mail you If you need that..
Click to expand...


Santhosh, if you could that would be great, thanks
 
santhosh,

Can you identify the original post
I Have a DB ApptCalendar2003 , which I downloaded from this forum.
Click to expand...

As for difficulty with attaching a file, Have you tired zipping the database?
 
@jDraw @whybrow23

Here you go .. this is the download link of the file ..
http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=40844&d=1330038300

This is the original post I suppose

http://www.access-programmers.co.uk/forums/showthread.php?t=222211

@whybrow23

In this db , they have a recordset which gets the data of ApptStartTime field and Appt , then it displays this information in calendar. you can customize based on your requirements like how much field you want to get it displayed, either you enter the info in a form and write it to the table or you want the recordset should get information directly from a table ..I can post my codes if you need.



@jDraw ..thanks for the Idea.. I tried zipping but it throws this error.


[ERR_WINSOCK_UNEXPECTED_WRITTEN_BYTES| The webpage at http://www.access-programmers.co.uk/forums/newattachment.php?do=manageattach&p= might be temporarily down or it may have moved permanently to a new web address.]



jdraw said:
santhosh,

Can you identify the original post


As for difficulty with attaching a file, Have you tired zipping the database?
Click to expand...
 
You must log in or register to reply here.

Similar threads

klsblues
Solved Schedule grid
2 3
Replies
51
Views
4,244
MajP
MajP
MattBaldry
Conditional Formatting from a Table
Replies
6
Views
560
Gasman
Gasman
A
Order entry and tracking system
2 3
Replies
44
Views
1,221
Pat Hartman
P
MattBaldry
Activity Timing
2
Replies
22
Views
1,037
MattBaldry
MattBaldry
R
Can you out perform ChatGTP?
2 3
Replies
44
Views
1,166
CarlettoFed
C

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom