Solved

DoCmd.DoMenuItem A_FORMBAR...

Posted on 2002-05-07
9
412 Views
Last Modified: 2012-05-04
I have converted a DB from access 97 to access 2002 - and now a search form dosnt work. The line of code looks like this:
DoCmd.DoMenuItem A_FORMBAR, A_EDITMENU, 10, , A_MENU_VER20
It opens a search and replace dialog, but is only supposed to open a search dialog.
How do I make it work ?
0
Comment
Question by:RudolfFraDK
9 Comments
 
LVL 2

Author Comment

by:RudolfFraDK
ID: 6993440
Oups - The search dialog is allright, but it doesnt work. Where do I edit it ?
0
 
LVL 2

Author Comment

by:RudolfFraDK
ID: 6993448
What does the line:
DoCmd.DoMenuItem A_FORMBAR, A_EDITMENU, 10, , A_MENU_VER20
mean ?
0
 
LVL 2

Author Comment

by:RudolfFraDK
ID: 6993456
How is this line connected to a table ?
0
 
LVL 2

Author Comment

by:RudolfFraDK
ID: 6993492
How is this line connected to a table ?
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 3

Expert Comment

by:Bob Scriver
ID: 6993531
First of all the command is setup for using ACCESS 2.0

DoCmd.DoMenuItem A_FORMBAR, A_EDITMENU, 10, , A_MENU_VER20

I don't use ACCESS 2000 yet but the A_MENU_VER20 should be changed to reflect the reference to the version of access that you are using.  The parameter list of actions is also different from one version to the next. Place your cursor behind the DoMenuItem and press your F1 key to go to help for this command.  This will assist you in updating the correct version identifier.  

As far as what this command does:  It executes from the Form Menu Bar the Edit DropDown Menu item 10 which back in ACCESS 2.0 was the Search command.  The help screen will assist you in identifying the correct parameter that you want to use.  You do not need to use a number as originally coded but you can select a parameter such as acSearch.

I hope I helped you a little.

Bob Scriver
0
 
LVL 2

Author Comment

by:RudolfFraDK
ID: 7005611
I have tried to place my cursor behind the DoMenuItem and press the F1 key, but I dont understand the options that appear.
The search should end up in a list of hits, but when I press the search button I get an errormessage. - Maybe the problem isnt really migration related - The database is made in an english version of Access 97 but I try to open it in a Danish version og Access 2002 !?
0
 
LVL 2

Author Comment

by:RudolfFraDK
ID: 7087815
Im deleting this question - I have solved the problem by installing access 97 besides access 2002
0
 
LVL 54

Expert Comment

by:nico5038
ID: 7215747


No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in Community Support that this question is:
 - PAQ'd and pts refunded
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
0
 

Accepted Solution

by:
Jgould earned 0 total points
ID: 7240026
Question has been moved to PAQ and points refunded as per recommendation

JGould-EE Moderator
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now