Access Runtime Error 2467
Contents |
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 02-02-2006, 12:06 PM #1 microsoft visual basic run time error 2467 amirbilal Registered User Join Date: Dec 2005 Posts: 9 Thanks: 0 Thanked 0 runtime error 2465 Times in 0 Posts Run-time error '2467': I have an application which I did in 2003 version and then converted it for runtime error 2424 2002 version. Everything works fine in 2003 but when I open in Access XP 2002 version then I get the following error. Run-time error '2467': The expression you entered refers to an object that is closed
Runtime Error 2467 Ms Access
or doesn't exist. I debuged the application and found the following cause. I have two forms 'ManageCustomers' and 'AvailableIDs'. AvailableIDs is as subform of ManageCustomers and set to unbound. Now in VBA of ManageCustomers I am doing the following: Form_AvailableIDs.RecordSource = someSource This statement is producing the above described error. It works fine in Access 2003 but in 2002 this error occures. Thanks in advance for your time. amirbilal View Public Profile the expression you entered refers to an object that is closed or doesn't exist Find More Posts by amirbilal 02-02-2006, 08:59 PM #2 Oldsoftboss AWF VIP Join Date: Oct 2001 Location: in the shed Posts: 2,504 Thanks: 0 Thanked 57 Times in 50 Posts I think you will need to refer to the main form first, then the sub form Forms!MainFormName.Form!SubformName.recordsource or Forms!MainFormName.Form!SubformName.Form.recordsou rce cant remember which it is, but feel this will solve your problem. Dave __________________ Apathy is on the increase, but who cares. Imagine if there were no hypothetical questions To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. Oldsoftboss View Public Profile Visit Oldsoftboss's homepage! Find More Posts by Oldsoftboss 02-02-2006, 10:10 PM #3 amirbilal Registered User Join Date: Dec 2005 Posts: 9 Thanks: 0 Thanked 0 Times in 0 Posts Okie I tried that but It did not work both the ways. this is what I get finally. Forms!ManageExtranet.Form!AvailableIDs.Form.Record Source = theQuery Produces the same error Forms!ManageExtranet.Form!AvailableIDs.RecordSourc e = theQuery produces the following error Run-time error '438': Objec doesn't support this property or method Here is some interesting fact I would like you people to note. If I have opened the AvailableIDs form in design view then this error does not
(עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeWindows 10Windows 10 MobilePrevious versionsMDOPSurfaceSurface HubLibraryForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: MS Access 2010 databse - Run access error 2467 subform time error 2467 Windows Server > Setup Deployment Question 0 Sign in
Microsoft Visual Basic Runtime Error 2467
to vote Hello, Does anyone know what to do with this error? Thanks lots Tania Tuesday, June 30,
Runtime Error 2467 Access 2007
2015 12:44 AM Reply | Quote Answers 0 Sign in to vote expression you entered refers to an object that is closed or doesn't exists So probably a coding http://www.access-programmers.co.uk/forums/showthread.php?t=101413 error. I'd ask them moreover here. http://answers.microsoft.com/en-us/office/forum/office_2010-access?sort=lastreplydate&dir=desc&tab=threads&status=all&mod=&modAge=&advFil=&postedAfter=&postedBefore=&threadType=all&tm=1435627674425 Regards, Dave Patrick .... Microsoft Certified Professional Microsoft MVP [Windows] Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights. Proposed as answer by Alex LvModerator Thursday, July 02, 2015 6:30 AM Marked as answer by Alex LvModerator Tuesday, July 07, 2015 6:17 AM https://social.technet.microsoft.com/Forums/windows/en-US/b2f82b84-f437-4b65-9bbd-5f1e1c5d1286/ms-access-2010-databse-run-time-error-2467?forum=winserversetup Tuesday, June 30, 2015 1:28 AM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.Would you like to participate? Privacy statement © 2016 Microsoft. All rights reserved.Newsletter|Contact Us|Privacy Statement|Terms of Use|Trademarks|Site Feedback TechNet Products IT Resources Downloads Training Support Products Windows Windows Server System Center Browser Office Office 365 Exchange Server SQL Server SharePoint Products Skype for Business See all products » Resources Evaluation Center Learning Resources Microsoft Tech Companion App Microsoft Technical Communities Microsoft Virtual Academy Script Center Server and Tools Blogs TechNet Blogs TechNet Flash Newsletter TechNet Gallery TechNet Library TechNet Magazine TechNet Subscriptions TechNet Video TechNet Wiki Windows Sysinternals Virtual Labs Solutions Networking Cloud and Datacenter Security Virtualization Updates Service Packs Security Bulletins Windows Update Trials Windows Server 2012 R2 System Center 2012 R2 Microsoft SQL Server 2014 SP1 Windows 8.1 Enterprise See all trials » Related Sites Microsoft Download Center T
Custom Search UtterAccess Forums>Microsoft Access>Access Forms2 Pages 12> (Go to first unread post) Runtime http://www.utteraccess.com/forum/runtime-error-2467-t1973950.html Error 2467 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|-- time error 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 - time error 2467 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 CallMeAndyView Member Profile Sep 17 2011, 10:47 AM Post#1Posts: 58Joined: 21-June 05Hi chaps - doing my head in here I am sure I am missi