Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-03-2019, 02:14 PM   #1
jeannier1975
Newly Registered User
 
Join Date: May 2018
Posts: 30
Thanks: 1
Thanked 0 Times in 0 Posts
jeannier1975 is on a distinguished road
calandar

i need to be able to create a calendar in a form like the one in the picture i have no idea how i can do this i want to have the user put in a a letter for each result of the area being test on the calendar.
https://www.dropbox.com/s/z3m37lfjls...andar.png?dl=0
Attached Images
File Type: png calandar.png (40.0 KB, 24 views)

jeannier1975 is offline   Reply With Quote
Old 12-03-2019, 02:22 PM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,238
Thanks: 63
Thanked 1,678 Times in 1,633 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: calandar

Hi. Sounds like you're trying to create a Gantt Chart more than a calendar.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 12-03-2019, 02:55 PM   #3
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 1,495
Thanks: 12
Thanked 290 Times in 273 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: calandar

Hmm, I don't draw that conclusion. Then again, if you're not a member there, you aren't allowed to look at anything - not even posted images. I'm just basing my opinion on what little I know about Gantt charts.

I have used a calendar as an input form for values, but it can only display one month per page and doesn't have a column or field for a list of names. Maybe somebody will read this who has built exactly what's wanted.

__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is online now   Reply With Quote
Old 12-03-2019, 02:56 PM   #4
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 2,112
Thanks: 20
Thanked 405 Times in 396 Posts
Mark_ will become famous soon enough Mark_ will become famous soon enough
Re: calandar

Does this only show one month at a time? What should appear for each employee/date intersection? What data will drive this?
Mark_ is offline   Reply With Quote
Old 12-03-2019, 02:59 PM   #5
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,238
Thanks: 63
Thanked 1,678 Times in 1,633 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: calandar

Quote:
Originally Posted by Micron View Post
Then again, if you're not a member there, you aren't allowed to look at anything - not even posted images.
Hi Micron. I had no idea. Here's what that demo is supposed to look like.


__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 12-03-2019, 03:00 PM   #6
Micron
AWF VIP
 
Join Date: Oct 2018
Location: Ontario, Canada
Posts: 1,495
Thanks: 12
Thanked 290 Times in 273 Posts
Micron has a spectacular aura about Micron has a spectacular aura about
Re: calandar

Quote:
Originally Posted by theDBguy View Post
Hi Micron. I had no idea. Here's what that demo is supposed to look like.
The attachment didn't get into your post...
__________________
Sometimes I just roll my eyes out loud...
Windows 10; Office 365 (Access 2016)
Micron is online now   Reply With Quote
Old 12-03-2019, 03:02 PM   #7
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,238
Thanks: 63
Thanked 1,678 Times in 1,633 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: calandar

Quote:
Originally Posted by Micron View Post
The attachment didn't get into your post...
Hi. Sorry for the confusion, I didn't post an attachment, just showing an image of it. Let me see if I can find out about the issue with non-members.

__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 12-03-2019, 03:22 PM   #8
jeannier1975
Newly Registered User
 
Join Date: May 2018
Posts: 30
Thanks: 1
Thanked 0 Times in 0 Posts
jeannier1975 is on a distinguished road
Re: calandar

this is what im looking for but need it for all the months not just one month
jeannier1975 is offline   Reply With Quote
Old 12-03-2019, 03:23 PM   #9
jeannier1975
Newly Registered User
 
Join Date: May 2018
Posts: 30
Thanks: 1
Thanked 0 Times in 0 Posts
jeannier1975 is on a distinguished road
Re: calandar

Quote:
Originally Posted by Mark_ View Post
Does this only show one month at a time? What should appear for each employee/date intersection? What data will drive this?
needs several months a whole year i was going to use a drop box to select the month and the year
jeannier1975 is offline   Reply With Quote
Old 12-03-2019, 03:41 PM   #10
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 2,112
Thanks: 20
Thanked 405 Times in 396 Posts
Mark_ will become famous soon enough Mark_ will become famous soon enough
Re: calandar

jeannier1975
One month at a time? And will this be in a REPORT or a FORM?
Mark_ is offline   Reply With Quote
Old 12-03-2019, 03:49 PM   #11
jeannier1975
Newly Registered User
 
Join Date: May 2018
Posts: 30
Thanks: 1
Thanked 0 Times in 0 Posts
jeannier1975 is on a distinguished road
Re: calandar

Quote:
Originally Posted by Mark_ View Post
jeannier1975
One month at a time? And will this be in a REPORT or a FORM?
it will be Report
jeannier1975 is offline   Reply With Quote
Old 12-03-2019, 03:56 PM   #12
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 2,112
Thanks: 20
Thanked 405 Times in 396 Posts
Mark_ will become famous soon enough Mark_ will become famous soon enough
Re: calandar

What should appear for each employee/date intersection?
Mark_ is offline   Reply With Quote
Old 12-04-2019, 02:03 PM   #13
jeannier1975
Newly Registered User
 
Join Date: May 2018
Posts: 30
Thanks: 1
Thanked 0 Times in 0 Posts
jeannier1975 is on a distinguished road
Re: calandar

not sure what you are referencing
jeannier1975 is offline   Reply With Quote
Old 12-04-2019, 02:13 PM   #14
Mark_
Longboard on the internet
 
Join Date: Sep 2017
Location: Not the middle of no where, but I can see the road to it from my house.
Posts: 2,112
Thanks: 20
Thanked 405 Times in 396 Posts
Mark_ will become famous soon enough Mark_ will become famous soon enough
Re: calandar

Quote:
Originally Posted by jeannier1975 View Post
not sure what you are referencing
On the left, you have "Assigned to" above a list of names. Going to the right are dates. Where each name/date intersects (Fred Fredders/1-Jan) what should be displayed? Or is this ONLY to make a calendar that will be filled by hand after being printed?
Mark_ is offline   Reply With Quote
Old 12-04-2019, 02:15 PM   #15
jeannier1975
Newly Registered User
 
Join Date: May 2018
Posts: 30
Thanks: 1
Thanked 0 Times in 0 Posts
jeannier1975 is on a distinguished road
Re: calandar

its a chart to be filled by the user complete or uncomplete

jeannier1975 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calandar Controls / Subforms jasonp21 Forms 2 01-13-2012 07:50 AM
QDF / Calandar problem LB79 Modules & VBA 3 04-14-2010 01:55 AM
Calandar control date() help maxxximaniac Forms 4 12-28-2005 04:36 PM
Select Only Month/Year with Calandar Control Frenstall Forms 1 10-20-2005 05:14 PM
lookfor calandar 24sharon General 1 02-03-2005 02:06 AM




All times are GMT -8. The time now is 06:01 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World