By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,463 Members | 774 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,463 IT Pros & Developers. It's quick & easy.

Report total problem

P: 2
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?
May 7 '07 #1
Share this Question
Share on Google+
3 Replies


puppydogbuddy
Expert 100+
P: 1,923
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/
May 7 '07 #2

P: 2
It is a question of the usual report
May 7 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
May 7 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.