Fill in calendar form and report

[ChrisK]

I am trying to design a form and report that would look at 2 fields in a
table, inspdate and jobnumber. I would like to insert a job number, in a
standard calendar, in the date that equals "inspdate" in the table. Is this
possible in access or do I need to do this in another program?

 

[Arvin Meyer MVP]

Sure. You can get a popup calendar to do the calendar part at:

http://www.datastrat.com/Download/Calendar2K.zip

 

[ChrisK]

Arvin

Thanks for the reply, but that is not the type of calendar I need. I need a
calendar that has boxes for the dates. I those boxes I want to display the
jobnumber whose inspdate = the calendar date. I need to put up to 6 job
numbers in each calendar box. Any ideas?

Thanks
Chris

 

[Peter Hibbs]

A Flex Grid Control will probably do what you want but you will need
to write a bit of VBA code, have a look at my Flex Grid Demo program
for some examples, one of which does exactly what you are describing.

Go to http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

HTH

Peter Hibbs.

 

[ChrisK]

Thanks Peter
It looks great. I am about to get a new system, will it run okay in 2007?

Chris

 

[Arvin Meyer MVP]

Arvin

Thanks for the reply, but that is not the type of calendar I need. I need
a
calendar that has boxes for the dates. I those boxes I want to display the
jobnumber whose inspdate = the calendar date. I need to put up to 6 job
numbers in each calendar box. Any ideas?

I believe that both Duane Hookom and AD Tejpal may have code that would help
you:

http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=4

http://www.rogersaccesslibrary.com/forum/forum_topics.asp?FID=45

 

[Peter Hibbs]

Chris,

Yes, the flex grid control works with Access 2007 with no problems.

Peter Hibbs.

 

[Danny J. Lesandrini]

I've got a crude little form that does what I think you want. It's out
at my FTP site. It will need a lot of tweaking to do what you want,
but it's basically debugged for month navigation ...

http://www.amazecreations.com/datafast/calendar.zip
I'd love some feedback on this little form, if anyone wants to give
it a spin and get back to me. Open the database and launch the
form named frmCalendar. It loads a subform named sfrmCalendar
and resizes all the boxes, loading the data based on a query.