If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Printing data from a form
Is there a way of printing required data out from a form.
I have 3 forms with data for 3 different locations, and I would like to be able to print the records from the form as required. I have tried googling for an answer to this but can't find anything as yet. Thanks |
#2
|
|||
|
|||
Printing data from a form
Bob H wrote:
Is there a way of printing required data out from a form. I have 3 forms with data for 3 different locations, and I would like to be able to print the records from the form as required. I have tried googling for an answer to this but can't find anything as yet. Thanks Update here, I added a cmd button to print the current form, but it selected ALL 592 record records to print. What I should have said before is that I have a combo box which selects different types of data, and it is that type of data or those records only that I wish to print. So if I select Type A, I want to print Type A records If I sect Type B, I want to print Type B records etc. Is there a way this can be done. Thanks |
#3
|
|||
|
|||
Printing data from a form
On Sat, 06 Feb 2010 18:05:17 +0000, Bob H wrote:
Is there a way of printing required data out from a form. I have 3 forms with data for 3 different locations, and I would like to be able to print the records from the form as required. I have tried googling for an answer to this but can't find anything as yet. Thanks One conceptual shift needed he The data is NOT in your Form. Forms are just windows, tools to manage data stored in Tables. The data is in one or more Tables; the forms are just how you manage the data. To print the data out, create a Report based on a query pulling data from the tables. By "different locations" - do you mean different records in a table? different tables? different databases? different computers? different cities? or what? -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Printing data from a form
Hi Bob,
You don't say which version of Access you are using, but, I have used the display form to print out data for many years. I know the proper SOP for printing out data is a report, but, printing a display form as a report is quick and easy as well. So that my very esteemed friends here don't tar and feather me for Access heresybig grin, I am not advocating using forms as reports as the norm. But, there are times when it works as well. What I do is put a small command button on the display form that the user can click to print out the specific data they have selected from the filter form. The type of filter form that I use has combo boxes to select the data criteria and a corresponding command button that will sort the data according to the criteria in the combo box, open the display form and display the records. Once I am satisfied that the data displayed on the form is what I need, then I click the command button and print out the form with the data. The command button is simple to add: I put it in the Header section of the Form, just because it is easy to see there. Click on the command button icon on the ribbon/toolbarclick on the area of the form where you want to put the buttonselect Form operations in the left windowSelect print current form in the right windowclick Next(I use the printer image)click NextI type in PrintForm for the button nameclick Finish. I also use a From-To date filter on the filter form so that I can sort the records by specific date periods (week, month, year, etc.) In Access 2007 you can also print a display form as a report by clicking the Office Orb at the top of the windowclick Printclick Print Preview. Make sure the margins and orientation are as you need for the paper size, and the layout and information are correct, and then click on the Print icon on the far left side of the ribbon. (I believe in the prior versions there was a function like "Print Form as Report" that you could select to print the form as a report, but, I have not used the 2003 or older in some time, so I may be incorrect on that.) You will need to sort/filter by specific criteria in order to display and print only that specific data in the form. HTH Jan "Bob H" wrote in message ... Is there a way of printing required data out from a form. I have 3 forms with data for 3 different locations, and I would like to be able to print the records from the form as required. I have tried googling for an answer to this but can't find anything as yet. Thanks |
#5
|
|||
|
|||
Printing data from a form
John W. Vinson wrote:
On Sat, 06 Feb 2010 18:05:17 +0000, Bob H wrote: Is there a way of printing required data out from a form. I have 3 forms with data for 3 different locations, and I would like to be able to print the records from the form as required. I have tried googling for an answer to this but can't find anything as yet. Thanks One conceptual shift needed he The data is NOT in your Form. Forms are just windows, tools to manage data stored in Tables. The data is in one or more Tables; the forms are just how you manage the data. To print the data out, create a Report based on a query pulling data from the tables. By "different locations" - do you mean different records in a table? different tables? different databases? different computers? different cities? or what? I know the data is not on the form, but more so the table(s), but I thought that there might be some way of printing the data from the table por query through the form. By different locations, I mean that the 4500 odd tools in the database are in 4 different locations in the UK. I have 4 querries, one for each location which are used for the form in from a combo box, wher I can change the location as required. Thanks |
#6
|
|||
|
|||
Printing data from a form
On Sun, 07 Feb 2010 12:26:26 +0000, Bob H wrote:
I know the data is not on the form, but more so the table(s), but I thought that there might be some way of printing the data from the table por query through the form. There is. It's called a Report, and it's a standard tool in Access. You can base the Report on a Query referencing a control on your form as a criterion, and you can put a command button on the Form to launch the report. By different locations, I mean that the 4500 odd tools in the database are in 4 different locations in the UK. I have 4 querries, one for each location which are used for the form in from a combo box, wher I can change the location as required. Only one query is needed, if you use =[Forms]![YourForm]![LocationComboBox] as a criterion, rather than "London" or "Manchester". If I'm misreading and misunderstanding your post please post a clarification. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|