I've developed a product pricing application for a client in AC2007.
They enter all the data on the one main form, then click a button to open a printable report in Print Preview.
My problem is, once in Print Preview, the Close Print Preview button on the ribbon doesn't work. It's there, it just does nothing when I click it. To close the report you have to press Ctrl+F4.
This is bad, but worse is I can't even put a message on the report telling the user to press Ctrl+F4, as they view it in Print Preview mode, so I can't have a label with Display When set to Screen Only, as they don't see that in Print Preview.
It's a very standard report, quite a few fields but no calculations involved, it gets all its data straight from a precalculated table. There's nothing I can think of that would be causing strange behaviour. I've got another report in the system, and that closes fine.
I get the same behaviour whether it's an accdb or accde.
Any ideas where I might start finding out what's causing this?
4  4998  NeoPa 32,567
Recognized Expert Moderator MVP
All I can suggest is to try to find somewhere that lists known bugs (features) of the new Acc2007 software.
Some MVPs publish lists as a feature on their sites. I'm afraid I can't think of anything more helpful.
Problem solved by copying everything to a new report. The usual answer to Access' flakiness!
NeoPa 32,567
Recognized Expert Moderator MVP
Oh that one!
I should do an article on "How to Avoid Corruption with MS Access". A fairly short one - "Don't use it." :D
@NeoPa
This was not really funny or helpful. Just sayin'.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Nathan Bloomfield |
last post by:
Does anyone know if there is any documentation which relates to Access2k + ?
or can anyone help adjust the code?
I am having trouble converting the DAO references.
TITLE :INF: How to Create a Dynamic Crosstab Report
PRODUCT :Microsoft Access
PROD/VER:1.00 1.10
OPER/SYS:WINDOWS
|
by: Phil Stanton |
last post by:
In code I am opening a report in deign view, adding code to the report to
output it to Word in an editable form. I then want t close the report but
not save the changes.
Is there any way or preventing the option to save changes from being
displayed (the answer is always no)
The "DoCmd.Close acReport, me.Name, acSaveNo" on the close event does not
work
TIA
|
by: nick_faye |
last post by:
Hi,
I am still a newbie to VB and using MS Access 2000. I am currently
trying to provide a preview of reports before printing them. My
program is simple:
AC.DoCmd.OpenReport "MyReport", acViewPreview
AC.Visible = True
AC.DoCmd.ShowToolbar "Print Preview", acToolbarNo
AC.DoCmd.ShowToolbar "Menu Bar", acToolbarNo
|
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...
|
by: John Smith |
last post by:
Hello, I am developing a VB.NET 2003 application that will use lots of
Crystal Reports. Sometimes the users will preview a report in a
Crystal report viewer, and sometimes they will send the report directly
to the printer bypassing the Crystal report viewer altogether.
When sending the job directly to the printer I use the PrintToPrinter
command
CR.PrintToPrinter(1, False, 0, 0)
| | |
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...
|
by: sara |
last post by:
I am stuck.
I have a report that I use in multiple places, so I call it with
varying parameters (using the Where Clause in the code).
I preview the report, send it to snap, then close the preview (the
user can go to the server to see the snap view). Print, snap, then
close is the only way I can snap with a Where clause.
If there is No data that meets the criteria, I can cancel the print,
|
by: prakashwadhwani |
last post by:
While making Vouchers in a form, I have a POST button which validates
& posts the transaction to the main Accounts File.
I also have a PRINT button which provides the user with a preview of
the "to be printed" Voucher & then prints it onto paper.
When the user clicks PRINT ... my code validates the voucher & prints
it. Now I have to POST the transaction ... but how do I know if the
voucher has printed correctly ? i.e. no paper jam or...
|
by: scubasteve |
last post by:
Hi,
I'm having issues with AC2007 custom ribbons.
I'm building an AC2007 runtime app which has a custom ribbon (called CommandsDisabledHideRibbon) set as the default db ribbon name (see XML at end of post). The aim is to hide as much of the Access interface as possible.
CommandsDisabledHideRibbon ribbon XML (verified as well-formed by the Office 2007 Custom UI Editor):
<customUI...
|
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...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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...
|
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();...
|
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...
|
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
| | |
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...
| |
