ACCESS FEED: Re: [MS_AccessPros] Crystal's New Date Picker

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]