I have just been asked to port an Access 97 app from an old Pentium 3
to a new Pentium Core-2-Duo PC.
On the new PC, Office 2003 is installed. On opening the database,
Access provided me with an option to convert the database which I did.
However, there are a couple of small issues. For one, there were a
couple of conversion errors which it stored in a conversion errors
table (saying it could not find the field "description").
Secondly, and this is my main problem ...
When I click on a button in the old Acc97 app it used to work fine,
however in Acc2003 it says "The command or action 'SaveRecord' isn't
available now". Here is the sub where it occurs:
Private Sub Cash_RV_Preview_Click()
On Error GoTo Err_Cash_RV_Preview_Click
[RVHAMT] = [Receipt Voucher Sub Form].[Form]![PAYABLE AMT]
[RVHDIS] = [Receipt Voucher Sub Form].[Form]![TOTAL DISCOUNT]
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ,
acMenuVer70
Dim stDocName As String
stDocName = "Receipt Voucher Printing Cash"
DoCmd.OpenReport stDocName, acPreview
Exit_Cash_RV_Preview_Click:
Exit Sub
Err_Cash_RV_Preview_Click:
MsgBox Err.Description
Resume Exit_Cash_RV_Preview_Click
End Sub
On checking the Menu Bar I saw the action "Save Record Shift+Enter"
is grayed out & not available in the Acc2003 app. However, when
checking it under Access 97 on the other PC, the option Save Record is
available.
Could someone please throw some light on this & guide me as to how to
proceed further with such errors ?
Thx & Best Rgds,
Prakash