Home > Compile Error > Compile Error Expected Case

Compile Error Expected Case

Here is the code I am using:CODE SELECT Sum(SIS.Cap_Plan) AS Commit1, Sum(SIS.Demand) AS Demand1, Sum(SIS.Estimated_Staff) AS Estimated_Staff1, Sum(SIS.EstStaff_OutTalk) AS EstStaff_OutTalk1, Sum(SIS.Total_EstStaff) AS Total_EstStaff1, Sum(SIS.ReqStaff) AS ReqStaff1," & _" IIf(IsError(Sum([Total_EstStaff])-Sum([Cap_Plan])),0,Sum([Total_EstStaff])-Sum([Cap_Plan])) AS Commit_OU, It will be tough while you try and get your head around it, but it will give you a huge amount of power over your data when you get good at In addition, we can call the functions that are part of the Windows operating system. Case are more subtle. http://ogdomains.com/compile-error/compile-error-expected.php

However, I get a compile error Expected: Case. Private Sub Form_Open(Cancel As Integer) Dim db As DAO.Database Dim rst As DAO.Recordset Dim sql As String Dim name() As String Dim i As Integer i = 0 sql = "SELECT About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts. The problem is you are using Select but without the corresponding 'Case' statement. http://stackoverflow.com/questions/35021319/compile-error-expected-case

Advertisements Latest Threads A trip to the space coast Becky posted Nov 19, 2016 at 3:23 PM Adult Tonsillectomy Ian posted Nov 19, 2016 at 2:00 PM Black Desert Online Taffycat The underlying problem is that Select * is inappropriate here. I have no idea whether the SQL syntax is correct or not - that's another story. RE: Compile Error: Expected Case SkipVought (Programmer) 27 Jan 06 14:17 You did not provide any VB code -- just SQL.Where is your code?

This article takes things to the next level by showing you how you can us… MS Access How to underlay a section in Microsoft Access Reports Article by: SeyerIT I originally Arabic — what are the differences? The next time someone says "could you do such-and-such" you will be back to the drawing board. Apr 9 '07 #3 reply Expert 100+ P: 1,017 iburyak The problem is nothing to do with the SQL syntax.

Download your fully functional trial copy of the Engineer's Toolset v10 Example 2 Pure Select Case Error 800A03FD The problem is here on Line 16: Select objDisk.DriveTypeThe solution is: Select Case Why doesn't find . -delete delete current directory? Azzmodan Ars Praetorian Tribus: The Netherlands Registered: Dec 13, 2004Posts: 473 Posted: Sat Sep 13, 2008 7:20 am You didn't terminate your last string: lID = VAL ( NZ ( DLOOKUP http://www.tek-tips.com/viewthread.cfm?qid=1183282 Are you aComputer / IT professional?Join Tek-Tips Forums!

Get started with an extensive collection of "out-of-the-box" monitors for popular network devices. Compile Error Expected End Sub cant fix my Compile error: expected array for VBE excel, need help very new at this?? So Access could be confused when you try to use name as a variable name. P.S.

Select * FROM rsaddress WHERE LName = ssTab1.Caption This gives me the error "Compile Error: Expected: Case" and highlights the '*' I keep getting this same kind of error whenever I http://www.computerperformance.co.uk/Logon/code/code_800A03FD.htm You want your SELECT included in the strSQL string ... Please Wait... For more help let us check is the Line: number, (12 in example 1).

Is that a copy/paste error, or are they really missing? http://ogdomains.com/compile-error/compile-error-expected-to.php Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. Close Box Join Tek-Tips Today! All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission.

More About Us... Many thanks. –AJK Jan 27 at 7:48 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign No, create an account now. this contact form Site Message (Message will auto close in 2 seconds)Welcome to UtterAccess!

Arab vs. So Access could be confused when you try to use name > as a variable name. > > Also, if you redim a dynamic array without using the optional preserve > You could be right.

Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|--

current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Join UsClose ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve the URL: http://0.0.0.4/ Connection to 0.0.0.4 failed. Codes beginning 08004... LName = the last name as stored in the ADODB recordset.

P.S. asked 9 months ago viewed 354 times active 9 months ago Upcoming Events 2016 Community Moderator Election ends in 3 days Related 2Error when running Access 2003 app in Access 20070Error Syntax didn't look correct to me. navigate here By learning SQL you will be able to create rapid, flexible solutions to your data problems.

And since it isn't VBA code, this is hardly surprising. Windows Scripting host generates a message box like this picture: For both Examples the Cause of Code 800A03FD Your VBScript contain is missing a argument.Source: Microsoft VBScript compilation error, indicates an Compilation errors such as missing brackets are easy, but problems with Select ...