Access Vba #name Error
Contents |
help? Post your question and get tips & solutions from a community of 418,417 IT Pros & Developers. It's quick & easy. #Name? error message in Access Form P: 3 jkriner #Name? error message in Access Form -------------------------------------------------------------------------------- Hello I have created a simple database with #name? access form 4 tables (all the same fields in each table). I then created a form and copied it #name access text box 3 times (renaming the forms according to the table names). I changed the recource source in each form to reflect the corresponding table but now in some
#name Access 2013
of the fields (in the copied forms) I am getting a #Name? message in a couple of the fields. Any help would be great... thanks :) Jul 26 '07 #1 Post Reply Share this Question 4 Replies Expert Mod 10K+ P: 12,110 Rabbit
Ms Access #name In Report
It probably means your field names from your record source don't match up with the control source property of the controls on the form. Jul 26 '07 #2 reply P: 3 jkriner ok, I just copied the original form (ie. table09 goes with form09 and then I copied form09 3 times and renamed them form10, form 11, form12...there is data in each of the tables (table 9, table10, table11, table12) that shows up in the corresponding forms, but how do I get the fields to match up? #error access I am somewhat clueless (as you can tell) when creating anything in access and that is why I copied the form three times so I wouldn't have to redesign it each time) thanks so much Jul 26 '07 #3 reply Expert 100+ P: 1,206 JKing First I suggest checking the record source for each form. Open up the form properties and make sure you have the right table set for each form. For example Form9 should be set as table9, form10 set as table10. Once this is done open the properties for any textboxes that are giving you a #name error. There is drop down for the control source property. Select the proper field name from the list. This should get rid of any errors you have. Jul 26 '07 #4 reply Expert Mod 10K+ P: 12,110 Rabbit If the tables have different field names, then the controls on the form that reference those field names will be wrong because they're using the field names from the original form. You have to change the control source property of the control to reflect the field names in the table. Jul 26 '07 #5 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Similar topics Drag and Drop File Name from Windows Explorer into Access Form Textbox Custom Error Messages SOAP (access multiple
Tech Support Guy, we highly recommend that you visit our Guide for New Members. Solved: #Name? Error in access 2007 Discussion in 'Business Applications' started by obatusai, Nov 13, 2008. Thread Status: Not open for further replies. Page 1 of 2 1 2 Next > Advertisement obatusai
Access Control Source #name?
Thread Starter Joined: Nov 7, 2008 Messages: 19 Can some one help me, I'm geting this error #name error in excel 2010 in my DB showing this error in some fields that show data stored on tables. how can I correct this? obatusai, Nov 13, 2008 #1 Sponsor #type access OBP Trusted Advisor Joined: Mar 8, 2005 Messages: 19,065 Check your Field Names on your Forms OBP, Nov 13, 2008 #2 obatusai Thread Starter Joined: Nov 7, 2008 Messages: 19 they seem to be fine! they match the names from the tables https://bytes.com/topic/access/answers/683767-name-error-message-access-form they feed. What do you mean by that? obatusai, Nov 13, 2008 #3 OBP Trusted Advisor Joined: Mar 8, 2005 Messages: 19,065 This error usually occurs when the Field Name in the Form's Field's Record Source Property does not match that of the Table or query providing the data. Have you checked the Form's "Field List"? If you can post a zipped copy of the database in Access 2003 version by converting it, we can look at it for you. Or post screenshots of the Table in https://forums.techguy.org/threads/solved-name-error-in-access-2007.769023/ design mode and the Form with a Field with the problem in design mode. OBP, Nov 14, 2008 #4 OBP Trusted Advisor Joined: Mar 8, 2005 Messages: 19,065 I can't see anything attached to your last post. OBP, Nov 14, 2008 #5 obatusai Thread Starter Joined: Nov 7, 2008 Messages: 19 I'm trying to copy boths the screens and the DB but I don't know how. copy paste won't work obatusai, Nov 14, 2008 #6 OBP Trusted Advisor Joined: Mar 8, 2005 Messages: 19,065 If you have the Table in design view, use the keyboard fn + Print Screen (prt sc) or Ctrl + Printscreen, that will put a copy of you table design in the Clipboard. You can then open a blank Excel Worksheet and Paste the "Image" in to it. Now open the Form in design view and click on a Filed that has the #name problem, make sure the the Properties are showing and then use the Prontscreen to capture the image and paste that in the Excel Sheet as well. Use the "Go Advanced" and "Manage Attachments" Buttons to post the Excel sheet as an Attachmnent. OBP, Nov 14, 2008 #7 obatusai Thread Starter Joined: Nov 7, 2008 Messages: 19 here is the DB, it won't look the same because of the different versions Attached Files: BVELdatabase w users.zip File size: 334.8 KB Views: 814 obatusai, Nov 14, 2008 #8 OBP Trusted Advisor Joined: Mar 8, 2005 Messages: 19,065 OK, which form has the problem? OBP, Nov 14, 2008 #9 obatusai Th
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 29 Sep 2016 17:09:00 GMT by s_hv972 (squid/3.5.20)