Hello all!
I have a report that automatically prints for the user. The problem is that our group in Europe uses a different size of paper. Is there a way to customize the Docmd.OpenReport command to use A4 as the paper size for printers in Europe and Letter size for printers in the USA?
-Or-
Does the command have a fit to page setting I can use?
(I can use a DLook-up to determine if the user is in Europe if I need to.)

Thanks in advance for the help!

Regards,
Laura

FYI...My user id has changed. My old id was lbreitenbach

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

__________________
Regards,
Laura

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

WOuld it be possible to create a version of the report for Europe, and then check for the user location, and then just change the report name like:

If (user is in usa) Then
   sDoc = "repForUSA"
Else
   sDoc = "rptForEurope"
End If

DoCmd.OpenReport sDoc...

Did that help?

mmcdonal

Look it up at: http://wrox.books24x7.com

Mmcdonal,
That is a good idea...Thanks! Do you happen to know if there is a line of code that will check the system files to see what Country or time zone their PC is set up as? That way I can use that in the If statements instead of maintaining a table with the information. (This would help also if a user is traveling.)

Regards,
Laura

FYI...My user id has changed. My old id was lbreitenbach

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!

Sorry for the delay. We were out Friday due to weather. You can do this to retrieve the time zone:

sComp = "."
Set objWMI = GetObject("winmgmts:\\" & sComp & "\root\CIMV2")
Set colItems = objWMI.ExecQuery("SELECT * FROM Win32_TimeZone", "WQL")
For Each objItem In colItems
      sZone = objItem.Caption
Next

Then check sZone. On my PC it returns:

(GMT-05:00) Eastern Time (US & Canada)

So that should help. I would check the GMT value, perhaps, or the US & Canada string. To see all the possible values, double click your clock in the Sys Tray. When the Date and Time Properties dialog box comes up, click the Time Zone tab, and use the pull down at the top to see all the possible lines returned by this routine. Then you could create a table, or just do a Select Case statement.

Did that help?

mmcdonal

Look it up at: http://wrox.books24x7.com

mmcdonal,
Thank you so much for this information! I'll give this a try this week and let you know if I have any issues.


Regards,
Laura

FYI...My user id has changed. My old id was lbreitenbach

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!