Hello,

I have 2 questions, 1 is why I can not see my postings in Firefox browser when I opened it in the my office. Now I am doing this from my home Internet Explorer 8.

The 2nd one is the problem. This is my VBA to open the report:
Private Sub Open_Report_Click()
On Error GoTo Err_Open_Report_Click

Dim stDocName As String

stDocName = "Laporan Buku Anggota Jemaat Kebayoran_Consol"

DoCmd.OpenReport stDocName, acPreview

Exit_Open_Report_Click:
Exit Sub

Err_Open_Report_Click:
MsgBox Err.Description
Resume Exit_Open_Report_Click


End Sub

What is the replacement of acPreview in order to see the in the report view instead of the Print View.

The problem is when I open it in the AC2007, we have to click the report view in order to see the Swich Window, in order to go to filter form. If it is in the Print Preview, we have to click the rerport view at the right bottom toolbar. Users prefer to be able to see the Switch to Windows upper right tool bar.

Thanks for any helps

Frank

Pere,

I have a prolbem, when I chaged it to acViewReport, I tested it works, but when I tried to make an MDE. it can not be made to MDE, and when I compled it the error message says, acViewReport is not defined.

Could you please help, how can we solve the problem. I need to make the MDE.

Thanks to help me again.



Frank