473,765 Members | 2,021 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Prevent Report Preview from Escaping into Design Mode

I must be missing something, but I have a report that when it is opened
programmaticall y as a Preview, there is a limited toolbar which
prevents the ability to edit the design, among other things. However,
if the use presses the <ESCAPEkey, it automatically reverts to Design
Mode.

How do I prevent this?

Aug 9 '06 #1
4 1711
To be more specific, when I click on the "Preview" button on the
database window, pressing the <ESCAPEkey simply closes the form. But
when I use DoCmd.OpenRepor t with acPreview, the <ESCAPEkey dumps the
report into design mode.

ve******@gmail. com wrote:
I must be missing something, but I have a report that when it is opened
programmaticall y as a Preview, there is a limited toolbar which
prevents the ability to edit the design, among other things. However,
if the use presses the <ESCAPEkey, it automatically reverts to Design
Mode.

How do I prevent this?
Aug 10 '06 #2
This is the kind of thing that annoys me about someone following up
themselves, a post at 6pm and a followup at 8pm that includes
information that should have been included in the original post.

THINK BEFORE YOU POST THE FIRST TIME.

At 5:44pm, ve******@gmail. com wrote in
news:11******** **************@ m73g2000cwd.goo glegroups.com:
I must be missing something, but I have a report that when it is
opened programmaticall y as a Preview, there is a limited toolbar
which prevents the ability to edit the design, among other things.
However, if the use presses the <ESCAPEkey, it automatically
reverts to Design Mode.

How do I prevent this?
And then at 8:13pm, ve******@gmail. com wrote in
news:11******** *************@p 79g2000cwp.goog legroups.com:
To be more specific, when I click on the "Preview" button on the
database window, pressing the <ESCAPEkey simply closes the form.
But when I use DoCmd.OpenRepor t with acPreview, the <ESCAPEkey
dumps the report into design mode.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Aug 10 '06 #3
David,

While I can appreciate your desire for an orderly world, I actually
feel that I included enough information in the first post, but,
concerned that there would be no response to my query, based on past
experience, decided to add a reply to push it up the stack.

Rather than simply write "Anyone?," I decided to rephrase the original
question with more specific language. However, were you to parse
through both, you would find that they say the same thing. And anyone
who is capable of answering it would likely realize that.

Thank you though for the opportunity to push this back up through the
stack. Perhaps someone might be able to respond with a resolution to
my issue (for which I searched mightily throughout these groups and the
web in general), as opposed to posting a declaration of a pet peeve.

regards,
marc

David W. Fenton wrote:
This is the kind of thing that annoys me about someone following up
themselves, a post at 6pm and a followup at 8pm that includes
information that should have been included in the original post.

THINK BEFORE YOU POST THE FIRST TIME.

At 5:44pm, ve******@gmail. com wrote in
news:11******** **************@ m73g2000cwd.goo glegroups.com:
I must be missing something, but I have a report that when it is
opened programmaticall y as a Preview, there is a limited toolbar
which prevents the ability to edit the design, among other things.
However, if the use presses the <ESCAPEkey, it automatically
reverts to Design Mode.

How do I prevent this?

And then at 8:13pm, ve******@gmail. com wrote in
news:11******** *************@p 79g2000cwp.goog legroups.com:
To be more specific, when I click on the "Preview" button on the
database window, pressing the <ESCAPEkey simply closes the form.
But when I use DoCmd.OpenRepor t with acPreview, the <ESCAPEkey
dumps the report into design mode.


--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Aug 14 '06 #4
I was taught never to scold someone who asks a favour, especially if you don't do it for them.

On Wed, 09 Aug 2006 20:37:03 -0500, "David W. Fenton" <XX*******@dfen ton.com.invalid wrote:
>This is the kind of thing that annoys me about someone following up
themselves, a post at 6pm and a followup at 8pm that includes
information that should have been included in the original post.

THINK BEFORE YOU POST THE FIRST TIME.

At 5:44pm, ve******@gmail. com wrote in
news:11******* *************** @m73g2000cwd.go oglegroups.com:
>I must be missing something, but I have a report that when it is
opened programmaticall y as a Preview, there is a limited toolbar
which prevents the ability to edit the design, among other things.
However, if the use presses the <ESCAPEkey, it automatically
reverts to Design Mode.

How do I prevent this?

And then at 8:13pm, ve******@gmail. com wrote in
news:11******* **************@ p79g2000cwp.goo glegroups.com:
>To be more specific, when I click on the "Preview" button on the
database window, pressing the <ESCAPEkey simply closes the form.
But when I use DoCmd.OpenRepor t with acPreview, the <ESCAPEkey
dumps the report into design mode.
Aug 14 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
5891
by: Jeff | last post by:
I have a need to open a report in design mode immediately before opening it in preview, to change the Minimum and Maximum scale on an axis on a chart. This results in a flash of the report in design mode just before it is opened in preview mode. Is there any way to open it in design mode hidden? Jeff
8
2982
by: Armando | last post by:
Here's one that's going to leave me bald before long - I have a report (no headers or footers, small detail section) that runs normally when I open it from the database window. When I run it from code: DoCmd.OpenReport "rpt_Name", acViewPreview I get five records on the first page, and only one record on the second
6
8190
by: Salad | last post by:
Hi: I have a Bill of Lading template from the printer that I saved as a BMP. I created a new report and in the report's picture property told it the BMP file name. It brought the image in just fine. I then placed the fields in the report. Then I previewed the report. The picture resized or something and all of my nice fields were no longer in the same position. It didn't make any difference if I selected Crop, Zoom, or...
4
2826
by: Gary | last post by:
Hello, I'm hoping someone can shed some light on why my report does not output the same results as shown in preview mode, which is to move the position of a check box based on a field value (see code below). The code does exactly what I want only in preview mode; it moves the check box only when the drug criteria is true. However, when I print the report the check box position remains unchanged. I tried putting the same code to both the...
2
1326
by: tricard | last post by:
Hello all, I have a report that displays four pieces of data by default, but two of these fields are not neccessary for all people to see. I have made a form that gives the user the choice to select what data to display when the report is being run. After the selection has been made on the form, the report is opened in design mode, saved, closed and reopened it in preview mode. I was wondering if there is a cleaner way to modify the...
1
1792
by: vermutmb | last post by:
I'm totally stuck. When I click on the "Preview" button for a report on the database window, pressing the <ESCAPEkey simply closes the report. But when I use DoCmd.OpenReport with acPreview on a form, pressing the <ESCAPEkey dumps the report into design mode. To add one more quirk, creating a new form, and using the wizard to create a Print Preview command button sets the report behavior back to normal, by closing the report clean on...
2
6271
by: Wayne | last post by:
I've been having a click around Access 2007 this afternoon and have discovered some things that range from annoying to alarming. My Access 2003 menu bars, which I, like many others, use extensively, are now hidden behind an "Add Ins" tab on the Ribbon. Hardly an intuitive place for a user to find them. Unless my memory is failing me, I'm sure that Access 2003 menus displayed normally in the 2007 Beta. The other thing I've discovered...
0
1525
by: davidz | last post by:
My office has adopted Team Foundation Server to track and manage the development and deployment process at our site. I have been asked to modify one of the standard work item reports, "Related Work Items," that ships with TFS. I've successfully done some of these, which involved changing the MDX code for the datasets that generate default parameter values, but I am running into problems modifying the main dataset, dsRelatedWorkItems. I...
11
7336
by: Gord | last post by:
When I open a certain report, it runs some code that generates the records that will be displayed in that report. This works fine. When I go to print preview the report it appears that the code is run again? This is causing certain error problems. 1 Why does the code run for a print preview when the report already exists? 2 What command do I use in code to find out if a report (or any other object for that matter) is already...
0
9568
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10160
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10007
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8831
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
6649
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5275
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3924
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3531
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2805
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.