N
Neecer
I have an Access database created for 2000 for multiple users which contains
reports with running totals. One of my users has changed to Access 2003 and
her totals are always showing the number 1. The fields which are set to
Running Sum (Over Group) are hidden in the detail section and there is a
calculated field (=[ErrorCountStaff]) to reference the running sum in the
group footer. The version 2000 databases continue to work fine.
The Access 2003 database is opened via vbscript script file:
Const cDatabaseToOpen = "C:\Path\MyDB.mdb"
On Error Resume Next
Dim AcApp
Set AcApp = CreateObject("Access.Application")
If AcApp.Version >= 10 Then
AcApp.AutomationSecurity = 1 ' msoAutomationSecurityLow
End If
AcApp.Visible = True
AcApp.OpenCurrentDatabase cDatabaseToOpen
If AcApp.CurrentProject.FullName <> "" Then
AcApp.UserControl = True
Else
AcApp.Quit
MsgBox "Failed to open '" & cDatabaseToOpen & "'."
End If
reports with running totals. One of my users has changed to Access 2003 and
her totals are always showing the number 1. The fields which are set to
Running Sum (Over Group) are hidden in the detail section and there is a
calculated field (=[ErrorCountStaff]) to reference the running sum in the
group footer. The version 2000 databases continue to work fine.
The Access 2003 database is opened via vbscript script file:
Const cDatabaseToOpen = "C:\Path\MyDB.mdb"
On Error Resume Next
Dim AcApp
Set AcApp = CreateObject("Access.Application")
If AcApp.Version >= 10 Then
AcApp.AutomationSecurity = 1 ' msoAutomationSecurityLow
End If
AcApp.Visible = True
AcApp.OpenCurrentDatabase cDatabaseToOpen
If AcApp.CurrentProject.FullName <> "" Then
AcApp.UserControl = True
Else
AcApp.Quit
MsgBox "Failed to open '" & cDatabaseToOpen & "'."
End If