By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,689 Members | 1,731 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,689 IT Pros & Developers. It's quick & easy.

Will Stephan Lebans answer questions about his Calendar 'control'?

P: n/a
DFS
If you're listening, I want the middle of the calendar (showing 1 month) to
open below the cursor position. It currently opens just to the right and
below the cursor position.

I hunted through the code, but can't determine what to alter.

Very nice piece of work, by the way.

Thanks
Nov 13 '05 #1
Share this Question
Share on Google+
16 Replies


P: n/a
I'm not sure what you mean as the behaviour here is as expected in that the
MonthCalendar window opens directly underneath the cursor. What version of
the MonthCalendar are you using?

Do you have the latest version dated March 22, 2005 ?

What version of Access and Windows are you using?
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"DFS" <nospam@dfs_.com> wrote in message news:fL****************@fe02.lga...
If you're listening, I want the middle of the calendar (showing 1 month)
to
open below the cursor position. It currently opens just to the right and
below the cursor position.

I hunted through the code, but can't determine what to alter.

Very nice piece of work, by the way.

Thanks

Nov 13 '05 #2

P: n/a
If Stephen Lebans has faulty or worthless software, take it up
privately with him. Do not take up the group's time for his
incompetence. In any case, everyone here already knows about his
ineptitude and lack of skill.

Stephen Lebans wrote:
I'm not sure what you mean as the behaviour here is as expected in that the
MonthCalendar window opens directly underneath the cursor. What version of
the MonthCalendar are you using?

Do you have the latest version dated March 22, 2005 ?

What version of Access and Windows are you using?
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"DFS" <nospam@dfs_.com> wrote in message news:fL****************@fe02.lga...
If you're listening, I want the middle of the calendar (showing 1 month)
to
open below the cursor position. It currently opens just to the right and
below the cursor position.

I hunted through the code, but can't determine what to alter.

Very nice piece of work, by the way.

Thanks


Nov 13 '05 #3

P: n/a
DFS
Stephen Lebans wrote:
I'm not sure what you mean as the behaviour here is as expected in
that the MonthCalendar window opens directly underneath the cursor.
It opens so the top left of the calendar is at the mouse position. I'd like
it to open so the middle of the calendar is at the mouse position.

What version of the MonthCalendar are you using?
2.05

Do you have the latest version dated March 22, 2005 ?

What version of Access and Windows are you using?
Access 2003, Windows Server 2003
Thanks

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"DFS" <nospam@dfs_.com> wrote in message
news:fL****************@fe02.lga...
If you're listening, I want the middle of the calendar (showing 1
month) to
open below the cursor position. It currently opens just to the
right and below the cursor position.

I hunted through the code, but can't determine what to alter.

Very nice piece of work, by the way.

Thanks

Nov 13 '05 #4

P: n/a
No problem.
Open the clsMonthCal module
Goto the Redraw method
Scroll Down till you hit the code below
Copy and paste the last three lines only over the existing code. This is the
call to apiSetWindowPos.

I simply changed the starting X position for the Window to be equal to the
current X Mouse Position minus the width of the window divided by 2.
If m_PositionAtCursor Then
' Position Window at Cursor Location when
' Calendar was created.
'

' Also add an option to position cursor itself in middle of calendar
window
' May 05 - update m_cursorXinitpos and m_cursorYinitpos to reflect
current cursor location when this calendar is opened
' This is done in the modCalendar module when the parent window for the
Calendar is created.

'June 7, 2003 fixing position at cursor logic
' PositionAtCursor = True

' First check to ensure entire calendar window will fit.
' If not MAKE IT!
' COMING IN NEXT RELEASE!
' halfway - ((rc3.Right - rc3.Left) / 2)

With udtRECT
Call apiSetWindowPos(m_Hwnd, 0&, m_cursorX - ((rc3.Right - rc3.Left)
/ 2), m_cursorY, rc3.Right - rc3.Left, _
rc3.Bottom - rc3.Top, 0&)
End With

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"DFS" <nospam@dfs_.com> wrote in message
news:TI*****************@fe06.lga...
Stephen Lebans wrote:
I'm not sure what you mean as the behaviour here is as expected in
that the MonthCalendar window opens directly underneath the cursor.


It opens so the top left of the calendar is at the mouse position. I'd
like
it to open so the middle of the calendar is at the mouse position.

What version of the MonthCalendar are you using?


2.05

Do you have the latest version dated March 22, 2005 ?

What version of Access and Windows are you using?


Access 2003, Windows Server 2003
Thanks

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"DFS" <nospam@dfs_.com> wrote in message
news:fL****************@fe02.lga...
If you're listening, I want the middle of the calendar (showing 1
month) to
open below the cursor position. It currently opens just to the
right and below the cursor position.

I hunted through the code, but can't determine what to alter.

Very nice piece of work, by the way.

Thanks


Nov 13 '05 #5

P: n/a
DFS
Stephen Lebans wrote:
No problem.
Open the clsMonthCal module
Goto the Redraw method
Scroll Down till you hit the code below
Copy and paste the last three lines only over the existing code. This
is the call to apiSetWindowPos.

I simply changed the starting X position for the Window to be equal
to the current X Mouse Position minus the width of the window divided
by 2.
Works like a champ.

If you're still taking requests, I have two more (if not, no problem).
I've gone through the code, but can't figure it out:

* I want to change the title from 'Month Calendar' to Start Date or End
Date. I only found two references that set the window title in your code
(the IsCalendar and Terminate functions), and I set them both to 'Start
Date' but the popup still said 'Month Calendar'

* I might like to open the calendar as a pop-up window, rather than as modal
Thanks much, Stephen

If m_PositionAtCursor Then
' Position Window at Cursor Location when
' Calendar was created.
'

' Also add an option to position cursor itself in middle of
calendar window
' May 05 - update m_cursorXinitpos and m_cursorYinitpos to reflect
current cursor location when this calendar is opened
' This is done in the modCalendar module when the parent window
for the Calendar is created.

'June 7, 2003 fixing position at cursor logic
' PositionAtCursor = True

' First check to ensure entire calendar window will fit.
' If not MAKE IT!
' COMING IN NEXT RELEASE!
' halfway - ((rc3.Right - rc3.Left) / 2)

With udtRECT
Call apiSetWindowPos(m_Hwnd, 0&, m_cursorX - ((rc3.Right -
rc3.Left) / 2), m_cursorY, rc3.Right - rc3.Left, _
rc3.Bottom - rc3.Top, 0&)
End With
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"DFS" <nospam@dfs_.com> wrote in message
news:TI*****************@fe06.lga...
Stephen Lebans wrote:
I'm not sure what you mean as the behaviour here is as expected in
that the MonthCalendar window opens directly underneath the cursor.


It opens so the top left of the calendar is at the mouse position.
I'd like
it to open so the middle of the calendar is at the mouse position.

What version of the MonthCalendar are you using?


2.05

Do you have the latest version dated March 22, 2005 ?

What version of Access and Windows are you using?


Access 2003, Windows Server 2003
Thanks

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"DFS" <nospam@dfs_.com> wrote in message
news:fL****************@fe02.lga...
If you're listening, I want the middle of the calendar (showing 1
month) to
open below the cursor position. It currently opens just to the
right and below the cursor position.

I hunted through the code, but can't determine what to alter.

Very nice piece of work, by the way.

Thanks

Nov 13 '05 #6

P: n/a
The MonthCalendar must be used as a modal window, period.

To change the Caption of the MonthCalendar window:
Open the module modCalendar
Towards the top of the source code find the line:
Private Const TITLE = "Month Calendar"
Change it to whatever you want.
Do not make any changes anywhere else to the Class name .Only change the one
line above.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"DFS" <nospam@dfs_.com> wrote in message news:Sj*************@fe03.lga...
Stephen Lebans wrote:
No problem.
Open the clsMonthCal module
Goto the Redraw method
Scroll Down till you hit the code below
Copy and paste the last three lines only over the existing code. This
is the call to apiSetWindowPos.

I simply changed the starting X position for the Window to be equal
to the current X Mouse Position minus the width of the window divided
by 2.


Works like a champ.

If you're still taking requests, I have two more (if not, no problem).
I've gone through the code, but can't figure it out:

* I want to change the title from 'Month Calendar' to Start Date or End
Date. I only found two references that set the window title in your code
(the IsCalendar and Terminate functions), and I set them both to 'Start
Date' but the popup still said 'Month Calendar'

* I might like to open the calendar as a pop-up window, rather than as
modal
Thanks much, Stephen

If m_PositionAtCursor Then
' Position Window at Cursor Location when
' Calendar was created.
'

' Also add an option to position cursor itself in middle of
calendar window
' May 05 - update m_cursorXinitpos and m_cursorYinitpos to reflect
current cursor location when this calendar is opened
' This is done in the modCalendar module when the parent window
for the Calendar is created.

'June 7, 2003 fixing position at cursor logic
' PositionAtCursor = True

' First check to ensure entire calendar window will fit.
' If not MAKE IT!
' COMING IN NEXT RELEASE!
' halfway - ((rc3.Right - rc3.Left) / 2)

With udtRECT
Call apiSetWindowPos(m_Hwnd, 0&, m_cursorX - ((rc3.Right -
rc3.Left) / 2), m_cursorY, rc3.Right - rc3.Left, _
rc3.Bottom - rc3.Top, 0&)
End With
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"DFS" <nospam@dfs_.com> wrote in message
news:TI*****************@fe06.lga...
Stephen Lebans wrote:
I'm not sure what you mean as the behaviour here is as expected in
that the MonthCalendar window opens directly underneath the cursor.

It opens so the top left of the calendar is at the mouse position.
I'd like
it to open so the middle of the calendar is at the mouse position.
What version of the MonthCalendar are you using?

2.05
Do you have the latest version dated March 22, 2005 ?

What version of Access and Windows are you using?

Access 2003, Windows Server 2003
Thanks
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"DFS" <nospam@dfs_.com> wrote in message
news:fL****************@fe02.lga...
> If you're listening, I want the middle of the calendar (showing 1
> month) to
> open below the cursor position. It currently opens just to the
> right and below the cursor position.
>
> I hunted through the code, but can't determine what to alter.
>
> Very nice piece of work, by the way.
>
> Thanks


Nov 13 '05 #7

P: n/a
Stephen,
(repeating a private e-mail sen tto you...)

Concerning focus issue:

I notice an issue with focus when:

I have a popup/non-modal form that creates an instance of the class
with:
OnFormLoad:
Set mc = New clsMonthCal
mc.hWndForm = Me.hWnd

On that form is a command button that opens a second form that is
popup/modal and it too creates an instance of the class with the same
OnFormLoad code.

When the user opens the calendar from the second form, the calendar
cannot be clicked because it does not have the focus. However, if the
use clicks any other application, or the Windows desktop, then clicks
the calendar, it works.

I took a look at how you deal with modal/popup forms but cannot figure
out a workaround for this situation. Is there a solution?

It is intriguing because the same originating form (the first form, has
a subform which also creates an instance with your code in the
OnFormLoad and that works fine!

Nov 13 '05 #8

P: n/a
Lauren I do not respond to private Email requests as there are simply too
many.

I am currently busy trying to add functionality to my Report to PDF solution
that I just posted tonight.
http://www.lebans.com/reporttopdf.htm

If you have a MDB that you can Email me I will take a look at your issue
this weekend. No promises though. Form/control focus issues are a nightmare
in Access. If you look at the MonthCalendar source code to see how I had to
handle this in Access you'll see what I mean. Those few lines of code cost
me hours of testing to finally get it right. I'm simply not willing to
change it for any circumstance at this point as the code is proven and works
well.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit
..

"Lauren Quantrell" <la*************@hotmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
Stephen,
(repeating a private e-mail sen tto you...)

Concerning focus issue:

I notice an issue with focus when:

I have a popup/non-modal form that creates an instance of the class
with:
OnFormLoad:
Set mc = New clsMonthCal
mc.hWndForm = Me.hWnd

On that form is a command button that opens a second form that is
popup/modal and it too creates an instance of the class with the same
OnFormLoad code.

When the user opens the calendar from the second form, the calendar
cannot be clicked because it does not have the focus. However, if the
use clicks any other application, or the Windows desktop, then clicks
the calendar, it works.

I took a look at how you deal with modal/popup forms but cannot figure
out a workaround for this situation. Is there a solution?

It is intriguing because the same originating form (the first form, has
a subform which also creates an instance with your code in the
OnFormLoad and that works fine!

Nov 13 '05 #9

P: n/a
DFS
Stephen Lebans wrote:
I am currently busy trying to add functionality to my Report to PDF
solution that I just posted tonight.
http://www.lebans.com/reporttopdf.htm


Stephan,

Error report for you.

I'm running Access 2003. Extracted your zip file to a folder. Launched the
..mde, and none of the reports on the 'Convert report to PDF' tab will
convert. All throw the same error:

fCreateSnap.fParseSnap:-2147220958
Sorry...Page Size not supported
Please select a different Report to Export

The 'Convert Snapshot to PDF' did work.

(Haven't tried using it in my own .mdb yet. Nice tool, but a few months
late - could have saved a client of mine about $1500. I recommended Win2PDF
for them.)

Your calendar is nice!


Nov 13 '05 #10

P: n/a
It's a known bug. It happens when a report is formatted improperly so that
a single report page will not fit on one output page. Usually it's simply
the margin settings are too large for the current printer. I'll bet you are
either working with a a non US page size or your current printer is an Ink
Jet and the bottom margin is greater than the .5 inch setting on the sample
reports.
Open any of the sample Reports in design view, modify the paper size or
Margins to allow the repor to fit onto your current page setup. Try the
conversion process again and it will work properly.

I will add logic to handle this issue in the next release.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"DFS" <nospam@dfs_.com> wrote in message
news:DI*******************@fe05.lga...
Stephen Lebans wrote:
I am currently busy trying to add functionality to my Report to PDF
solution that I just posted tonight.
http://www.lebans.com/reporttopdf.htm


Stephan,

Error report for you.

I'm running Access 2003. Extracted your zip file to a folder. Launched
the
.mde, and none of the reports on the 'Convert report to PDF' tab will
convert. All throw the same error:

fCreateSnap.fParseSnap:-2147220958
Sorry...Page Size not supported
Please select a different Report to Export

The 'Convert Snapshot to PDF' did work.

(Haven't tried using it in my own .mdb yet. Nice tool, but a few months
late - could have saved a client of mine about $1500. I recommended
Win2PDF
for them.)

Your calendar is nice!

Nov 13 '05 #11

P: n/a
Stephen,
I discovered the issue with focus while putting together an example to
send to you.
It is this:

If the user executes your calendar code from an Image control, there is
a focus problem. It has nothing to do with opening a form from another
form as I originally reported.

To duplicate this problem:
Create an image control on your customer form (I use a small icon image
of a calendar that users click to open the calendar.)
Copy the code from any of the date controls (ie: txtLongDate) to the
OnClick event of the image control.

When the calendar opens, the application appears frozen until the user
either clicks the Windows desktop or brings focus to another
aplication.

To solve this problem:
Create an invisible command button and place it on top of the image
control and execute the code from the command button instead of the
image control.

lq

Nov 13 '05 #12

P: n/a
"Stephen Lebans"
<ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com> wrote in
news:R9**********************@ursa-nb00s0.nbnet.nb.ca:
It's a known bug. It happens when a report is formatted
improperly so that a single report page will not fit on one output
page. Usually it's simply the margin settings are too large for
the current printer. I'll bet you are either working with a a non
US page size or your current printer is an Ink Jet and the bottom
margin is greater than the .5 inch setting on the sample reports.
Open any of the sample Reports in design view, modify the paper
size or Margins to allow the repor to fit onto your current page
setup. Try the conversion process again and it will work properly.

I will add logic to handle this issue in the next release.


It could also just be the default printer has changed to something
nonsensical. I ran into this a couple of weeks ago with a client who
installed a photo printer, which has a default page size of 4x6 or
something like that. It's a very stupid printer driver that installs
itself on a computer tjhat already has a default printer and makes
itself the default printer, but it happened.

I laughed when I realized what it was.

I've found, that as long as the printer supports the defined paper
size, it won't throw the mentioned error -- it will just lose things
like the margins and correct paper size. Of course, that's assuming
you've saved your report to print to the default printer. If yo've
saved for a non-default printer, other things can happen. I try not
to do that.

I've never quite understood how Word can manage to avoid these sorts
of problems but Microsoft never fixed Access reports to work around
it.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #13

P: n/a
Posted new version tonight.
http://www.lebans.com/reporttopdf.htm
Make sure you download the archive that matches your version of Access.
Please view the form named README before launching the converter.

New Release: Nov 08/2005

A2003ReportToPDF is an Access 2003 database containing a function to convert
Reports and Snapshot files to PDF documents. No PDF Printer driver is
required.

A2002ReportToPDF A2002 Version

A2000ReportToPDF A2000 Version

A97 version coming soon.

Version 1.8

Added Boolean parameter to signal whether the registered PDF application
should be launched to view newly created PDF document. Add StrStorage.DLL to
fix issue with parsing of Snapshot file. This will also fix non USA issue(
Error Paper Size is not supported). The A2K MDB showed corruption upon
conversion from the original A2003 version. I imported everything into a
blank MDB and the corruption has disappeared. Please let me know if it
resurfaces.

Version 1.7 First release
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"David W. Fenton" <dX********@bway.net.invalid> wrote in message
news:Xn**********************************@216.196. 97.142...
"Stephen Lebans"
<ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com> wrote in
news:R9**********************@ursa-nb00s0.nbnet.nb.ca:
It's a known bug. It happens when a report is formatted
improperly so that a single report page will not fit on one output
page. Usually it's simply the margin settings are too large for
the current printer. I'll bet you are either working with a a non
US page size or your current printer is an Ink Jet and the bottom
margin is greater than the .5 inch setting on the sample reports.
Open any of the sample Reports in design view, modify the paper
size or Margins to allow the repor to fit onto your current page
setup. Try the conversion process again and it will work properly.

I will add logic to handle this issue in the next release.


It could also just be the default printer has changed to something
nonsensical. I ran into this a couple of weeks ago with a client who
installed a photo printer, which has a default page size of 4x6 or
something like that. It's a very stupid printer driver that installs
itself on a computer tjhat already has a default printer and makes
itself the default printer, but it happened.

I laughed when I realized what it was.

I've found, that as long as the printer supports the defined paper
size, it won't throw the mentioned error -- it will just lose things
like the margins and correct paper size. Of course, that's assuming
you've saved your report to print to the default printer. If yo've
saved for a non-default printer, other things can happen. I try not
to do that.

I've never quite understood how Word can manage to avoid these sorts
of problems but Microsoft never fixed Access reports to work around
it.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

Nov 13 '05 #14

P: n/a
DFS
I think/thought I found a bug in your calendar control.

If you select a date range while showing more than 1 month, then change the
setting to show just 1 month, the dates stay selected no matter which months
you scroll to.
....
.....

Whoops... then I took another look before I sent the post, and decided you
probably coded it that way, since as you scroll from month to month the same
relative dates stay selected, ie if you select Nov 17th thru Dec 12th 2005,
when you scroll back or forwards the same dates in the current months on
screen stay selected, whether you go back to 2003 or forward to 2007.

Cool.

Stephen Lebans wrote:
It's a known bug. It happens when a report is formatted improperly
so that a single report page will not fit on one output page. Usually
it's simply the margin settings are too large for the current
printer. I'll bet you are either working with a a non US page size or
your current printer is an Ink Jet and the bottom margin is greater
than the .5 inch setting on the sample reports.
Open any of the sample Reports in design view, modify the paper size
or Margins to allow the repor to fit onto your current page setup.
Try the conversion process again and it will work properly.

I will add logic to handle this issue in the next release.
"DFS" <nospam@dfs_.com> wrote in message
news:DI*******************@fe05.lga...
Stephen Lebans wrote:
I am currently busy trying to add functionality to my Report to PDF
solution that I just posted tonight.
http://www.lebans.com/reporttopdf.htm


Stephan,

Error report for you.

I'm running Access 2003. Extracted your zip file to a folder.
Launched the
.mde, and none of the reports on the 'Convert report to PDF' tab will
convert. All throw the same error:

fCreateSnap.fParseSnap:-2147220958
Sorry...Page Size not supported
Please select a different Report to Export

The 'Convert Snapshot to PDF' did work.

(Haven't tried using it in my own .mdb yet. Nice tool, but a few
months late - could have saved a client of mine about $1500. I
recommended Win2PDF
for them.)

Your calendar is nice!

Nov 13 '05 #15

P: n/a
Bug...Feature...it is a very fine line between the two.<grin>

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"DFS" <nospam@dfs_.com> wrote in message
news:zL*****************@fe03.lga...
I think/thought I found a bug in your calendar control.

If you select a date range while showing more than 1 month, then change
the
setting to show just 1 month, the dates stay selected no matter which
months
you scroll to.
...
....

Whoops... then I took another look before I sent the post, and decided you
probably coded it that way, since as you scroll from month to month the
same
relative dates stay selected, ie if you select Nov 17th thru Dec 12th
2005,
when you scroll back or forwards the same dates in the current months on
screen stay selected, whether you go back to 2003 or forward to 2007.

Cool.

Stephen Lebans wrote:
It's a known bug. It happens when a report is formatted improperly
so that a single report page will not fit on one output page. Usually
it's simply the margin settings are too large for the current
printer. I'll bet you are either working with a a non US page size or
your current printer is an Ink Jet and the bottom margin is greater
than the .5 inch setting on the sample reports.
Open any of the sample Reports in design view, modify the paper size
or Margins to allow the repor to fit onto your current page setup.
Try the conversion process again and it will work properly.

I will add logic to handle this issue in the next release.
"DFS" <nospam@dfs_.com> wrote in message
news:DI*******************@fe05.lga...
Stephen Lebans wrote:

I am currently busy trying to add functionality to my Report to PDF
solution that I just posted tonight.
http://www.lebans.com/reporttopdf.htm

Stephan,

Error report for you.

I'm running Access 2003. Extracted your zip file to a folder.
Launched the
.mde, and none of the reports on the 'Convert report to PDF' tab will
convert. All throw the same error:

fCreateSnap.fParseSnap:-2147220958
Sorry...Page Size not supported
Please select a different Report to Export

The 'Convert Snapshot to PDF' did work.

(Haven't tried using it in my own .mdb yet. Nice tool, but a few
months late - could have saved a client of mine about $1500. I
recommended Win2PDF
for them.)

Your calendar is nice!


Nov 13 '05 #16

P: n/a
DFS
Stephen Lebans wrote:
Bug...Feature...it is a very fine line between the two.<grin>
ha! I see. Just call it luck, eh?

The dates aren't really selected when you go to other months, they're just
highlighted. It's still kind of useful to see them highlighted.


"DFS" <nospam@dfs_.com> wrote in message
news:zL*****************@fe03.lga...
I think/thought I found a bug in your calendar control.

If you select a date range while showing more than 1 month, then
change the
setting to show just 1 month, the dates stay selected no matter which
months
you scroll to.
...
....

Whoops... then I took another look before I sent the post, and
decided you probably coded it that way, since as you scroll from
month to month the same
relative dates stay selected, ie if you select Nov 17th thru Dec 12th
2005,
when you scroll back or forwards the same dates in the current
months on screen stay selected, whether you go back to 2003 or
forward to 2007.

Cool.

Stephen Lebans wrote:
It's a known bug. It happens when a report is formatted improperly
so that a single report page will not fit on one output page.
Usually it's simply the margin settings are too large for the
current printer. I'll bet you are either working with a a non US
page size or your current printer is an Ink Jet and the bottom
margin is greater than the .5 inch setting on the sample reports.
Open any of the sample Reports in design view, modify the paper size
or Margins to allow the repor to fit onto your current page setup.
Try the conversion process again and it will work properly.

I will add logic to handle this issue in the next release.
"DFS" <nospam@dfs_.com> wrote in message
news:DI*******************@fe05.lga...
Stephen Lebans wrote:

> I am currently busy trying to add functionality to my Report to
> PDF solution that I just posted tonight.
> http://www.lebans.com/reporttopdf.htm

Stephan,

Error report for you.

I'm running Access 2003. Extracted your zip file to a folder.
Launched the
.mde, and none of the reports on the 'Convert report to PDF' tab
will convert. All throw the same error:

fCreateSnap.fParseSnap:-2147220958
Sorry...Page Size not supported
Please select a different Report to Export

The 'Convert Snapshot to PDF' did work.

(Haven't tried using it in my own .mdb yet. Nice tool, but a few
months late - could have saved a client of mine about $1500. I
recommended Win2PDF
for them.)

Your calendar is nice!

Nov 13 '05 #17

This discussion thread is closed

Replies have been disabled for this discussion.