Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Well, I inserted the code examples you provided and if I use the first one the program functions, and if I use the second one it goes back to asking for It takes just 2 minutes to sign up (and it's free!). Jenn Marathon Man03-16-2004, 03:03 AMJenn - Stick with the SQL. Check This Out
Compilation errors such as missing brackets are easy, but problems with Select ... For more help let us check is the Line: number, (12 in example 1). The error you are receiving indicates that your VBA "Select Case" statement is not correctly written. Just click the sign up button to choose a username and then you can ask your own questions on the forum.
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 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 There should be no 'Where' clause. ‡ Example 1 of Script showing Error 800A03FD Check the Select * The problem is that you cannot saywhere objAccount.name = "Guest".
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 The problem is you are using Select but without the corresponding 'Case' statement. The Solutions The Windows Scripting Host gives us three useful clues, firstly, look on Line: 10, do count any remark or empty lines. http://www.tek-tips.com/viewthread.cfm?qid=1183282 You can't do that.
Arab vs. Would you like to help others? 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 Take the guess work out of which WMI counters to use for applications like Microsoft Active Directory, SQL or Exchange Server.
ssTab1.Caption is a tab with the letter of the last name I have done some displays and sstab1.caption displays correctly, the number of records in the file match what has been http://www.computerperformance.co.uk/Logon/code/code_800A03FD.htm Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc. I'm not sure what you mean - I am trying to select records from an Access database that have a first letter that matches the letter on the caption of the 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
Also, if you redim a dynamic array without using the optional preserve argument all the data is wiped from the array. his comment is here I am also open to any suggetions on ways to make it more efficient pbaldyView Member Profile May 26 2009, 01:04 PM Post#2UtterAccess VIPPosts: 5,077Joined: 15-February 03From: Nevada, USAI don't see Connect with top rated Experts 16 Experts available now in Live! There are so many good gadgets; it's like having free rein of a sweetshop.
Sign up now! strSQL = "INSERT INTO PreCallQuestionaireResidential ( InquiryID )" & vbCrLf & _ "SELECT Inquiries.InquiryID FROM Inquiries" Debug.Print strSQL '<- view this in Immediate window; Ctrl+g will take you there share|improve this 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://thetechvoice.com/compile-error/compile-error-expected.html Codes beginning 08004...
I have no idea whether the SQL syntax is correct or not - that's another story. By learning SQL you will be able to create rapid, flexible solutions to your data problems. 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 >
Please try the request again. These functions are part of the Windows API (Application Programming Interface). Changing "name" fixed my issue. "John Spencer" wrote: > Also, you want to avoid using NAME as a variable. PC Review Home Newsgroups > Microsoft Access > Microsoft Access VBA Modules > Home Home Quick Links Search Forums Recent Posts Forums Forums Quick Links Search Forums Recent Posts Articles Articles
Your cache administrator is webmaster. Thankfully the utilities are displayed logically: monitoring, network discovery, diagnostic, and Cisco tools. CONTINUE READING Join & Write a Comment Already a member? navigate here Someone please point me in the right direction.
Please Wait... What is dmax??? I am getting a Compile Error Expected: Case.I am using two tables - SIS_daily_temp (SIS) and tblMU. And since it isn't VBA code, this is hardly surprising.
How to respond to your boss's email about a coworker's accusation? x= dmax("[sample number]","Inventory") Pete 0 Message Author Comment by:holddigga2004-05-18 Comment Utility Permalink(# a11102340) Hey, I think i got the statement working...i stupidly didnt write DoCmd.RunSQL " " but now it So you would probably be better off resizing the array to the required size ONCE as Jim Burke pointed out. 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
So Access could be confused when you try to use name as a variable name. In addition, I placed a msgbox display and instead of getting the value I was looking for I get the String in quotes, the value shows up as: Select * FROM How to fix "Compile error: Expected End Sub" in VBA Macro? Not the answer you're looking for?
Compile Error Expected End Sub cant fix my Compile error: expected array for VBE excel, need help very new at this?? An alternative in this case would be to use a DMax fuction to get the highest value. Sign Up Now! rsaddress = an ADODB recordset that is defined in the option explicit.
Stay logged in Welcome to PC Review! The error you are receiving indicates that your VBA "Select Case" statement is not correctly written. Arabic — what are the differences? A word for the moment when you realise technology has outpaced you On which physical drive is this logical drive? 5 Favorite Letters Goodness Giza Golf!