Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / ActiveX Controls / August 2003

Tip: Looking for answers? Try searching our database.

Calendar

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Myron Lindberg - 01 Aug 2003 16:35 GMT
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
Chaster - 01 Aug 2003 15:49 GMT
Try this.  I was unable to convert it to my program but I'm not very good at
this stuff.  I think it might be what your looking for.

http://www.lebans.com/monthcalendar.htm

Who knows if you get it to work you might be able to help me with where I'm
going wrong.

Chuck

> Hi Gang
>
[quoted text clipped - 7 lines]
> TIA
> Myron
Matt Williamson - 01 Aug 2003 17:42 GMT
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

> Try this.  I was unable to convert it to my program but I'm not very good at
> this stuff.  I think it might be what your looking for.
[quoted text clipped - 17 lines]
> > TIA
> > Myron
Stephen Lebans - 02 Aug 2003 01:51 GMT
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.

> Chuck-
>
[quoted text clipped - 76 lines]
> > > TIA
> > > Myron
Tony Toews - 01 Aug 2003 20:26 GMT
>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.

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
Myron Lindberg - 04 Aug 2003 15:42 GMT
Thanks much Tony

BR
Myron

> >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
[quoted text clipped - 28 lines]
>    Microsoft Access Links, Hints, Tips & Accounting Systems at
> http://www.granite.ab.ca/accsmstr.htm
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.