#name Error On Subform
Custom Search UtterAccess Forums>Microsoft® Access>Access Forms Subform #name? Error Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code Archive|-- Access Knowledgebase / FAQ|-- Access TutorialsMicrosoft® Access|-- Local Access User Groups (AUGs)|-- Interface Design|-- Access Q and A|-- Access Tables + Relationships|-- Access Queries|-- Access Forms|-- Access Reports|-- Access Macros|-- Access Modules|-- Access Date + Time|-- Access Errors + Error Handling|-- Access Built-in Functions|-- Access Searching + Data Mining|-- Access Records|-- Access Security|-- Access Automation|-- Access Database Container|-- Tool bars, Menu bars + Ribbon|-- Access Services (Web Databases)|-- Access Data Access Pages (Deprecated)|-- Access Data Projects - ADP|-- Access Runtime, Packaging & DeploymentAnd More...|-- Microsoft SQL Server|-- SQL Server Reporting Services|-- Microsoft SharePoint|-- Microsoft Internet Explorer|-- Visual Basic 6 and Earlier|-- Visual Basic 2003 and Later|-- ASP and VBScript|-- Web Development|-- PHP, Perl, MySQL and Postgres|-- Other Database Engines|-- BI Tools and Applications|-- JAVA and C#|-- GraphicsMicrosoft® Office|-- Microsoft Excel|-- Microsoft Excel FAQs|-- Microsoft Word|-- Microsoft Outlook|-- Microsoft PowerPoint|-- Microsoft FrontPage/Exp. Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|-- Q & A - UtterAccess.com Forums|-- Q & A - Access Wiki Options sforney123View Member Profile Jun 2 2011, 08:34 AM Post#1Posts: 90Joined: 22-March 11I need help because this doesn't make any sense. I have two VBA commands which are exactly the same. One opens a form called Park_Sub and fills in the fields perfectly fine. The other opens a form called Gate_Sub and opens the fields on the form with a #Name? error. I don't understand...below is my code. Both the tables that are linked to my forms are blank. This one gives me the #Name? error:Private Sub EditRestrict_Click()DoCmd.OpenForm "Gate_Sub", acNormal, "", "[GateRestrict].[Airport Code]=[Forms].[Gate Entry].[Airport Code] And [GateRestrict].[Gate ID]=[Forms].[Gate Entry].[Gate I
Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rate Thread Display Modes 11-18-2011, 06:34 AM #1 sandracwalsh Newly Registered User Join Date: Nov 2011 Posts: 4 Thanks: 1 Thanked 0 Times in 0 Posts #Name error when refernecing a sub-form field Hello - I am going crazy trying to sort out what should be a very straightforward reference to a field http://www.utteraccess.com/forum/Subform-name-Error-t1968032.html on a sub-form. There is an error in the WHERE clause of my query but I can't figure it out. The hierarchy of my data is as follows: Trips -> Activities -> Contacts I have a main form called f_MainTripForm. On this Main form I have a sub-form called f_ActivityDetails where the user selects the Company they are visiting from a drop-down http://www.access-programmers.co.uk/forums/showthread.php?t=218399 named Company_DD with a control source of Company_Listing_ID The f_ActivityDetails sub-form has a tab control in which I have a sub-sub form named f_OtherFirmContacts on one of the pages f_MainTripForm -> f_ActivityDetails joined on Trip_ID ->-> f_OtherFirmContacts joined on Activity_ID In f_OtherFirmContacts I have a dropdown named SelectContact_DD that should select only the contacts that have a Company_ID = to the Listing_ID stored in the Company_DD drop-down in f_ActivityDetails. I have this code for the SelectContact_DD drop down: SELECT q_ContactsAtACompany.Cont_LISTING_ID, q_ContactsAtACompany.DISPLAY_NM, q_ContactsAtACompany.POSITION_NM, q_ContactsAtACompany.COMPANY_ID FROM q_ContactsAtACompany WHERE (((q_ContactsAtACompany.COMPANY_ID)=[Forms]![f_MainTripForm]![f_ActivityDetails].[Form]![Company_DD])) ORDER BY q_ContactsAtACompany.DISPLAY_NM; When I open the form, I get a request to Enter Parameter Value. When I create an unbound field in f_Contacts with the Control Source =[Forms]![f_MainTripForm]![f_ActivityDetails].[Form]![Company_DD] I get a #Name error. When I manually enter the COMPANY_ID in the Parameter Value request, all works fine. Thanks for any suggestions - I am sure it is something simple to do with the syntax of the WHERE clause. Sandra Last edited by sandracwalsh; 11-18-2011 at 06:48 AM. sandracwalsh View Public Profile Find More Posts by sandracwalsh 11-18-2011, 07:25 AM #2 vbaIne
One games Xbox 360 games PC https://support.microsoft.com/en-us/kb/113352 games Windows games Windows phone games Entertainment All http://stackoverflow.com/questions/9459474/ms-access-subform-with-fields-with-error-in-form-view Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security #name error Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Band Microsoft #name error on Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up MS Access Subform with fields with #Error in form view up vote 0 down vote favorite MS Access 2003. I have a query behind a subform that has a sql statement like this: SELECT ClientTotalInvoiceLineItems.*, CDate(GetWeekEnding([WeekEnding1],[WeekEnding2],[WeekEnding3],[WeekEnding4],[WeekEnding5],[WeekEnding6])) AS WeekEnding, CapturedInvoices.EnteredInvoiceNo, IIf([forms]![frmClientTotalInvoices]![frmClientTotalInvoicesSub].[Form].[NewRecord]=True,0,Ccur([ContractingFeesSubtotal])) AS Subtotal, CCur([GSTAmount]) AS GST, CCur([TotalDue]) AS Total, IIf(IsNull([ctlCreated]),'',[ctlCreated] & ' by ' & [ctlCreatedBy]) AS Added FROM ClientTotalInvoiceLineItems INNER JOIN CapturedInvoices ON ClientTotalInvoiceLineItems.ctlSourceID = CapturedInvoices.CapturedInvoicedID ORDER BY CDate(GetWeekEnding([WeekEnding1],[WeekEnding2],[WeekEnding3],[WeekEnding4],[WeekEnding5],[WeekEnding6])) DESC; When the form is on a new record I get #error in the fields starting with ccur. So as you can see I tried to put a Form.NewRecord expression on field to test it but now MSAccess crashes when I try view in form view. How can I get rid of those #error in the fields on a new record of a subform?? Malcolm ms-access share|improve this question asked Feb 27 '12 at 2:52 Malcolm 3,3672073112 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote There are a few methods of handling this, but one method is to have the record source of the subform initially empty, and then fill in the record source on the after insert event of the main form. share|improve this answer answered Feb 27 '12 at 2:59 YogoZuno 335519 Its not until i click in the subform and start to enter data that i get this #error. Which confuses my users? OF course those ccur fields are display only not data enter fie