A97, A2000 and A2002

[Doug]

Dear All,

How are you.
I hope your extensive knowledge in Aceess could help me
resolve our Access mysery. Your help is greatly
appreciated.

Regards,
Douglas Li

My Case:
We're in testing phase of upgrading our DB from A97 to
A2002.

All function in DB is working fine in A97.

When the DB(in A97 format) opened in A2002 or 2000, we
received error "The command or action 'SaveRecord' isn't
available now. 2046". I also tried converting the DB to
A2000 and A2002, the error occurs in both format.

 

[RobFMS]

Doug

Can you post the specific line of code that the application is having
trouble executing?


--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Tony Toews]

When the DB(in A97 format) opened in A2002 or 2000, we
received error "The command or action 'SaveRecord' isn't
available now. 2046". I also tried converting the DB to
A2000 and A2002, the error occurs in both format.

From the Access 2.0 and Access 97 to Access 2000/2002 conversion
issues/problems/bugs page at my website

Msg: The command or action 'SaveRecord' isn't available now.
DoCmd.DoMenuItem A_FORMBAR, A_FILE, A_SAVERECORD, , A_MENU_VER20
(This is the Access 2.0 format of the below command.)
or
DoCmd.RunCommand acCmdSaveRecord
by themselves no longer work as if the record doesn't need to be
saved. You can add the following line:
if me.dirty then
before the above lines.

Or just replace the above lines, especially the first one as it takes
a second or two to figure out what's all happening, with
If Me.Dirty = True Then _
Me.Dirty = False
This could fit on one line but I choose not to.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm