Re: [MS_AccessPros] Crystal's New Date Picker

 

Thanks Crystal; I've downloaded it from Roger's Access Library and
compiled it and this time, when I double-click the DateandTime1 text box
on the f_PopupCalendar_Test form, I get a box titled "Error 438
Set_Calendar" which reads "Object doesn't support this property or
method" but if I select OK on said box then the calendar opens up and if
I select any date on it I still get the same error box and if I select
OK on the box then the selected date and time is correctly copied to the
DateandTime1 text box

Giorgio

--- In MS_Access_Professionals@yahoogroups.com, Crystal
<strive4peace2008@...> wrote:
>
> Hi Giorgio,
>
> try downloading it from RogersAccessLibrary
>
>
> Popup Calendar
> by Crystal
> on RogersAccessLibrary
>
http://www.RogersAccessLibrary.com/forum/popup-calendar-for-access-2007-\
and-above_topic597.html
>
>
> Warm Regards,
> Crystal
>
> *
> (: have an awesome day :)
> *
>
>
> ________________________________
> From: giorgio_rovelli
>
>
> Hi Crystal, I can access your Crystal folder so I'm definitely logged
in
> but when I click on
> PopupCalendar_Crystal_120701_ACCDB_TXT_notCompiled~APros.zip
>
<http://f1.grp.yahoofs.com/v1/YKnxT3FK5n0Fgkvk11-kY2hHgGkyMHmwgKwVpHCM2L\
\
>
ZNgzJwbT58ltE84Ityy3zwmxiLQI5_CZWxvb4f_nNrioWMhGe6TE6zCoQCzQU/Crystal/Po\
\
> pupCalendar_Crystal_120701_ACCDB_TXT_notCompiled~APros.zip>
> the browser says it can't find the web page.
>
> Giorgio
> [application/zip]
> PopupCalendar_Crystal_120701_ACCDB_TXT_notCompiled~APros.zip
>
<http://f1.grp.yahoofs.com/v1/YKnxT3FK5n0Fgkvk11-kY2hHgGkyMHmwgKwVpHCM2L\
\
>
ZNgzJwbT58ltE84Ityy3zwmxiLQI5_CZWxvb4f_nNrioWMhGe6TE6zCoQCzQU/Crystal/Po\
\
> pupCalendar_Crystal_120701_ACCDB_TXT_notCompiled~APros.zip>
>
> --- In MS_Access_Professionals@yahoogroups.com, Crystal
> strive4peace2008@ wrote:
> >
> > Hi Giorgia,
> >
> > go to Files>Crystal
> >
>
http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/Crystal\
\
> /
> >
> > and get what starts with "Popup Calendar"
> >
> > I have replaced the file I uploaded before and now it has a
different
> name
> >
> > > "the browser says it can't find the page"
> >
> > you have to be signed in to download
> >
> > Warm Regards,
> > Crystal
> >
> > *
> > (: have an awesome day :)
> > *
> >
> >
> >
> > ________________________________
> > From: giorgio_rovelli
> >
> > Hi Crystal, yes I did compile the code first and it does without any
> error; the double-click event does say [Event Procedure] on the
property
> sheet and it is in a trusted location because code from other accdbs
> placed in the same location does run. Also if I double-click the
> f_PopupCalendar form in the navigation pane, the
> f_PopupCalendar_Test(which opens on startup) keeps on showing instead.
> Anyway, I tried downloading
> PopupCalendar_Crystal_120701_ACCDB_TXT_notCompiled~APros.zip
> > from the link in your Crystal folder but the browser says it can't
> find the page.
> > Giorgio
> >
> > --- Crystal <strive4peace> wrote:
> > >
> > > Hi Giorgio,
> > >
> > > did you compile the code first? In the form design, does the
> double-click event say [Event Procedure] on the property sheet?
> Sometimes you have to "hook up" events again -- the code is there but
> unless the property sheet references it, nothing happens.
> > >
> > > If you open it from the zip file without taking it out of the zip
> file first, it will not work.
> > >
> > > Is the database in a Trusted Location? Perhaps no code will run
...
> > >
> > >
> > > I posted another version in Files >> Crystal ... it is NOT
COMPILED
> (you must do that) and now the calendar has colors and more
quick-switch
> buttons :)
> > >
> > >
> > > PopupCalendar_Crystal_120701_ACCDB_TXT_notCompiled~APros.zip
> > >
> > >
> > > Warm Regards,
> > > Crystal
> > >
> > > *
> > > (: have an awesome day :)
> > > *
> > >
> > >
> > > ________________________________
> > > From: giorgio_rovelli
> > >
> > >
> > > Hi Crystal, I've followed your advice and compiled it with no
errors
> > > given and when I double-click the DateandTime1 text box on
> > > f_PopupCalendar_Test the f_PopupCalendar form still doesn't show,
I
> keep
> > > on seeing only the f_PopupCalendar_Test form and I have to press
the
> ESC
> > > key to continue doing anything within the same file otherwise any
> click
> > > of the mouse or keyboard press gives an acoustic warning. I'm
using
> > > Access 2007.
> > >
> > > Giorgio
> > >
> > > --- In MS_Access_Professionals@yahoogroups.com, Crystal
> > > <strive4peace2008@> wrote:
> > > >
> > > > Hi Giorgio,
> > > >
> > > > did you compile the code before you used the Popup Calendar?
> > > >
> > > > what version of Access are you using?
> > > >
> > > > '~~~~~~~~~ Compile ~~~~~~~~~
> > > >
> > > > Whenever you change code or references, your should always
compile
> > > before executing.
> > > >
> > > > from the menu in a VBE (module) window: Debug, Compile
> > > >
> > > > fix any errors on the yellow highlighted lines
> > > >
> > > > keep compiling until nothing happens (this is good!)
> > > >
> > > > Warm Regards,
> > > > Crystal
> > > >
> > > > *
> > > > (: have an awesome day :)
> > > > *
> > > >
> > > >
> > > >
> > > > ________________________________
> > > > From: giorgio_rovelli
> > > > Subject: Re: [MS_AccessPros] Crystal's New Date Picker
120627_230p
> > > >
> > > >
> > > > Hi Crystal, I've downloaded your
> > > PopupCalendar_Crystal_120627_230p.accdb
> > > > from
> > > >
> > >
>
http://www.rogersaccesslibrary.com/forum/popup-calendar-for-access-2007-\
\
> \
> > > \
> > > > and-above_topic597.html
> > > >
> > >
>
<http://www.rogersaccesslibrary.com/forum/popup-calendar-for-access-2007\
\
> \
> > > \
> > > > -and-above_topic597.html > but when I double-click the
> DateandTime1
> > > > text box on f_PopupCalendar_Test the f_PopupCalendar should open
> up
> > > > because of
> > > >
> > > > Private Sub DateAndTime1_DblClick(Cancel As Integer)
> > > > DoCmd.OpenForm "f_PopupCalendar"
> > > >
> > > > End Sub
> > > >
> > > > but it doesn't, am I missing something?
> > > > Giorgio
> > > >
> > > > --- Crystal <strive4peace> wrote:
> > > > >
> > > > > Hi Clive,
> > > > >
> > > > > I posted another version shortly after the first ...
> > > > >
> > > > > PopupCalendar_Crystal_120627_ACCDB.zip
> > > > >
> > > > > there was an error if the form you are coming from did not
have
> a
> > > > caption ...
> > > > >
> > > > >
> > > > > I made a page on RogersAccesLibrary with screen shots here:
> > > > >
> > > > > Popup Calendar
> > > > > by Crystal
> > > > > on RogersAccessLibrary
> > > > >
> > > >
> > >
>
http://www.RogersAccessLibrary.com/forum/popup-calendar-for-access-2007-\
\
> \
> > > \
> > > > and-above_topic597.html
> > > > >
> > > > > I think I have the same version (now) posted in File>Crystal
> that is
> > > > on RogersAccessLibrary ...
> > > > >
> > > > > if you still have a problem with the latest one, please let me
> know!
> > > > >
> > > > > ~~~
> > > > >
> > > > > > "The first DoubleClick to any of the six controls appears to
> > > > > do nothing."
> > > > >
> > > > > there is no double-click event ... everything is a command
> button
> > > and
> > > > uses the CLICK event
> > > > >
> > > > >
> > > > > > "The only way to close the two forms"
> > > > >
> > > > > you can close the popup form like this:
> > > > > 1. right-click on the TitleBar and choose --> Design View
> > > > > 2. then you can close it
> > > > >
> > > > > the CANCEL button doesn't work?
> > > > >
> > > > > did you compile and save the code before you tested it?
> > > > >
> > > > >
> > > > > Warm Regards,
> > > > > Crystal
> > > > >
> > > > > *
> > > > > (: have an awesome day :)
> > > > > *
> > > > >
> > > > >
> > > > > ________________________________
> > > > > From: Clive zctek@
> > > > > To: MS_Access_Professionals@yahoogroups.com
> > > > > Sent: Friday, June 29, 2012 3:31 PM
> > > > > Subject: [MS_AccessPros] Crystal's New Date Picker 120627_230p
> > > > >
> > > > > Hi Crystal, Giorgio,
> > > > >
> > > > > (I have raised this as a new thread because Giorgio's post
> > > > > is tangled with another thread and you may have missed it.)
> > > > >
> > > > > I have also had trouble with the New Calendar. After
> > > > > opening the DB in Access2007.
> > > > >
> > > > > The first DoubleClick to any of the six controls appears to
> > > > > do nothing.
> > > > > The second DoubleClick appears to do nothing but beep on
> > > > > each further DoubleClick. The only way to close the two forms,
> > > > > yes both are open, is to open the Debug Window and use
> > > > > Docmd.Close acForm,Forms(1).Name
> > > > > Docmd.Close acForm,Forms(0).Name
> > > > >
> > > > > I tried debugging it, by adding a line in the code for
> > > > f_PopupCalendar.FormOpen,
> > > > > after
> > > > > On Error Resume Next, I added
> > > > > MsgBox "Form_Open " & Me.Name
> > > > >
> > > > > and everything appeared to work OK.
> > > > >
> > > > > I removed the fix and the DB still worked OK.
> > > > >
> > > > > I restored the DB from the zip file and it failed
> > > > > as before. I also checked that it was compiled OK
> > > > > before opening any forms.
> > > > >
> > > > > I guess this is going to be a weird one to chase.
> > > > >
> > > > > Regards, Clive.
> > > > >
> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > > > > Giorgio's Post:
> > > > > > [MS_AccessPros] Re: Calendar -- Popup Calendar posted
> > > > >
> > > > > > Hi Crystal, I've downloaded your
> > > > > > PopupCalendar_Crystal_120627_230p.accdb
> > > > > > but when I double-click the DateandTime1 text box on
> > > > > > f_PopupCalendar_Test the f_PopupCalendar should open
> > > > > > up because of
> > > > > >
> > > > > > Private Sub DateAndTime1_DblClick(Cancel As Integer)
> > > > > > '120627
> > > > > > DoCmd.OpenForm "f_PopupCalendar"
> > > > > > End Sub
> > > > > >
> > > > > > but it doesn't, am I missing something?
> > > > > >
> > > > > > Giorgio
> > > > >
> > > > >
> > > > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (18)

Recent Activity:

• New Members 4
• New Files 3

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___