Default Print Settings

MS Office Access


  • 1. After which event is a subform available
    I have a Main Form and a subform. The main form has a combo box - in the after update event it looks up a record on the subform. I would like to make sure the sibform is clear when the main form is opened and when I click on the * to make a new record. I would like to put code in to clear the subform, but I'm not figuring out in which event it should go. In which event should I out the code to clear the subform? Thanks.
  • 2. Events to "Trap" Incomplete Record Creation?
    I have the following scenario that's causing a problem: (1) Joe CluelessUser is adding a new record to a database through a form. (2) He fills in some fields, then gets distracted by something else, with the form and the incomplete (still missing some required fields) new record on his screen. (3) Quitting time rolls around, and Joe C has never completed his new record. He logs off and goes home, and his new record goes into byte heaven because of the missing required data. (4) Two weeks later, Joe C goes looking for his record, finds it ain't there, and beats me up because my database deleted all his hard work. So I want to build in some kind of timer event that will (a) note when someone begins to add a new record, and (b) pop up a modal warning message at some point reminding him that he has to finish the new record if he expects it to be saved. Who can suggest to me what events could be used for this purpose?
  • 3. Continuous Form Combo Box with rowsource based on hidden field.
    I have a combo box on a continuous form. Based on the value of a hidden text box, I need the combo box to display different values since there are different values available for selection based on the city of the record. I have the following query as my rowsource SELECT qrySelectOpenAPPeriods.[Period] & " " & [Year] AS Period, qrySelectOpenAPPeriods.PeriodID FROM qrySelectOpenAPPeriods WHERE (((qrySelectOpenAPPeriods.fldCityCode)=[Forms]![LookupDepositRequestsForSolomon]![fldCity])) ORDER BY qrySelectOpenAPPeriods.Year, qrySelectOpenAPPeriods.Sequence; The combo box is populating. The problem is that when they click on the close button which contains DoCmd.close acForm, a parameter box appears asking for the value of [Forms]![LookupDepositRequestsForSolomon]![fldCity])) . How do I stop this from occuring

Default Print Settings

Postby Chris » Wed, 07 Jan 2004 05:37:49 GMT

Does anyone know of a way to limit the normal "print" 
function from printing all of the forms to just the 
current form?

Basically i have a "check" form that is laid out like a 
check that I print on pre-printed checks.  When I hit 
print, I just want to print the current check, not ALL 


Similar Threads:

1.Default Print Settings are Overridden

We have Office 2003 Pro installed for our users and they all connect to a 
colour printer. The default settings are to print as Black and White but it 
seems that when a user receives a document that has colour in it, the default 
settings are overridden. I have done some tests and it seems that if you 
receive a file that was saved with the printing settings set to print colour, 
then this will override the default print settings of users who are set to 
print black and white as the default. It seems that office documents save 
this meta data somewhere within the document. Is this a correct assumption? 
Also if it is, how can you stop these colour documents overriding the default 
black and white printer settings? It is costing us a fortune in colour print 
cartridges. Please help!

2.default print settings

Hi All,
In an Acces97 application I have a report which in design mode I set
the right/left print margins to 0.5"

The report, for several user now does not print using the default
values that were set in the report but instead, is now printing the
report using the default setting that are set at the PC level(1.5" and
1.5") which messes up the report to an un-readable state because of
warp-around. This just started recently, before the default setting
that I set within design view of the report within Access have always
overrode the default setting at the PC level.
Any ideas of what is going on or what to check?

3.Default print settings


I am using Access 2007 on XPSP2 and an HP Deskjet 6500 printer.

In Control panel the default setting for print quality is FastDraft. 
However, when I print from Access 2007 this is changed to Normal.  Is there 
some way to get Access to use the default printer setting for print quality 
without having to manually set it each time I print?

Bob can I change collate no, on default print settings in access

how can I change collate no, on default print settings in access

5.Set default print preview and Print settings for a Query or Report

How do I set a default print preview and Print settings for a  individual 
Query or Report. 

For instance, I have a specific query. When I click on print preview, I 
would like to have the print preview automatically show the query in 
"Landscape" 8.5 by 14 and be able to print it from there. I can do this 
through page setup, but I have to go through the proceedure each time I open 
the query. The print preview of the Query always opens in "Portrait" 8.5 by 
11 and does not show all the fields.

Please Help,

6. Set default print preview and Print settings for a Query or Re

7. Default zoom setting for print preview of reports??

8. Setting print preview as default in a report

Return to MS Office Access


Who is online

Users browsing this forum: No registered users and 56 guest