[laratomb13]

I have a simple access database, with a command button for printing out a report. The problem is when I hit the button the whole report is printed when I only want the form I'm looking at to printout. The problem seem's to be with the VB language in the button build but i cant make head nor tail of it. Any help at all will be deeply appreciated.

Thanks too all who reply

Edited by laratomb13, 15 June 2005 - 10:02 AM.

[Advertisements]

can you post the button script here so we can look at it

[peterm]

can you post the button script here so we can look at it

[laratomb13]

Hear you go peterm.

Private Sub Command80_Click()
On Error GoTo Err_Command80_Click

Dim stDocName As String

stDocName = "PC Database"
DoCmd.OpenReport stDocName, acNormal

Exit_Command80_Click:
Exit Sub

Err_Command80_Click:
MsgBox Err.Description
Resume Exit_Command80_Click

End Sub



Thanks for replying any help will be deeply appreciated

Laratomb

[peterm]

ok your command says to open report.not print form.
To make sure you don't wreck anything just go to design mode
add a new button and use the wizard to set print form.
Do you know how to do this?
OR
Access

Edited by peterm, 17 June 2005 - 11:47 AM.

[laratomb13]

hi peterm,
I have already tried what you suggested and it prints out the record i am looking at but in form view (what is on the screen). What I wish to do is print out what i am looking at but in the report view that i have set up. I know that the VB says OpenReport, for the button and it does print out but it will only print out all of the records in the report view i set up. I hope I'm not getting confusing, thanks again for trying. If you come up with anything else I will be willing to try it out.



Thanks

Laratomb

[peterm]

Did you try mk link they are very good

[laratomb13]

I hav'nt tried that, how do you do that?

[peterm]

In my second reply where it says Access and is underlined

[laratomb13]

Thanks a lot peterm i will look at it asap and let you know how i get on

cheers

laratomb