Printing report from front end - no menu...

[Pierkes]

Hi,

I have a split database (back end on server and front end on local machines.

this works perfectly. However, i have a printing problem.

I have a form on which the user can specify a few field on which reports are generated. Also, there are a few buttons to open the required report (in printview).

On my system (full access program) i can print the reports when i right-click the report and choose "print"

However, on the local machines (not full access functionality) my people can run the report but it is not possible to right click the report to print it.

any ideas ?
berst regards,
Jean-Pierre

[zmbd]

However, on the local machines (not full access functionality) my people can run the report but it is not possible to right click the report to print it.

What exactly do you mean by "not full..." how are your end users running your front-end.

[Pierkes]

Hi,

the users have a runtime version of ms access.

Does this answer your question?

Regards,
Pierre

[TheSmileyCoder]

Well testing in Access 2010, if I run Access as runtime, and open a report in print preview then yes, I cannot right click to print, but the ribbon is available, allowing me to print.

Maybe there are important details you have forgotten to include in your question?

[Seth Schrock]

@Smiley Are you sure you don't have a custom ribbon on your report? By default runtime disables all the ribbons and only custom ones appear.

What I normally do is open the report in report view and have a print button in the header of the report that has its Display When property get to screen only so that when it prints it doesn't include the button. I have played with custom ribbons, but for some reason I can't get rid of the Adobe ribbon tab so I have opted for the button option.

[TheSmileyCoder]

First off I simulated runtime by the following command:

"C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE" "C:\ExampleRuntime.mdb" /runtime

Note the /runtime

I clearly see the ribbon (non custom) in this clean blank database I created for the purpose. I don't know whether making mdb into a mde first would have any effect. I wanted to attach a screenshot, but seems Bytes have hickups on that account. Keeps saying its not a valid image file...So I have attached as zip. ExamplePrintPreview2010RuntimeSimulated.zip

[TheSmileyCoder]

Well I get the same results with a ACCDB and with a ACCDE using simulated runtime in Access 2010.

[Pierkes]

Hi Seth schrock,

I have no ribbons, you are right about that.

I tried creating a button for the report and it works...but...
It print the report for alll the records in the database and not just the current record.

For your info:

- The report is opened by clicking on a button on a split form (which uses filtered data)
- The report is opened using;

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "rap_One_Page_Summary", acViewPreview, , "[ID_traject] = " & [ID_traject]

I then get the report that i want to print.
Any ideas on the code on the report print button ?

Thanks,
Pierre

[Seth Schrock]

The print button will print all the records that the report has. You have filtered the report when you opened it with the "[ID_traject] = " & [ID_traject]. I'm guessing that the field [ID_traject] is the primary key field. If so, then there can only be one record that matches that criteria. So to print all the records, you would have to remove that criteria.

[Pierkes]

Hi Seth Schrock,

Thanks for your reply but the the thing is that when i press print on my report (which is then in acViewPreview mode, it will print ALL the records. This is not what i want.

I would like the report to print only the record that is filtered, so the current record.

Any ideas ?
Thanks,
Pierre

[Seth Schrock]

Sorry, I misread your previous post. What code are you using to print the report?

[Pierkes]

Hi seth Schrock,

I have tried a few things more, but still have problems...

Here's what i've done:
I have a form on which the user can select a few items from drop down lists. These items will filter the query in the "criterium" section in the qyery.

For example: Ther is a dropdwon list called: Result
The options within it are : Closed;Open;Lost

So the user will select "Closed" for example.
In the criterium section i have:

Like [Forms]![frm_rapporten].[cmb_rap_result] & "*"

This to make sure the query is filtered on the result OR, if nothing is choosen, it wil list all records.

Like the previous combobox, i have a few more on the form.


Here's the code on the form to display the report (by clicking on a button);

DoCmd.OpenReport "rap_pijplijn_per_am_v", acViewReport

It will then display the correct report.

On the report i have a print button button. On the "on click" event i have the following code;

DoCmd.OpenReport "rap_pijplijn_per_am", acViewNormal, , acNormal

It wil print the report, however, without any data.

can you please help ?
Thanks,

Pierre

[Seth Schrock]

In your button's OnClick event replace what you have with

DoCmd.RunCommand acCmdPrint

This will print what is already open.