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
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> 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]
>
Tidak ada komentar:
Posting Komentar