473,322 Members | 1,496 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Avoid Navigation Pane to enlarge

759 512MB
Hy !
I use following code to print out a report WITHOUT open it
Expand|Select|Wrap|Line Numbers
  1. Private Sub cmdPrintReportRAM_Click()
  2.     DoCmd.SelectObject acReport, "ReportName", True
  3.     DoCmd.PrintOut acPrintAll, , , , , 1
  4. End Sub
My trouble become with line 2.
This cause Navigation Pane window to enlarge (open).

Is here any way to avoid this ?
I wish NOT to deny user access to Navigation Pane.

ACCESS 2007
Nov 12 '11 #1

✓ answered by Seth Schrock

I'm not sure if this will do what you are looking for, but you could try another approach to print the report without opening it. If you use the following code, it will print out the report to the computer's default printer without opening it.

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenReport("ReportName")
Because the default view for the this command is acViewNormal, you will get the proper results without specifying the view. And since you aren't selecting the report, it won't cause the navigation pane to open.

I believe that this will work for you.

2 2270
Seth Schrock
2,965 Expert 2GB
I'm not sure if this will do what you are looking for, but you could try another approach to print the report without opening it. If you use the following code, it will print out the report to the computer's default printer without opening it.

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenReport("ReportName")
Because the default view for the this command is acViewNormal, you will get the proper results without specifying the view. And since you aren't selecting the report, it won't cause the navigation pane to open.

I believe that this will work for you.
Nov 12 '11 #2
Mihail
759 512MB
Thank you Seth ! Very much !
This work properly.
Nov 13 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: SteamyFrog | last post by:
I'm looking to place an icon for my app on the Navigation Pane (lower right of task bar), yet haven't been able to find any information on how to do this. The app basically is a running file...
0
by: Yama | last post by:
Good Afternoon to all, What will be the best way to capture ServerClick from a a left menu generated by a datalist? Private Sub GetReports() Try Dim cmd As New SqlCommand Dim conn As New...
1
by: Allen Browne | last post by:
In Access 2007, you can select multiple items in the Navigation Pane, via Shift+Click, Ctrl+Click, Shift+arrow keys, etc. You can also Shift+Del an object to delete it without confirmation (just...
4
by: David T. Ashley | last post by:
In my application, I'm going to have a navigation pane (i.e. frames) on the left that links to pages that display in the main window. The list of choices varies by user, but once a user logs in,...
0
by: Wayne | last post by:
I've been looking and maybe I've missed something but is there a way to undock the navigation pane or at least not have it "always on top" in design view? I realize it can be minimized, but having...
5
by: Patrick | last post by:
I have set the Navigation Pane so that it is not displayed on startup of my application. However, if I programmatically link to an external Access table, the navigation pane automatically...
1
by: chupachup32 | last post by:
I'm a student trying to teach myself to use access. I somehow managed to minimize my navigation pane and now I can't figure out how to reopen it. The Access handbook says that, even when minimized,...
2
by: Bob | last post by:
Hi, In runtime environement my access 2007 application dont show the Navigation Pane, anybody have this problem ? Thank's for reply Bob
1
by: u473 | last post by:
.... or what is the VBA code or Utility which will give me a neat listing of Tables, Queries, Reports, Forms etc... with Dates Created / Modified. Thank you, Celeste
0
by: Walter Raymond | last post by:
Our backend Access 2007 database will be locked but we don't want our users to have access to the Navigation Pane, accidental or otherwise. W
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.