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