Home > Compile Error > Compile Error Expected Case

Compile Error Expected Case

An alternative in this case would be to use a DMax fuction to get the highest value. Hello and welcome to PC Review. 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 Get 1:1 Help Now Advertise Here Enjoyed your answer? http://buzzmeup.net/compile-error/compile-error-expected-end-with.html

Please do a search for this name before continuing." Cancel = True End If End If End Sub The starred line is what appears to be throwing the compile error, but Privacy Policy Site Map Support Terms of Use Xtreme Visual Basic Talk > Legacy Visual Basic (VB 4/5/6) > Database and Reporting > PLEASE HELP with SQL problem - expects "CASE" EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum Powered by: vBulletin v3.8.9 Log in or Sign up PC Review Home Newsgroups > Microsoft Access > Microsoft Access VBA Secondly, the Char: number 8, is very useful in tracing the error.

Check the real-time performance and availability statistics for any device on your network. I am getting a "Compile Error: Expected Case" the SELECT Inquiries.InquiryID of the code is red. Please try the request again.

So you would probably be better off resizing the array to the required size ONCE as Jim Burke pointed out. Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. If you have a good example of this error, then please email me, I will publish it with a credit to you: If you like this page then please share 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

Go to Solution 2 3 Participants holddigga(2 comments) peter57r LVL 77 MS Access67 jadedata LVL 32 MS Access31 4 Comments LVL 77 Overall: Level 77 MS Access 67 Message Accepted Registration on or use of this site constitutes acceptance of our Privacy Policy. Register Privacy Policy Terms and Rules Help Popular Sections Tech Support Forums Articles Archives Connect With Us Twitter Log-in Register Contact Us Forum software by XenForo™ ©2010-2016 XenForo Ltd. http://www.tek-tips.com/viewthread.cfm?qid=1183282 Similar Threads Compile error in a sub when converting to 2002 Jacqueline, Jul 3, 2003, in forum: Microsoft Access VBA Modules Replies: 2 Views: 1,286 Jacqueline Jul 3, 2003 Re: Unusual

Join Now For immediate help use Live now! The Solutions The Windows Scripting Host gives us three useful clues, firstly, look on Line: 10, do count any remark or empty lines. 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? Also, if you redim a dynamic array without using the optional preserve argument all the data is wiped from the array.

So you would probably be better off resizing the array to the > required size ONCE as Jim Burke pointed out. > > AND sizing the array once is faster then click here now Apr 9 '07 #3 reply Expert 100+ P: 1,017 iburyak The problem is nothing to do with the SQL syntax. Jenn :confused: Marathon Man03-15-2004, 07:35 AMHow are you actually using the line of SQL - is it the Source property of the Recordset object? CONTINUE READING Join & Write a Comment Already a member?

dwall03-15-2004, 08:08 AMIs your SQL line like this strSQL = "Select * FROM rsaddress WHERE LName = ssTab1.Caption" if so try strSQL = "Select * FROM rsaddress WHERE LName = '" news All rights reserved. Stay logged in Welcome to PC Review! Web|-- Other Microsoft ProductsPC|-- Network Issues|-- Q & A - Hardware|-- Q & A - Software|-- Q & A - Other PC|-- Virus + Security DiscussionUtterAccess Odds and Ends|-- General Chat|--

PLEASE HELP !!!! Compile Error Expected End Sub cant fix my Compile error: expected array for VBE excel, need help very new at this?? As a part of this, I've created a form for data entry of new people to tblPeople. have a peek at these guys Is there oscillating charge in a hydrogen atom?

The error you are receiving indicates that your VBA "Select Case" statement is not correctly written. Get started with an extensive collection of "out-of-the-box" monitors for popular network devices. 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

Join our community for more solutions or to ask questions.

What is dmax??? more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed What is wrong with the syntax/statement? 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

what gives a chord its function? 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 AND sizing the array once is faster then continually resizing the array. '==================================================== John Spencer Access MVP 2002-2005, 2007-2008 The Hilltop Institute University of Maryland Baltimore County '==================================================== Jim Burke in http://buzzmeup.net/compile-error/compile-error-expected-then-or-goto.html Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free.

Login. They way you are describing solving your problem may work without SQL but you will end up with a specific solution. Changing "name" fixed my issue. "John Spencer" wrote: > Also, you want to avoid using NAME as a variable. Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action.

Would you like to help others? Not the answer you're looking for? Try Removing the where statement alltogether. 'VBScript to Enumerate Accounts, and SID On Error Resume Next if Err <> 0 Then set lasterr = CreateObject("WbemScripting.SWbemLastError") Wscript.echo lasterr.Operation End if set objWMIService The next time someone says "could you do such-and-such" you will be back to the drawing board.

I need to go back to school and figure out this language - LOL. That did the trick on the SQL statement syntax, now all I have to do is set up the population code for the tabs. Is that a copy/paste error, or are they really missing? Thirdly, there is something wrong with the Select statement, which is confirmed in the message by Error: Expected 'Case'.

Please ( LoginorRegister )

Custom Search UtterAccess Forums>Microsoft® Access>Access Modules Compile Error Expected:Case Help Forum HomeSearchHelpUA Messages|-- UtterAccess.com NewsAccess Knowledge Center|-- Access Code Archive|-- Access Knowledgebase / FAQ|-- Access If you're having a computer problem, ask on our forum for advice. Join Us! *Tek-Tips's functionality depends on members receiving e-mail. It takes just 2 minutes to sign up (and it's free!).

If you employ Select, then is should be in brackets:(Select * from colaccounts). Take the guess work out of which WMI counters to use for applications like Microsoft Active Directory, SQL or Exchange Server. First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. I am getting a Compile Error Expected: Case.I am using two tables - SIS_daily_temp (SIS) and tblMU.

Join & Ask a Question Need Help in Real-Time?