Yearly Calendar

[Floyd Forbes]

Is there a way to create a yearly calendar in Microsoft Access? I'm trying
to create a yearly calendar that would show text from a table. If I have a
table with Two fields one name code and the other name date.
How do I show the code by date in my yearly calendar.

Floyd

 

[Peter Hibbs]

Floyd

You could use a Flex Grid control to display a calendar linked to a
table. Have a look at my Flex Grid Demo program at -

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S

for some examples. Incidentally, don't use field names of Code and
Date in your table, I believe these are Access reserved words and will
cause you headaches later on.

Peter Hibbs.

 

[Guest]

Floyd,

Sorry to butt in; this is for Peter.

Peter - great demo and write-up. This could be what I need - I was
considering pushing data out to Excel and then retrieving it. However when I
try to add the flex grid control in design view I get a message about no
licence. What to do?

Rod

 

[Peter Hibbs]

Hi Rod,

I suppose you will need to buy it to get the license but I'm not sure
where from or how much it costs. My version was installed
automatically with Visual Basic 6 several years ago, if you can find a
copy of VB6 this may be the cheapest option. Try a search on the
Internet to see what you can find.

This subject has actually come up before on this Newsgroup and a user
said that they just imported one of my forms into their project and
they could use the control as normal. I tried this but it gave me
problems but it may be worth a try.

Sorry I can't be more help. Let us know if you find any other
solution, however, as it may be useful for others.

Peter Hibbs.