Compile Error Syntax Error Microsoft Access
Contents |
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 microsoft jscript compilation error syntax error more about Stack Overflow the company Business Learn more about hiring developers or posting
Microsoft Jscript Compilation Error Syntax Error Java
ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community
Microsoft Jscript Compilation Error Syntax Error Ie8
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 Compile error: Syntax error -MS ACCESS 2010 VBA error up
Microsoft Vbscript Compilation Error '800a03ea' Syntax Error
vote 0 down vote favorite Microsoft Access 2010 database gives me the following error "Compile error: Syntax error" In VBA window for this form it highlights the following line of code at line 3 "strSQL = "SELECT PID from tblMSCSPersonnel WHERE SSN = '" & Me!TextSSN & "';" " The entire code is below Private Sub Form_Current() Dim strSQL As String strSQL = "SELECT PID from tblMSCSPersonnel WHERE microsoft vbscript compilation error '800a03ea' syntax error class SSN = '" & Me!TextSSN & "';" Set rs = CurrentDb.OpenRecordset(strSQL) If rs.RecordCount = 0 Then ' not in the personnel database CmdAddToPersonnel.Enabled = True Else CmdAddToPersonnel.Enabled = False End If If Me![CmdSubmit].Visible = True Then Me![CmdSubmit].Visible = False Me![cmdCancel].Visible = False End If End Sub Thanks vba syntax compilation share|improve this question asked Dec 15 '14 at 19:26 maymenw 1 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote Maybe remove the semicolon and use Me. strSQL = "SELECT PID from tblMSCSPersonnel WHERE SSN = '" & Me.TextSSN & "'" share|improve this answer answered Dec 15 '14 at 19:45 Jason_Walker 42029 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged vba syntax compilation or ask your own question. asked 1 year ago viewed 172 times active 1 year ago Blog Stack Overflow Podcast #89 - The Decline of Stack Overflo
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 06 Oct 2016 05:09:20 GMT by s_bd40 (squid/3.5.20)
Custom Search UtterAccess Forums>Microsoft® Access>Access Modules Compile error - syntax error Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code Archive|-- http://www.utteraccess.com/forum/Compile-error-syntax-er-t1368656.html 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 syntax error 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 error syntax error 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 bjh29View Member Profile Mar 1 2007, 11:24 AM Post#1Posts: 117Joined: 5-February 07From: MichiganAny help is appreciated here. I am trying to prevent a duplicate entry in my table. I am getting "compile error - syntax error" I believe the problem is in my SELECTThanks!Option Compare DatabaseOption ExplicitPrivate Sub ParentID_BeforeUpdate(Cancel As Integer)SELECT Tasks.SessionID, Tasks.ClassTimeID, ParentVolunteer.ParentID FROM Tasks INNER JOIN ParentVolunteer ON Tasks.TaskID = ParentVolunteer.TaskID;If (((Tasks.SessionID) = [Forms]![Tasks]![SessionID]) And ((Tasks.ClassTimeID) = [Forms]![Tasks]![ClassTimeID]) And ((ParentVolunteer.ParentID) = [Forms]![Tasks]![ParentVolunteer subform].[Form]![ParentID])) ThenMsgBox "This parent already assigned a task