Access 2007 Report Failure

[jneseth]

Our orginization is slowly changing over to office 2007, and with that an
Access application that was completed in Access 2003. Now, now of the
reports will open in the 2007 version, and in fact causes an error and shuts
down the application. Even if I try to create a new report from scratch, the
moment that I hit the report button, the application crashes.

Thanks for your help!

 

[Allen Browne]

John, tell us more about this issue.

Just one particular report? Or any report?

If this is on a different computer, is there a printer installed? Access
uses the printer driver to calculate the report layout and can't figure it
out if the printer driver is not present, or is invalid/flawed.

Have you applied the service pack released last week for Office 2007:
http://office.microsoft.com/search/redir.aspx?AssetID=DC102486291033&Origin=HH102511011033&CTT=5

Have you tried a compact/repair?

 

[jneseth]

Any/Every report causes a crash of the application. Even trying to create a
new report from scratch causes an application crash (just be pressing on the
report button). There is a default printer installed on the system (it is a
different system) than the one running Access 2003

Again, thanks for all of your help!

 

[jneseth]

It was the printer driver... When I changed the default printer to a more
generic printer (I have many different printes available to me on our
network), everyting worked as expected. The bigger question, (one not to be
answered in this forum) is why some default printer(s) that Windows reconizes
do not work for all of their applications.

Thanks for sending me down a path that fixed an issue, although brings up
some larger questions!

 

[George Nicholson]

You might try deleting the problematic printer and reinstalling. Access
*might* like it better then. It certainly won't like it any worse.

Check for an updated printer driver as well...

 

[JohnClingeleffer]

Our orginization is slowly changing over to office 2007, and with that an
Access application that was completed in Access 2003. Now, now of the
reports will open in the 2007 version, and in fact causes an error and shuts
down the application. Even if I try to create a new report from scratch, the
moment that I hit the report button, the application crashes.

Thanks for your help!

I have an application with versions in Access 2003 and 2007.

The following works well for us.

Public Function getReportPreviewFormat()
'generic function to return acViewPreview for Access 2003 and lower
'and acViewReport for Access 2007 and higher
'as dynamically generated report content such as custom headings
'does not work properly under Access 2007 using acViewPreview

'INSTRUCTIONS
'insert this function into a standard module and then replace all instances
of
'DoCmd.OpenReport ReportName, acViewPreview
'with
'DoCmd.OpenReport ReportName, getReportPreviewFormat()

'where ReportName is the name of the report being opened

'John Clingeleffer 18 December 2007

On Error GoTo errHandler
accessVersion = SysCmd(acSysCmdAccessVer)
If accessVersion <= 11 Then 'Access 2003 or lower
getReportPreviewFormat = 2 'acViewPreview
Else 'Access 2007 or higher
getReportPreviewFormat = 5 'acViewReport
End If

Exit Function

errHandler:
getReportPreviewFormat = 2 'default to acViewPreview on any error condition
Exit Function
End Function

 

[Allen Browne]

John, did you realize the A2007 crash bug you are avoiding here was fixed
when MS released SP1 for Office 2007 last week?

Additionally, report view is quite a diffferent beast. Events don't fire at
all. Concept of a "page is different". Searchable, etc.

 

[Julie Walraven]

--
Julie

John, did you realize the A2007 crash bug you are avoiding here was fixed
when MS released SP1 for Office 2007 last week?

Additionally, report view is quite a diffferent beast. Events don't fire at
all. Concept of a "page is different". Searchable, etc.