Replacing DoMenuItem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have inherited an access db with about 70-80 lines of code invoking the
archaic DoMenuItem command. Is it worth my time, from a performance
perspective, to update this code using the newer VBA commands? Most of the
code is for refreshing combo boxes, saving records, and selecting/deleting
records.

Also is the following correct:
AcRecordsMenu, 5, ,acMenuVer70 Replaced by: Me.Object_Name.Requery

AcEditMenu, 8, ,acMenuVer70 and
AcEditMenu, 6, ,acMenuVer70
replaced by: RunCommand acCmdDeleteRecord
 
If it's working fine, and requires little maintenance in the future, it's
probably not worth your time sorting it all out.

Conversely, if the database needs maintenance now, or will need maintenance
in the future, and that maintenance involves the routines where the
DoMenuItem occurs, it may be worth your time to sort it out so that the code
is more readable and easier to maintain.

Performance is not an issue here. Maintainability is king.
 
Back
Top