[AccessD] Re: Printing forms

Robert,

Thanks for the reply.  I'm aware of what forms and reports are used for. 

However, in this instance I need to print a screen-dump of a form. - I'll 
elaborate on the scenario.

On these forms (and there are many of them - mostly inherited from a 
previous version of this app) there are graphs, combo boxes, datasheets 
and drill down sub forms, allowing the user to make multiple (and usually 
quite detailed) selections on the data.  Once those selections are made 
the users (as per the spec and the previous app versions)  would like to 
print a view of the actual form (i.e their selections and however that has 
affected the data/graphs etc) - something which by and large works fine 
except for the items I listed below. (The unbound combo's/radio's etc.) 
The database (by design - out my hands) contains no reports -  only these 
screen prints.

An obviouse work around is to put labels on the offending controls 
(populate them with the required data) and make them visible only when 
printing, but this seems crude if it would work....in fact it does - 
previous versions of this app have shown that. I would just like to know 
if there is a quicker way to do this.  Printing bound controls is fine (in 
fact even unbound controls with a default value set)  - from what I can 
see, it is the unbound ones without defaults that are problematic.

Even if the users/project sponsors were open to reports in this instance 
(which they are not) I just haven't got the time to go and develop the 
number of reports that would duplicate what is on these numerous forms 
(some of which are extremely complex) at this stage of the project. 

So, in summary, what I am hoping for, is info about the the most feasible 
way to achieve this, given the time constraints I have mentioned above. 
(It might be the labels...but I live in hope for a more simple/timely 
solution)

Ryan





"Robert L. Stewart" <rl_stewart at highstream.net>
Sent by: accessd-bounces at databaseadvisors.com
11/03/2004 18:15
Please respond to Access Developers discussion and problem solving 

 
        To:     accessd at databaseadvisors.com
        cc: 
        Subject:        [AccessD] Re: Printing forms


Ryan,

That is because you print reports and not forms.

Forms are for data entry.  Reports are for printing.

Robert

At 11:46 AM 3/11/2004 -0600, you wrote:
>Date: Thu, 11 Mar 2004 17:42:38 +0000
>From: rsmethurst at UK.EY.COM
>Subject: [AccessD] Printing forms
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Message-ID:
> <OFA6C95C1E.4C26A264-ON80256E54.0060D317-80256E54.00618B73 at ey.net>
>Content-Type: text/plain; charset="us-ascii"
>
>Hi All,
>
>I am having a problem printing forms - specifically it is with combo 
boxes
>and radio buttons (usually within frames) which do not print with the
>correct option filled.
>
>i.e two radio buttons and both will print blank, even though the first 
one
>is selected.
>and a combo box with have a selected value, but will not display this
>value when the form prints.
>
>The controls are all set to display for both print and screen, and the
>controls are unbound.
>
>TIA
>
>Ryan


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



 

  
This e-mail and any attachment are confidential and contain proprietary information, some or all of which may be legally privileged.  It is intended solely for the use of the individual or entity to which it is addressed.  If you are not the intended recipient, please notify the author immediately by telephone or by replying to this e-mail, and then delete all copies of the e-mail on your system.  If you are not the intended recipient, you must not use, disclose, distribute, copy, print or rely on this e-mail.

Whilst we have taken reasonable precautions to ensure that this e-mail and any attachment has been checked for viruses, we cannot guarantee that they are virus free and we cannot accept liability for any damage sustained as a result of software viruses.  We would advise that you carry out your own virus checks, especially before opening an attachment.

The UK firm Ernst & Young LLP is a limited liability partnership registered in England and Wales with registered number OC300001 and is a member practice of Ernst & Young Global.  A list of members? names is available for inspection at 1 More London Place, London, SE1 2AF, the firm?s principal place of business and its registered office.