Form pages

Is it possible to have a two page form and only print the first page or 
second page when needed.?
0
Utf
12/28/2007 1:54:01 PM
access 16762 articles. 3 followers. Follow

3 Replies
784 Views

Similar Articles

[PageSpeed] 16

   Depending on your design, you should be able to use the File/Print dialog 
box
selection to print 1 of 2, or 2 of 2 pages.

   But, forms are made for data entry, and viewing... not printing.  Better
that you develop a rptPageOne and a rptPageTwo and select either for 
printing from your form.
-- 
    hth
    Al Campagna
    Microsoft Access MVP
    http://home.comcast.net/~cccsolutions/index.html

    "Find a job that you love... and you'll never work a day in your life."

"He cries for help" <Hecriesforhelp@discussions.microsoft.com> wrote in
message news:98B65C2D-C5E5-4882-93FF-53E541F3ECC1@microsoft.com...
> Is it possible to have a two page form and only print the first page or
> second page when needed.?



0
Al
12/28/2007 2:33:49 PM
On Fri, 28 Dec 2007 05:54:01 -0800, He cries for help
<Hecriesforhelp@discussions.microsoft.com> wrote:

Printing is best done using a report. You could create two reports,
one for each page.
-Tom.


>Is it possible to have a two page form and only print the first page or 
>second page when needed.?
0
Tom
12/28/2007 2:35:50 PM
I'm not clear what you mean by "a two page form"...

You've already received great advice about using reports, not forms, for 
printed output.

If you are saying that the information you are displaying to your users 
requires them to scroll from one page to another, consider using the tab 
control.  This gives you a way to "stack" pages and gives your users a way 
to click on the tabs to see the different parts.

By the way, how is it that you have two pages worth of fields?  What's the 
underlying table look like?  (hint: it all starts with the data...)

Regards

Jeff Boyce
Microsoft Office/Access MVP


"He cries for help" <Hecriesforhelp@discussions.microsoft.com> wrote in 
message news:98B65C2D-C5E5-4882-93FF-53E541F3ECC1@microsoft.com...
> Is it possible to have a two page form and only print the first page or
> second page when needed.? 


0
Jeff
12/28/2007 3:03:25 PM
Reply:

Similar Artilces:

Updating in a Form with a Query assigned to the Form
I need to know how to make a form updatable when a query is assigned to the form. It tells me that the query needs to be updatable to allow fields to be updated. On Mon, 25 Feb 2008 12:26:01 -0800, Sorting in a Graph <SortinginaGraph@discussions.microsoft.com> wrote: >I need to know how to make a form updatable when a query is assigned to the >form. It tells me that the query needs to be updatable to allow fields to be >updated. A Form cannot make a non-updateable query into an updateable one. You need to fix the Query instead! Perhaps you could post the SQL view of the ...

Why isn't data that is automatically generated in my form showing up in table?
Ok, I've been messing with this problem all day (for those of you who have been following me, I'm so sorry!). But I think I finally figured out the root of my problem. I have created a form that allows users to enter in an employee's clock number using a combo box and it automatically generates the employee's name in a text box next to it by pulling information from the Employee Data table. This data shows up fine in the form view and the datasheet view. However, when I open the table up that this data is being saved to (Weekly Data), the data that has been automatically...

Is it possible to email only one page of an Excel workbook?
I am using a large workbook to create invoices. I would like to be able to email individual invoices, ie. a single sheet of the workbook, but only seem to be able to select the entire workbook. I am using Office 2000 Pro. http://www.rondebruin.nl/ Check out the Sendmail addins -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) -------------------------------...

Print a form crashes Access 2007
I "copied" a form from a pdf, and "pasted" it to a create a form, and added fields to it and it worked fine, until recently. I tried to print it and Access "encounters an error". Since I couldn't figure it out, I recopied the form only from the pdf form and pasted it, creating a new form. I just tried to print the form without adding any fields, and it still "encounters an error" when I try to just print it. Other forms work, and this one used to...what in the world could this be, and how can I fix it. -- djkc55 ...

'Roll Back' new record on form
Hi, I have created a form for transactions with an autonumber field to generate a transactions ID. I have received a request from users of the form to be able to roll back a new record (in the case of data entry error) so that the transaction ID does not commit to the database. They do not want to delete the record as this would generate 'gaps' in the transactions ID sequence eg 1, 2, 3, 5 and so on. Any macro or code that would make this happen? cheers hi Pedro, pedro wrote: > I have created a form for transactions with an autonumber field to generate > a transactio...

page size #2
Please help me with this. I cannot for the life of me get the right margin to be at the 1/2 inch it is set to be. When I print the invoice that I created, it is about an inch wide on the right. I have used the page preview and moved margins and page size around, but to no avail. I am stuck. Thanks in advance, Jeff Hi, Please, no repeat posting on the same day. First, if your data doesn't extend far enough to the right to reach the 1/2 inch margin, it will look like there is a larger margin. A few options - in the spreadsheet widen a few columns of the print area. On th...

Separately named Forms?
In setting up a application where clients master info is to be entered, would/should I have one frmDataEntry and another frmViewClientData, since the frmDataEntry will involve strict Entry but with the frmViewClientData I want to utilize the various methods of SEARCHING for Client data, using ComboBoxes (drop downs) to select client of interest. I've always been confused by this. Can someone clarify to me? TIA, Jim You can use the same form for data entry and viewing/editing data. You can also have 2 separate forms, one for data entry, and one for view/edit the data....

search for multiple records in a form
I have a form that queries a table based on multiple filters, such as Part Number, Part Type, etc. Currently the search code is enabled to search for one part number entered in a text box, and the search results are displayed in a subform. I want to be able to enhance my search functionality by allowing multiple part numbers to be entered into the Part Number search field, and displaying the results in the subform for the records it matches. Please help! Here's the specific code for the search form: Private Sub Search_Click() Const cInvalidDateError As String = "You hav...

re: forms in ACCESS 2007
I just upgraded to ACCESS 2007, and so far have one difficulty. After I create a new form, and test it, it doesn't go true full screen. I can't get it to open without all the top Access menu bar being visible. How can I test it on a true full screen? Ctrl+F1 will minimize the ribbon. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Dave Hubbard" <dave.hubbard@sympatico.ca ( donotspam )> wrote in message news:CD6F99CE-B378-46D9-ADC3-2CA6B...

Forcing Columns to Next Page
I have a huge spreadsheet that I am printing 1 page high by 2 pages wide on 11x17 paper (we have a plotter). I want to force some of the columns to the next page so that they are kept together with the other columns pertaining to that section. Page break seems to be for rows, not columns. Any help would be appreciated. The easiest way that I can see to do this is to go to View-->Page Break Preview. Drag the blue line that indicates the right edge of the page leftward. ******************* ~Anne Troy www.OfficeArticles.com <bratdawg@gilanet.com> wrote in message news:1121207346...

Labels-creating different labels on the SAME page
I would like to print a set of labels, however, I do not want each label to be exactly the same as my sheet of address labels are. I would like to number the labels and print a sheet where each of the 30 labels on the sheet has a different number on it. How do I make each label on one sheet different? Use a mail merge. Numbers instead of addressees. :-) -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "camionneur" <camionneur@discussions.microsoft.com> wrote in message news:B8ECA494-24C7-44DE-...

OL 2007 Forms and not seeing new contacts created for the public G
A few years ago I created a form to be used with Exchange's public GAL. It has and is working OK. I am now running Windows 7 and Outlook 2007 and ran into this problem. When I go to the public GAL and create a new contact using a form I created after it is saved I don't see the contact. If I go to someone elses PC that is running Outlook 2003, I see the contact I just added and yes I have full Admin rights to my PC and the Exchange server. So I was wondering if the form could have something to do with it. If I right click on the GAL public folder and click properties and t...

Publisher splittig page
I would like to know how can I split a page in Publisher. Example: I would like to split page in four equal quarter parts or Example : split top half of page in two quarter and bottom part to look like half page Example : two equal half page Thanks-- Rookie at using publisher I would like to know how can I split a page in Publisher. Example: I would like to split page in four equal quarter parts or If all four quarters are going to be the same select postcard in page setup. Example : split top half of page in two quarter and bottom part to look like half page In Publisher, Arrange, Grid...

Refresh shape properties for all pages
Hi, I have a drawing I created using the Organization Chart wizard...based on a database which contains all the data and Visio maintains a link between the two. That's all fine and works well, but I would like to know if there is a way to update the ENTIRE drawing all at once instead of page by page. In other words, if a change is made in my database, I want to be able to update all the pages, otherwise, I would have to right-click on each page in my document (I have 20) and pick "Refresh Shape Properties." Is there a way to do this for all pages (perhaps using VBA)? Thanks ...

Creat links to pages within the newsletter
How do I create links from the headlines discussed throughout a newsletter. Verses having readers scroll to each topic page by page. You can insert a hyperlink to the top of any other page in your publication and it will survive conversion to a PDF if you are using Pub 2007 and the pdf addin. If you insert a bookmark, and then a hyperlink to that bookmark and convert to a pdf, the link will only take you to the top of that page, and not to the bookmark. To get links to take you to specific bookmarks and thus specific locations on any page, you have to convert your publication t...

How do I print xls file into two separate columns on the page?
I have a 6 column worksheet in excel that I would like to print or display and print in 2 separate columns on each page. Ie: the first printed page would contain the data from pages 1 and 2 of the original document with one set of data to the left and one to the right. The file is a price list of 96 pages and I want to compact it as much as possible. Sub Move_Sets() Dim iSource As Long Dim iTarget As Long iSource =3D 1 iTarget =3D 1 Do Cells(iSource, "A").Resize(50, 6).Cut _ Destination:=3DCells(iTarget, "A") Cells...

When entering data into excel spreadsheet cell, the page just jump
I am trying to add data to an existing worksheet this morning. I can click on the clel, but when I try to enter the data, the worksheet "jumps", am unable to enter any data. What have I done wrong? If you are making entries using the numeric keypad, it sounds like you turned your Num Lock off. Try pressing NUM LOCK (there should be alight that comes on above it when you do) & try again. HTH|:>) "jodj" wrote: > I am trying to add data to an existing worksheet this morning. I can click > on the clel, but when I try to enter the data, the worksheet &qu...

Acces to data base by autonom HTMl page on Access 2007 ?
Hello dear members of the microsoft.public.access newsgroup. I'm a new Access 2007 user and I need your help please. I can get acces to my data base using an autonom HTML form page in Access 2003 . Please, how can I do the same on Access 2007 ? I have neither SharePoint nor Outlook 2007. Thanks Octavio ...

Refresh Page
I have a page (MyMainPage.aspx) containing a button. When this button is clicked; it opens up another page as: window.open ("MyURL.aspx", "My Title", 'toolbar=no, location=no, directories=no, status=yes, menubar=no); MyURL.asp does some processing and then automatically closes itself and returns back to the main page MyMainPage.aspx. What do I need to do so when MyUrL.aspx closed down and returns to MyMainPage.aspx; the page MyMainPage.aspx is refreshed? ...

Customizing home page
Is it possible to customize data display for snippets (such as "Spending by category") that can be placed on the home page? I am talking about customizing what time period and what kind of data is displayed. Zooming in and changing the settings seems to work for some snippets (cash flow forecast, for example), but not for others - it doesnt work for "Spending by category". No matter what I set in details, the snippet on the home page always displays data for the last 30 days. If you know the way to customize it, or know that it is a known problem, please tell me the...

How many tabs are allowed in a Form in CRM
Could someone please tell me, how many tabs are currently allowed witin a CRM form? Thanks 8 "Mon" <Mon@discussions.microsoft.com> wrote in message news:D546731E-834B-4925-B5A6-42958AFE571A@microsoft.com... > Could someone please tell me, how many tabs are currently allowed witin a > CRM > form? > > Thanks ...

get data from main form and update subform
Hi to Everyone I have a mainform with two subform. Mainform has a startdate data. I would like to get this startdate data to my subform which have also a similar date data. Every subfrom and form are different table. Thanks for any idea -- Message posted via http://www.accessmonster.com Hi, this is untested air code: On the subform's After Insert event put code something like this: Me.TheDateControlName = Parent.TheDateControlName Jeanette Cunningham "jfeketet via AccessMonster.com" <u40504@uwe> wrote in message news:8032bac88630d@uwe... > Hi to Everyone &...

Add Unit of Measure Sched on the SOP Blank Options Invoice Form
Add the Unit of Measure (UoM) Schedule ID uniquely per line item in the SOP Blank Options Invoice Form. When you add the Sales Transaction Amounts Work* and the Item Master to the report, and then pull the 'U of M Schedule' from the Item Master, the UoM Schedule ID is duplicating. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-...

Single Front End File with Form that Can by Filtered By User
I’ve got an Expense Report DB that I split into a back-end (tables) and multiple front-ends (for my users). I understand why one needs to split the DB, however because I’ve tailored the switchboard and some other forms to the users (using filters, etc) I now realize I’ve created a maintenance nightmare. These users will not be creating any forms, reports, macros or functions. They will simply be adding or possibly deleting records from the tables via their forms. From what I've experienced, a FE doesn't lock multiple users out if they are only running queries or populating tables. ...

Copy sheet & page settings
Is it possible to copy a sheets data and the page settings in one step? Hi why not copy the complete sheet (right-click on the sheet name and choose 'move/copy') >-----Original Message----- >Is it possible to copy a sheets data and the page >settings in one step? >. > ...