Calendar

  • Thread starter Thread starter Chaster
  • Start date Start date
Hi Gang

I am in need of a calendar. There may be some easy way to allow the
users to view a calendar when they are using a portion of the .mdb I
have created which deals with scheduling. What I am looking for is a
'function' call (something I can attach to a button) which will display
a calendar similar to the ms-windows Date/Time calendar. Any assistance
would be much appreciated.

TIA
Myron
 
Chuck-

What are you having trouble with? Did you create the clsMonthCal,
modCalendar, and modAddrOf modules in your project and copy the code into
them? You don't need the others, just those 3. There might be a better way
to get the modules into the project, but with access97, I couldn't find a
way.

I created a new project copied the modules in and added the necessary bits
of code and it works fine. Try it. I stripped it down to it's rawest form.
Once you understand that part, you can get the other bits to format it how
you want and everything.

'Get the 3 modules into the new file first.. however you can

Add a command button and a textbox

open the form code window and copy this in

--- code start --

Option Compare Database
Option Explicit
Private mc As clsMonthCal


Private Sub Command0_Click()

txtDate = ShowMonthCalendar(mc, Date, , , , True)

End Sub

Private Sub Form_Load()

Set mc = New clsMonthCal

End Sub

Private Sub Form_Unload(Cancel As Integer)
' This is required in case user Closes Form with the
' Calendar still open. It also handles when the
' user closes the application with the Calendar
' still open.
If Not mc Is Nothing Then
If mc.IsCalendar Then
Cancel = 1
Exit Sub
End If
Set mc = Nothing
End If
End Sub

-- End Code --

HTH

Matt
 
Myron Lindberg said:
I am in need of a calendar. There may be some easy way to allow the
users to view a calendar when they are using a portion of the .mdb I
have created which deals with scheduling. What I am looking for is a
'function' call (something I can attach to a button) which will display
a calendar similar to the ms-windows Date/Time calendar. Any assistance
would be much appreciated.
Click to expand...

See the Calendar Tips page at my website.

There could, likely will, be lots of version problems when you go to
distribute the MSCal.OCX..

Some alternatives are:
MonthCalendar is a completely API generated Month Calendar derived
directly from the Common Control DLL.
There are several downloadable calendar forms at the Links page
at my website. As these are forms you can also do anything with them
you want.

You can also use the calendar form which comes in the Access <insert
your version here> Developers Handbook by Litwin/Getz/Gilbert,
publisher Sybex www.developershandbook.com. These books are well
worth spending money. Every time I open one I save the price of the
book.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Matt it is easier to simply import any desired modules, tables, queries
etc..
From the Main database window right click over any blank area.
Select Import
Browse to the MDB containing the objects you wish to import
Select the desired objects
All done

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Thanks much Tony

BR
Myron

Tony said:
See the Calendar Tips page at my website.

There could, likely will, be lots of version problems when you go to
distribute the MSCal.OCX..

Some alternatives are:
MonthCalendar is a completely API generated Month Calendar derived
directly from the Common Control DLL.
There are several downloadable calendar forms at the Links page
at my website. As these are forms you can also do anything with them
you want.

You can also use the calendar form which comes in the Access <insert
your version here> Developers Handbook by Litwin/Getz/Gilbert,
publisher Sybex www.developershandbook.com. These books are well
worth spending money. Every time I open one I save the price of the
book.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Click to expand...
 
Back
Top