Access 2003 Runtime Error
Contents |
One games Xbox 360 games PC
Access 2003 Runtime Error 2709
games Windows games Windows phone games Entertainment All word 2003 runtime error Entertainment Movies & TV Music Business & Education Business Students &
Word 2003 Runtime Error R6034
educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security runtime error 57121 excel 2003 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 quickbooks 2003 runtime error abnormal program termination 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
One games Xbox 360 games PC
Word 2002 Runtime Error
games Windows games Windows phone games Entertainment All word 2000 runtime error Entertainment Movies & TV Music Business & Education Business Students &
Microsoft Word Runtime Error
educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security https://support.microsoft.com/en-us/kb/813969 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 https://support.microsoft.com/en-us/kb/295179 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 http://stackoverflow.com/questions/14064203/microsoft-access-vba-run-time-error-3075 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 Microsoft Access VBA - Run time error '3075' runtime error up vote 3 down vote favorite I've encountered the run time error '3075'. I'm a novice in VBA! >.< Can i know where did it went wrong? I can't solve it... For e.g, if I enter a name "Sally" into a textbox (txtMainName), upon clicking on the search button the error pops-up. The error: Run-time error '3075': Syntax error(missing operator) in query expression ' And [Main Applicant Name] 2003 runtime error Like 'Sally'". Public Sub Search_Record() Dim stDocName As String Dim stLinkCriteria As String Dim stLinkCriteria1 As String Dim stLinkCriteria2 As String stLinkCriteria = "" stDocName = "frmDisplayInfo" If (Me!txtMainName <> "") Then stLinkCriteria1 = "[Main Applicant Name] Like ' " & Me![txtMainName] & "'" stLinkCriteria = stLinkCriteria & " And " & stLinkCriteria1 End If If (Me!txtIDNo <> "") Then stLinkCriteria2 = "[ID No] Like ' " & Me![txtIDNo] & "'" stLinkCriteria = stLinkCriteria & " And " & stLinkCriteria2 End If '(*This part is highlighted*) DoCmd.OpenForm stDocName, , , stLinkCriteria DoCmd.Maximize End Sub ms-access access-vba ms-access-2003 share|improve this question edited Dec 28 '12 at 3:53 asked Dec 28 '12 at 3:27 GuessWho 39128 1 What is the content of stLinkCriteria (the actual value it contains, not what you think it contains) when you get to DoCmd.OpenForm? (Set a breakpoint at the OpenForm line, run to that point, and look at what stLinkCriteria is when you get there.) –Ken White Dec 28 '12 at 3:35 add a comment| 3 Answers 3 active oldest votes up vote 5 down vote accepted Runtime error 3975 is Invalid operator, according to a quick Google search on access vba runtime error 3075 (w