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

Hi Giorgio,

> I pressed CTRL+break as instructed and code stops at the line
> Resume Proc_Exit in Public Sub Set_Calendar

in debug mode, right-click on the next line, RESUME,and choose --> Set Next Statement
then press F8 to go to the statement that is causing problems and tell me what it is

Warm Regards,
Crystal

*
(: have an awesome day :)
*

________________________________
From: giorgio_rovelli

Hi Crystal, yes the database is opened on its own and I decompiled it
first and no references are missing and the checked ones are VBA, Access
12 object library, Ole Automation and Access Database Engine Object
Library.

I pressed CTRL+break as instructed and code stops at the line

Resume Proc_Exit in Public Sub Set_Calendar

Giorgio

--- In MS_Access_Professionals@yahoogroups.com, Crystal
<strive4peace2008@...> wrote:
>
> correction:
>
> to change what line executes next, right-click on a line and choose
--> Set Next Statement
>
> Not all the procedures have error handlers, I will fix that if and
when I post another version
>
>
> ________________________________
> From: Crystal
>
> Hi Giorgio,
>
> are you opening the database on its own? Did you compile the code
first?
>
> What references are checked or missing?
> from VBE --> Tools, References
>
>
> Do you have any add-ins installed?
>
> Do you have multiple versions of Access installed on your drive?
>
> when the error message pops up:
> 1. press Ctrl-Break
> 2. acknowledge the msgbox if necessary
> 3. see where the error is in the code
>
> in Debug mode:
>
> to change what line executes next, right-click on a line and choose
--> Next Statement
> F8 = execute one statement at a time
> F5 = continue execution normally
>
> Ctrl-G = Goto debuG (Immediate) window, where you can test the value
of variables and do lots of other things
>
>
> Happy Independence Day!
>
> Warm Regards,
> Crystal
>
> *
> (: have an awesome day :)
> *
>
>
> ________________________________
> From: giorgio_rovelli
>
>
> 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
>
>
> --- Crystal <strive4peace> 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]
>

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]