Allen Browne Popup Calendar - Positioning Form.

[Peter Hibbs]

Access 2003.

I am using the Popup Calendar from Allen Browne.

What I would like to happen is when the user clicks on the calendar
button on the form (which is positioned immediately to the right of
the associated date field), is for the popup calendar form to be
positioned at the same co-ordinates as the button instead of in the
middle of the form. That is, the top left corner of the popup calendar
to be the same as the top left corner of the calendar button. I may
have to ensure that the buttons are not near the right or bottom edges
of the form but that should be possible.

At the moment I don't see any easy way to do this so I am wondering if
anyone has done this and would like to share the code.

Peter Hibbs.

 

[Peter Hibbs]

And what happens if you have more than one calendar button on the form
(as I have)?

Peter Hibbs.

 

[Stuart McCall]

Access 2003.

I am using the Popup Calendar from Allen Browne.

What I would like to happen is when the user clicks on the calendar
button on the form (which is positioned immediately to the right of
the associated date field), is for the popup calendar form to be
positioned at the same co-ordinates as the button instead of in the
middle of the form. That is, the top left corner of the popup calendar
to be the same as the top left corner of the calendar button. I may
have to ensure that the buttons are not near the right or bottom edges
of the form but that should be possible.

At the moment I don't see any easy way to do this so I am wondering if
anyone has done this and would like to share the code.

Peter Hibbs.

This code will do what you want:

http://www.smccall.demon.co.uk/Forms.htm#OpenUnder

Also you won't need to ensure that the buttons are not near the right or
bottom edges of the form. That's adjusted in the code.

 

[Peter Hibbs]

Stuart,

Thanks, that is a whole lot of code, I will investigate tomorrow and
see what I can come up with.

Peter Hibbs.

 

[Jeanette Cunningham]

Hi
I used some similar code to do the same thing using A2003.
When the database was used in A2007 (as an .mde), the date control and the
button/image froze whenever the calendar button/icon was clicked.

I ended up needing to remove all the code to position the calendar. By the
way, I was also using Allen Browne's popup calendar.



Jeanette Cunningham

 

[Peter Hibbs]

Jeanette,

Thanks for that tip, this database will very likely be used on A2007
at a later date so I will test any code I use on that version first.

As a matter of interest, did you manage to determine why the code did
not work and would it have been possible to disable the calendar code
if it is being used under Access 2007 (since this facility is built in
on that version).

Peter Hibbs.

 

[Mike Painter]

2007 has this feature standard but it only works on an .accdb file.
The icon comes and goes on an .mdb file but does nothing else.

 

[Pete D.]

I use it in 2007 with old mdb files with my date fields and it works fine.
As a matter of fact I removed the code version so I wouldn't have two.

 

[Mike Painter]

Really, even with everything set in teh table all I saw was the icon which
disappeared when I entered the field..
What kind of cookies do you feed the brownies with?

 

[Pete D.]

I did find that if the control had some input masks the date picker didn't
work but if I strip that and set the display format to whatever I wanted it
worked fine.

 

[Jeanette Cunningham]

No, I haven't had time to play with it yet.

Jeanette Cunningham

 

[Mishanya]

Hi Piter
I've had the same issue with having more then one calling-a-calenader button
on my form.
Ended up with copy of the calendar-form for every button (with small
respective adjustments in the buttons code) and positioning them thru opening
in DesignView and saving in the needed spot.
Seems like the most simple solution not requiring cubersome extra code -
just a few more same forms in the DB.

 

[Pete D.]

What about the movesize command? Relitive to the top left corner. Doug
Steele suggested this in a forum response awhile ago that I used. Can't
find it or my code I created now though, sorry. Have to use some code
relative to the control position. Link below might also help.
http://forums.whirlpool.net.au/forum-replies-archive.cfm/614018.html