Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Forums > Access
Back to Access Forum    Comments List
No Such Field in Field List Upload Images   Link   Email  
Amanda McDonald       
2 months ago
One of my controls is getting the "No Such Field in Field List" error however, the data is populating fine on the form.

The record source is a query.
The field is in the query.
The field is in the table used to make the query.
The field is an option in the control source drop-down menu for the control.

I have tried:

- Checking spelling, it is spelled correctly.
- Deleting the query from the record source of the form, saving it, re-opening the form, and adding the query back as the record source, but the control still has the error.
- Deleting the field from the query, saving the query, re-opening the query, and adding the field back to the query but the control still has the error.
- Deleting the control and adding a new control, but once I select the field as the control source I get the error again.
- I created a new form with the wizard and it added all the fields except the field with the error. When I added a control and selected the field for the control source I got the error.
- I created a completely new query and a completely new form and I got the error.
- Debug> Compile found no errors.
- Ran Compact & Repair on the front-end and back-end of the database. The error is still there.

Even though there is an error, right now the field is populating the correct data on the form.
I'm tempted to just ignore it...however, I don't want to have issues with the data in the future

I have Googled and tried ChatGPT and all I can find is that "the field doesn't exist"...but it does exist...and it is populating data...I don't know where to go from here. Any help would be very much appreciated.
Amanda McDonald       
2 months ago

Amanda McDonald       
2 months ago

John Davy           
2 months ago
Hi Amanda

If it is not confidential and you want to send the app to me, I will take a look at it.

John

[email protected]

Sami Shamma             
2 months ago
Amanda
Your troubleshooting skills are very good.
Try the following, just in case there's a problem with the way this field was initially created:
Create a new field on the same table call it TileCleaning2 Then add that to the form and the query.

If this works, simply write an update, query to move the data from the original field to the new field.
Amanda McDonald       
45 days ago
I had some time this afternoon so I went into the query SQL and found the problem. There was a space at the end of the field on the table. (Palm to forehead.) I removed the space on the table and replaced the field in the query and the error is gone! I am a bit embarrassed that I didn't catch this before I posted it. Perhaps this will help someone else in the future. I would never have solved this on my own without looking at the SQL. Lesson learned, check the SQL first!
I appreciate you all taking a look at this.
Amanda McDonald       
45 days ago

John Davy           
44 days ago
Hi Amanda
As Sami said "Your troubleshooting skills are very good"  Congratulations!  John
Amanda McDonald       
42 days ago
Thanks, Sami & John, I try. I came from working with basic Excel spreadsheets to Access and have only used it for a couple of years. There was a big learning curve starting with VBA and now onto SQL but I finally feel like I've got a handle on it. I feel like I've only scratched the surface of what it can do. I would not have been able to create our company's database without Richard's videos, templates, seminars, and help from you guys here at the forums. Thank you!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 4/15/2024 8:35:50 AM. PLT: 0s
xxx