asked on Looking for list of DoMenuItem operations
I am working with some old code which is lttered with numerous DoMenuItem instructions such as:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
Can anyone point me to a table or list I could use to quickly determine what operation each of these menu items actually does?
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
Can anyone point me to a table or list I could use to quickly determine what operation each of these menu items actually does?
Microsoft Access
Last Comment
shambalad
in the vba help type domenuitem
from the method shown click on the intrinsic constants.
from the method shown click on the intrinsic constants.
see this link too
http://msdn2.microsoft.com/en-us/library/aa212279.aspx
http://msdn2.microsoft.com/en-us/library/aa212279.aspx
ASKER
Actually what I am looking for is a table/list that would look something like:
Version Menu Option Executes
acMenuVer70 acRecordsMenu 1 ?
acMenuVer70 acRecordsMenu 2 ?
acMenuVer70 acRecordsMenu 3 ?
acMenuVer70 acRecordsMenu 4 ?
acMenuVer70 acRecordsMenu 5 Refresh Record
Version Menu Option Executes
acMenuVer70 acRecordsMenu 1 ?
acMenuVer70 acRecordsMenu 2 ?
acMenuVer70 acRecordsMenu 3 ?
acMenuVer70 acRecordsMenu 4 ?
acMenuVer70 acRecordsMenu 5 Refresh Record
ASKER
The idea being, I would like to have a quick reference so that when I see that someone a line such as:
DoCmd.DoMenuItem acFormBar, acFilesMenu, 2, , acMenuVer70
I can quickly tell what operation they are trying to accomplish.
DoCmd.DoMenuItem acFormBar, acFilesMenu, 2, , acMenuVer70
I can quickly tell what operation they are trying to accomplish.
ASKER
Make that:
The idea being, I would like to have a quick reference so that when I see a line such as:
DoCmd.DoMenuItem acFormBar, acFilesMenu, 2, , acMenuVer70
I can quickly tell what operation they are trying to accomplish
TH
The idea being, I would like to have a quick reference so that when I see a line such as:
DoCmd.DoMenuItem acFormBar, acFilesMenu, 2, , acMenuVer70
I can quickly tell what operation they are trying to accomplish
TH
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
http://home.clara.net/tkwickenden/domenuitem.htm
is just what I was looking for. A lot of good related information on the website too.
Thanks,
TH
is just what I was looking for. A lot of good related information on the website too.
Thanks,
TH
Constant Value
acFirst 2
acGoTo 4
acLast 3
acNewRec 5
acNext 1
acPrevious 0