Hi Allen ! Thx for such a swift response.
1) Your solution: If Me.Dirty Then Me.Dirty = False worked
absolutely fine !!
2) RVHAMT and RVHDIS are hidden controls on the form. The Record
Source of the Form is a Query which is based on 4 tables.
3) The conversion errors table consists of the foll:
----------------- -------------------
-----------------------
Object Type Object Name Error Description
----------------- -------------------
-----------------------
Table MSysObjects -1017: Could not find field
'Description'.
I have checked all the 50 tables & there seems to be no field with the
name "Description". However, there is one table having a field called
"Desc". Perhaps that was renamed by someone along the way ? I guess
you'll have a much better understanding of this.
I hope I'm ok so far, or is there anything else I need to worry
about ?
This app belongs to a Video Library so I'll make this change (Dirty)
in place of the Save Action and see how things progress. If any
further errors crop up beyond my reach, I'll post them here.
In the meanwhile if you feel I need to watch out for anything based on
the information I've given, please do let me know.
Thx & Best Rgds,
Prakash.
On Sep 8, 8:20*pm, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
Quote:
If there is no field named 'description', this is a form of corruption. Try
a compact/repair of the old database in Access 97. If that doesn't work, try
creating a new (blank) database, and importing everything.
>
In place of the SaveRecord line, try:
* * If Me.Dirty Then Me.Dirty = False
That should work in both versions.
If it doesn't what are RVHAMT and RVHDIS? If they are fields in the form's
RecordSource but not text boxes on the form, create text boxes for them and
see if that solves the problem. (Visible = No if you don't want to see
them.)
>
--
Allen Browne - Microsoft MVP. *Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
>
<prakashwadhw...@gmail.comwrote in message
>
news:89887b93-d88a-4660-9c56-c88229e37b76@k7g2000hsd.googlegroups.com...
>
Quote:
I have just been asked to port an Access 97 app from an old Pentium 3
to a new Pentium Core-2-Duo PC.
>
Quote:
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.
>
Quote:
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").
>
Quote:
Secondly, and this is my main problem ...
>
Quote:
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:
>
Quote:
Private Sub Cash_RV_Preview_Click()
On Error GoTo Err_Cash_RV_Preview_Click
>
Quote:
* *[RVHAMT] = [Receipt Voucher Sub Form].[Form]![PAYABLE AMT]
* *[RVHDIS] = [Receipt Voucher Sub Form].[Form]![TOTAL DISCOUNT]
>
Quote:
* *DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ,
acMenuVer70
>
Quote:
* *Dim stDocName As String
>
Quote:
* *stDocName = "Receipt Voucher Printing Cash"
* *DoCmd.OpenReport stDocName, acPreview
>
Quote:
Exit_Cash_RV_Preview_Click:
* *Exit Sub
>
Quote:
Err_Cash_RV_Preview_Click:
* *MsgBox Err.Description
* *Resume Exit_Cash_RV_Preview_Click
>
>
Quote:
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.
>
Quote:
Could someone please throw some light on this & guide me as to how to
proceed further with such errors ?
>
Quote:
Thx & Best Rgds,
Prakash
