Popup calendars?

S

StargateFan

Is there a freeware plugin available for a good popup calendar? At
least, in Filemaker it's a plugin so assuming it's the same in Access?
I'd like to use one for all the date fields.

Thanks.
 
N

Nikos Yannacopoulos

It's easy to do it on your own in your app! Start by making a form,
called frmCalendar, with a Calendar ActiveX control on it, named
calendar1; in the calendar's click event, put the following code:

sep = InStr(1, OpenArgs, ";")
frm = Left(OpenArgs, sep-1)
ctl = Right(OpenArgs, Len(OpenArgs) - sep)
Forms(frm).Controls(ctl) = Me.calendar1

Now, wherever you are calling it from, call it like:

DoCmd.OpenForm frmCalendar,,,,,,Me.Name & ";" & Me.ActiveControl.Name
(if the code is in an event of the control to be populated)

or
DoCmd.OpenForm frmCalendar,,,,,,Me.Name & ";" & "ControlName"
(if the code is in an event of another control, like a command button)

This uses the OpenArgs argument of the OpenForm command to pass on the
name of the original form and the name of the control to be populated,
separated by a semicolon (;).

The code behind the calendar's click event uses that to identify the
form/control to return the selected date to. To do so, it identifies the
position of the separating semicolon in the string, so it can read the
name of the form and the control into frm and ctl respectively, and then
use them to reference the control on the form.

HTH,
Nikos
 
A

Allen Browne

There is an ActiveX calendar control available with Access, and Stephen
Lebans has a better one at:
www.lebans.com

However, there are reference issues associated with ActiveX controls
(especially versioning issues with the Microsoft ones), so we find it easier
just to use a simple little Access form that pops up and gets the date.
Download from:
Popup calendar. Sample database with an Access form that works as a
calendar
at:
http://allenbrowne.com/ser-51.html
 
S

StargateFan

Is there a freeware plugin available for a good popup calendar? At
least, in Filemaker it's a plugin so assuming it's the same in Access?
I'd like to use one for all the date fields.

Thanks.
Click to expand...

Thank you, everyone! I've dl a bunch of them and will look at them
now. :eek:D
 
S

StargateFan

Is there a freeware plugin available for a good popup calendar? At
least, in Filemaker it's a plugin so assuming it's the same in Access?
I'd like to use one for all the date fields.

Thanks.
Click to expand...

I feel like a bottle and I'm trying to stuff and pound info in through
the narrow neck! <lol>

I see that Access' calendar popups are no easier to incorporate into a
solution than in Filemaker <g>. Makes me feel a little better. I
never managed in FMP, either!

I'm no expert, just a power user. I liked all the calendars I dl but
could get none of them to work. I have now a better resource in the
public library, so if someone could recommend a good book that might
be available in a library that somehow covers adding a popup such as
any of these, I'd sure appreciate it. I mean to get beyond this stage
and to move on to doing more complicated things like this (well, it's
complicated to me <g>).

I've done enough work in Access to understand that the button must
have a label and that "on click" has to have something in the "event
procedure" it's just after that if something doesn't work, I'm lost at
sea on how to do all the modifications and to cover all the bases so
that things work. So either a reference manual that someone knows
covers adding a calendar popup or an example that _really_ spells
everything out for someone like a newbie who isn't a full-fledged
developer, just someone who tinkers, that would be grand.

In my current contract, they want me to track BFs, a specialized form
of correspondence tracking, yet gave me absolutely no procedure or
tools to do this with. To compound the high volume of correspondence,
half comes in hard copy and half comes electronically. A _nightmare_
to keep under control since if I miss something that was brought
forward on another due date and I miss that due date, I'd be
mincemeat! <g> My excel "database" is working well, but it's clunky
and becoming very unwieldly as correspondence gets sent all over the
place not just for corrections but around to different govt depts for
input and I must track wherever each package comes and goes and to
keep on top of due dates. So I really must get something finished in
Access.

Thanks guys, I would be nowhere without these ngs, so really
appreciate the help.
 
A

Arvin Meyer

All of them work. I have personally tested and used all the ones that I have
recommended. The easiest one, (because it requires no programming
whatsoever) is the form one I wrote:

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

All you need to do is to import the Calendar form and the standard module
into your database. Then in the property sheet for the event you want to
call it from, of any form's date field, just add:

=popcalendar()

I usually use the Double-click event, but you can use any of them that make
sense for you.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top