Report total problem

[DimaRiv]

MS Access 2003, ADP disconnected
There is a report with calculations of the sum on some fields. If project connected to data base I haven't problems. But if project. But if the project is not connected also I use Report.recordset as a source of data, there is a problem with calculation of the sum. Instead of number appears #Error or #Name

Dim rs As New ADODB.Recordset

With rs
.CursorLocation = adUseClient
.Open "SELECT * FROM Tbl1", cnt, adOpenStatic, adLockReadOnly, -1
Set .ActiveConnection = Nothing

End With

Set Me.Recordset = rs

What it is possible to undertake to solve a problem?

[puppydogbuddy]

You did not provide much info (you did not provide much of your code). If your code is for the purpose of exporting Access data to Excel, the following link could be relevant.

http://support.microsoft.com/kb/253639/

[DimaRiv]

It is a question of the usual report

[MMcCarthy]

MS Access 2003, ADP disconnected
There is a report with calculations of the sum on some fields. If project connected to data base I haven't problems. But if project. But if the project is not connected also I use Report.recordset as a source of data, there is a problem with calculation of the sum. Instead of number appears #Error or #Name

Dim rs As New ADODB.Recordset

With rs
.CursorLocation = adUseClient
.Open "SELECT * FROM Tbl1", cnt, adOpenStatic, adLockReadOnly, -1
Set .ActiveConnection = Nothing

End With

Set Me.Recordset = rs

What it is possible to undertake to solve a problem?

You cannot transfer a calculated value using recordset. You will have to store the value somewhere maybe in a PUBLIC variable and try to access that instead.