Learn how to a build a cloud-first strategyRegister Now


Access 2007 runtime error 2142

Posted on 2011-10-12
Medium Priority
Last Modified: 2012-05-12
I have an app with a list box lst_ProjNames. On AfterUpdate of the list box I set focus to another control:


and search for a record:

DoCmd.FindRecord Me.lst_ProjNames.Column(0)

This works as expected on my development workstation. However, when a user tries to perform a lookup - using identical data on a network share and an identical copy of the app on his workstation - on AfterUpdate of lst_ProjNames he gets Runtime Error 2141 (The FindRecord action requires a Find What argument...).  I have verified that the value returned by Me.lst_ProjNames.Column(0) is correct and valid, and identical to the value returned in my copy of the app on my workstation.

I'm stumped - why the error on the user's workstation?? Any suggestions would be appreciated.

Question by:dgmoore1
  • 2
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 36958053
check the copy of the app on the user workstation.
make sure that there is no "MISSING" references.

Author Comment

ID: 36958615
I'll check first thing tomorrow morning. Thanks for the tip

Author Closing Comment

ID: 36968389
This was the issue - I have Office 14 and my users have Office 12. Changing the reference fixes the problem.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

810 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