Error 438 Access 2003
Contents |
360 games PC games run time error 438 object doesn't support this property or method Windows games Windows phone games Entertainment All Entertainment run time error 438 access vba Movies & TV Music Business & Education Business Students & educators
Run Time Error 438 Excel Macro
Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet
Runtime Error 438 Excel 2010
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 Lumia All microsoft visual basic runtime error 438 excel 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
Tech Support Guy, we highly recommend that you visit our Guide for New Members. Run time error 438-MS Access 2003 Discussion in 'Business Applications' started by urwethe, Jun 12, 2009. Thread Status: Not open for further replies. Advertisement urwethe Thread
Runtime Error 438 Access
Starter Joined: Jul 28, 2004 Messages: 97 Hi, With MS Access 2003, I am getting this access error 438 object doesn't support error when I click on a value in a combo box: Run-time error '438' Object doesn't support this property or method The error is run time error 438 vba excel 2010 on the line Me!ID.SetFocus in the sub below. Can anybody help me out? Thanks!!! Private Sub Combo87_AfterUpdate() Me!ID.SetFocus If Not IsNull(Me!Combo87) Then DoCmd.FindRecord Me!Combo87 End If End Sub urwethe, Jun 12, 2009 #1 Sponsor OBP Trusted Advisor Joined: https://support.microsoft.com/en-us/kb/175616 Mar 8, 2005 Messages: 19,071 I can't see any real problem with the code, but is the ID field set to Visible = Yes and Enabled = Yes if it isn't you can't set the focus to it. OBP, Jun 12, 2009 #2 urwethe Thread Starter Joined: Jul 28, 2004 Messages: 97 Yes, combo87 is set to visible and enabled = yes. urwethe, Jun 12, 2009 #3 OBP Trusted Advisor Joined: Mar 8, 2005 Messages: 19,071 What about ID, https://forums.techguy.org/threads/run-time-error-438-ms-access-2003.834711/ which is where you are trying to set the Focus? OBP, Jun 12, 2009 #4 urwethe Thread Starter Joined: Jul 28, 2004 Messages: 97 Please bear with me as I am a little rusty here, but here is my reply: ID is the primary key field, Autonumber in the table. Where would I set the visbile and enabled properties? urwethe, Jun 12, 2009 #5 OBP Trusted Advisor Joined: Mar 8, 2005 Messages: 19,071 On the Form in design view, click on the ID field and in the Properties "All Tab" see what the settings are for Visible and Enabled. OBP, Jun 12, 2009 #6 urwethe Thread Starter Joined: Jul 28, 2004 Messages: 97 When I View Field List and click on ID, nothing shows up in the properties window. When I click on different objects they show up(of course) but when I click on any of the fields they do not show up in the properties window. urwethe, Jun 12, 2009 #7 OBP Trusted Advisor Joined: Mar 8, 2005 Messages: 19,071 Sorry, I don't know how it can do that. Can you create a new database and Import the form so that you can post a zipped copy on here? OBP, Jun 12, 2009 #8 slurpee55 Joined: Oct 20, 2004 Messages: 7,837 Run time error 438 has also shown up due to an update to XP. There are 2 fixes for it at http://www.microsoft.com/downloads/...01-F669-4542-AD93-199ED1FE9A2A&displaylang=en and http://www.microsoft.com
Custom Search UtterAccess Forums>Microsoft® Access>Access Automation Error: 438 Object Doesn't Support This Property Or Method, Access 2003 Forum http://www.utteraccess.com/forum/index.php?showtopic=1990054 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 http://www.vbaexpress.com/forum/showthread.php?46350-Runtime-Error-438-in-Access and A|-- Access Tables + Relationships|-- Access Queries|-- Access Forms|-- Access Reports|-- Access Macros|-- Access Modules|-- Access Date + Time|-- Access Errors + Error Handling|-- Access error 438 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|-- time error 438 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 johanView Member Profile Jul 6 2012, 04:04 AM Post#1Posts: 905Joined: 24-April 08From: Riebeek Kasteel, Western Cape, South AfricaI have a problem with the following code. I give me "Error: 438 Object doesn't support this property or method". Where did I go wrong. This code do work in my own DB but it do not want to work
VBA Code & Other Help Access Help Runtime Error 438 in Access If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 6 of 6 Thread: Runtime Error 438 in Access Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 05-22-2013,12:45 PM #1 toneslinger View Profile View Forum Posts View Blog Entries View Articles VBAX Newbie Joined May 2013 Posts 3 Location Runtime Error 438 in Access Hello, I know enough VBA to be dangerous and that is about it. A while back I created a script in a database to recognize an open Outlook session, go to one of the public folders and to download emails into the database. This has worked just fine for years. That ended today. The company upgraded to Windows 7 with MS Office 2010. Now when I run the script I get the Run-Time Error 438 - Object doesn't support this property of method. Here is the code. 'Recognize open session of Outlook. Set OL = GetObject("", "Outlook.Application") Set Olns = OL.GetNamespace("MAPI") 'Assign Public Folders to variables. Set myfolder1 = OL.folders("Public Folders") - This is the line where the error occurs. Set myfolder2 = myfolder1.folders("All Public Folders") Set myfolder3 = myfolder2.folders("Department/Division") Set myfolder4 = myfolder3.folders("Web Based Quote Exceptions") Set myfolder5 = myfolder4.folders("Deleted Items") Any advice out there? I would greatly appreciate it!!! Reply With Quote 05-26-2013,08:23 PM #2 Doug Robbins View Profile View Forum Posts View Blog Entries View Articles VBAX Contributor Joined Oct 2012 Location Brisbane, Queensland, Australia Posts 163 Location I was sure that I had responded to this yesterday, but I cannot see my response. Try Dim OL As Object Dim Olns As Object Dim myfolder1 As Object Set OL = GetObject("", "Outlook.Application") Set Olns = OL.GetNamespace("MAPI") Set myfolder1 = Olns.Folders(1) Formatting tags added by mark007 Reply With Quote 05-28-2013,05:26 AM #3 toneslinger View Profile View Forum Posts View Blog Entries View Articles VBAX Newbie Joined May 2013 Posts 3 Location Thanks for the info! However, I did