Printing data from a form

[Bob H]

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

 

[Bob H]

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

 

[John W. Vinson]

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 here:

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?

 

[Jan :\)]

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 heresy<big 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/toolbar>click on the area of the form where you want to put the button>select Form operations in the left window>Select print current form in the right window>click Next>(I use the printer image)>click Next<I type in PrintForm for the button name>click 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 window>click Print>click 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]

One conceptual shift needed here:

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

 

[John W. Vinson]

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.