Replacing DoMenuItem

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
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

converting DoMenuItem to RunCommand 1
Duplicate a Recordset 4
DoMenuItem or RunCommand? 5
Newbi needs a very small help, thank you very much. 0
Newbi needs a very small help, thank you very much. 1
I think I have been hijacked. 3
Living With a Computer 3
History of Xbox 360 defects - Dean Takahashi has the inside story(long) 2

Top