Using a DTPicker or Calendar Control 11.0

[Sue]

Hi, gang.

I'm struggling with getting a calendar to work in my forms. I have a main
form that has a textbox which populates a date field in my table when the
user enters a date. I also have 2 different calendar buttons on the main
form -- 1 is for a DTPicker calendar and one is for a Calendar Control 11.0
calendar. Neither of them are working. I found some info on the internet
about the DTPicker that says it is almost impossible to use them on machines
that don't have Visual Studio and I don't. For both buttons, I can click on
them and they open the corresponding calendar. I can select a date but
neither of them are storing that date in the field. Any suggestions?

 

[Mr B]

Here are some links that have been posted previously:

Popup Calendar (Allen Browne's site)
http://allenbrowne.com/ser-51.html

Month Calendar (Stephen Leban's site)
http://www.lebans.com/monthcalendar.htm

Calendar Sample database (John Viescas' site)
http://www.viescas.com/Info/links.htm#Downloads

Also a search in this newsgroup will product several other postings related
to this.

--
HTH

Mr B
email if needed to:
draccess at askdoctoraccess dot com

 

[James A. Fortune]

draccess at askdoctoraccess dot com

I note that askdoctoraccess.com has some stylistic similarities to
aislebyaisle.com. Interesting.

From:

http://askdoctoraccess.com/Pricing.htm

"We are very proud of the fact that the rates for the services of Doctor
Access are very competitive."

It may be a coincidence but I just couldn't help LOL!

James A. Fortune
(e-mail address removed)

 

[Sue]

The calendar.zip download link on
http://www.viescas.com/Info/links.htm#Downloads is a dead end on my computer.
I get "The Page Cannot Be Displayed".

I'm still plugging away on this calendar thing. I have the feeling this
will be a long, hard process to complete. I need to get a book on
programming in VB!

 

[Douglas J. Steele]

The link to John's site worked fine for me just now.

 

[Arvin Meyer [MVP]]

Here's another calendar that is an Access form and has worked in every
version from 2.0 through 12:

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

 

[Sue]

Hi, Arvin. Thanks for the link. I tried the calendar function in this
database and it doesn't populate the field it's accessed in. Does it work
for you?

Doug, I tried the calendar.zip download link on
http://www.viescas.com/Info/links.htm#Downloads again but it still doesn't
work for me. I still get "The Page Cannot Be Displayed".

I'm starting to get a "nonfunction" complex.

Someone found a website for me for downloading DTPicker:
http://www.softpedia.com/get/Programming/Other-Programming-Files/DTPicker.shtml#. Anyone ever use this? I'll have to give it a shot.

He also asked the IT people at his work to help him implement the DTPicker
in a database for him and it works on his computer and on my home computer
but not my work computer. On the Properties window for this drop-down
ActiveX Control list, it lists the OLE Class as DTPicker and the Class as
MSComCtl2.DtPicker.2. The ActiveX calendar controls listed in my Insert >
ActiveX Control menu are CoyoteCalendar2.Calendar, Calendar Control 11.0,
oscCalendar.DatePicker, and oscCalendar.MonthCalendar. So maybe the DTPicker
doesn't work on my work computer because it's not one of the choices in my
Insert > Active X Control menu.

I have tried the MSCAL calendar (OLE Class: Calendar, Class:
MSCAL.Calendar.7) from
http://mc-computing.com/Databases/MSAccess/Calendar_Example.html. On my main
form I have a command button that opens a form with this calendar. You can
click on the dates but they don't populate the field associated with the
command button.

--
Sue
Programmer/Data Analyst
Minnesota

 

[Douglas J. Steele]

Don't know what to tell you, other than I successfully download the example
just now.

 

[Arvin Meyer [MVP]]

Sue, all you need to do is import the standard module and the calendar form
into your database. In your date field textbox, use the double-click event
and add:

=popCalendar()

to the property sheet, just like in the sample. It works 100% of the time in
every version of Access including Access 2007.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Hi, Arvin. Thanks for the link. I tried the calendar function in this
database and it doesn't populate the field it's accessed in. Does it work
for you?

Doug, I tried the calendar.zip download link on
http://www.viescas.com/Info/links.htm#Downloads again but it still doesn't
work for me. I still get "The Page Cannot Be Displayed".

I'm starting to get a "nonfunction" complex.

Someone found a website for me for downloading DTPicker:
http://www.softpedia.com/get/Programming/Other-Programming-Files/DTPicker.shtml#.
Anyone ever use this? I'll have to give it a shot.

He also asked the IT people at his work to help him implement the DTPicker
in a database for him and it works on his computer and on my home computer
but not my work computer. On the Properties window for this drop-down
ActiveX Control list, it lists the OLE Class as DTPicker and the Class as
MSComCtl2.DtPicker.2. The ActiveX calendar controls listed in my Insert >
ActiveX Control menu are CoyoteCalendar2.Calendar, Calendar Control 11.0,
oscCalendar.DatePicker, and oscCalendar.MonthCalendar. So maybe the
DTPicker
doesn't work on my work computer because it's not one of the choices in my
Insert > Active X Control menu.

I have tried the MSCAL calendar (OLE Class: Calendar, Class:
MSCAL.Calendar.7) from
http://mc-computing.com/Databases/MSAccess/Calendar_Example.html. On my
main
form I have a command button that opens a form with this calendar. You
can
click on the dates but they don't populate the field associated with the
command button.

--
Sue
Programmer/Data Analyst
Minnesota

 

[Sue]

Arvin,

Right now I've got an ActiveX Control calendar in my form called
CoyoteCalendar2.Calendar that I found in my Insert > ActiveX Control menu and
it's working but if I find that it's computer-dependent, I will pursue the
one on http://www.datastrat.com/Download/Calendar2K.zip. I've spent way too
much time working on it already. A big thank you to all who held my hand
through this!
--
Sue
Programmer/Data Analyst
Minnesota

 

[Arvin Meyer [MVP]]

All activeX controls are computer dependent. They need to be installed and
registered. That's one of the advantages of using a form based calendar. It
lives with the database and doesn't require any outside dependencies.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Sue]

So what's the difference between a form based calendar and an ActiveX
Control? Where do you find form based calendars? I thought the
CoyoteCalendar2.Calendar was a form calendar since it was available for use
in my Insert > ActiveX Control menu.

I found a website that describes how to install the CoyoteCalendar2.Calendar
ActiveX Control on the user's computer so it's functional. It says to go to
http://spazioinwind.libero.it/vbprogzone/acx_misc.html and downloaded the
coyote calendar. It comes with a setup exe which is supposed to be helpful
when installing onto a user machine. The name of the .ocx is csccal2.ocx and
the name of the .dll is cscdll.dll and they come with a help file which is
helpful too. But I'm not sure what I would need to do with a ocx and dll. I
might just test it on a different computer to see if I can install it.

Thanks for your insight, Arvin!
--
Sue
Programmer/Data Analyst
Minnesota

 

[James A. Fortune]

I note that askdoctoraccess.com has some stylistic similarities to
aislebyaisle.com. Interesting.

From:

http://askdoctoraccess.com/Pricing.htm

"We are very proud of the fact that the rates for the services of Doctor
Access are very competitive."

It may be a coincidence but I just couldn't help LOL!

James A. Fortune
(e-mail address removed)

Mr. B emailed me:

"Hello, James.

This is Mr B (Doctor Access) :>) .
I am very curious about your observations relative to my web site,
askdoctoraccess.com.
First, I was totally unaware of the other web site that you referenced.
I just do not understand where you are comming from. I am not a
professional web designed, I am an Access Developer. Although I did
create and design my web site I in no way intended to imulate or
replicate any other web site.
I do not know why you quoted a line from my Pricing page, and felt that
somewhere there "may be a coincidence". Could you please explain what
you are refering to. I really would like for my web site to be
professional in nature. If there is something here that I need to
correct, I would like to know what it is.

Mr. B"


There was a poster who posted in the Access newsgroups in a way that
violated the charter of at least one of the newsgroups for the way they
solicited business. They used a very similar slogan directly in their
posts when trying to attract new business. Other telltales of that
poster include frequent misspellings and grammatical errors. Some
posters have mentioned tracing at least one post from this person to
Texas, where your site happens to be registered. My most recent theory
is that this person's initials are T.B. Naturally, the name Mr. B made
me suspicious right away but I simply noted the similarities in basic
posting style until one of your posts contained a reference to your
site. The similarity of your site to aislebyaisle.com, which according
to my most recent theory is/was run by T.B., was surprising. Note that
aislebyaisle.com contains code for subjects that "T.B." asked specific
questions about, such as recipes that produce grocery lists. I did not
mean to imply that you copied that site, merely that there are enough
similarities to suggest that they may have been created by the same
person. T.B. lived and worked in Canada for many years. I think it is
entirely possible that he posted "by proxy" from places like Texas and
Pennsylvania, but I do not know that for certain. BTW, aislebyaisle.com
was registered with one of the buried contact addresses in Malibu, CA.
Malibu happened to be the name of one of the mainframes at a university
during the time that T.B. worked there. This is all speculation, but I
hope this helps you to create a more professional website by noting that
the line from your Pricing Page has fallen out of favor with many people.

Wait! There's more. Coyote Software, which is mentioned on the
calendar control mentioned by "Sue" at the Italian site cited is based
in the same city as the university in Canada where T.B. worked! It's
not fair batting against your own pitcher. When will all these
advertising games stop?

James A. Fortune
(e-mail address removed)

 

[Arvin Meyer [MVP]]

A form based calendar is an Access form, using Access controls (in this case
text boxes) and code. It only uses Access objects. You won't insert the form
anywhere. It is an Access form which you will open with code (actually just
calling the function in the property sheet's double-click event). I built
that form using Access Basic in 1994 in Access 2.0. It has been working in
every version, including Access 2007, ever since.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Nathan Lars]

I'm replying to an old post, but I am wondering if you could help me? I have
a very basic understanding of Access and am not able to get the imported
calendar form and module to work in my existing database. After doing this
I opened the property sheet from the date field I created and copied

=popCalendar()

in the double-clidk event as you directed. when I selected another field in
the property sheet it displayed this message:

"There was an error when compiling this function.
The visual basic module contains a syntax error.
Check the code and then recompile it."

What am I missing?

Your help would be very much appreciated.