Solved

Could Not Find Field Error in Access

Posted on 2014-09-12
4
273 Views
Last Modified: 2016-06-23
Hi, I am using Access 2010 to link to a SharePoint 2013 list and manage the list, say, Employees list. My issue is, on my Access form, I get the "Could not find field." error when I update some of my form field data. Strangely enough, it only affects some, but not all, records on the list and affects all form controls except text boxes.

Can anyone help?

Thanks,

gbaguhin
0
Comment
Question by:gbaguhin
  • 2
4 Comments
 
LVL 31

Expert Comment

by:Jamie McAllister MVP
ID: 40319755
Is there any way for you to grab a copy of Access 2013 and see if the problem still occurs?
0
 

Author Comment

by:gbaguhin
ID: 40320065
Jamie,

Thanks for the suggestion. I will do that and let you know.
0
 

Accepted Solution

by:
gbaguhin earned 0 total points
ID: 40328351
Hi All,

I think I found the problem for this issue. What was causing the error was a phone text field which was limited to 20 characters which was insufficient in some records. Why would such field-size overflow throw up an error?

Well, I just discovered by digging in deeper that in the background there was a running SharePoint workflow that was designed to populate the phone field automatically every time a new record was created by looking up an Employee table. The overflow caused a failure in the workflow to update this field so it in essence locked this record and caused the error described above.

I simply bumped up the field-size limit to 100 chars and the problem went away.

Thank you for your suggestion Jamie.
0
 
LVL 26

Expert Comment

by:MacroShadow
ID: 41668922
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: gbaguhin (https:#a40328351)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

MacroShadow
Experts-Exchange Cleanup Volunteer
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

706 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

20 Experts available now in Live!

Get 1:1 Help Now