Home Posts Topics Members FAQ
Emmanuel Ayivi
19 New Member
Please the SQL query is saying a error thus Expected end of statement can I know is wrong with it?
strSQLDetails = "SELECT tFD.* " & _
"FROM [tblFeesDetails] AS tFD" & _
" INNER JOIN" & _
" (SELECT LAST([Insect_Date and Time]) AS [LastDT]" & _
" FROM [tblFeesDetails]" & _
" WHERE ([GroupID] = '%G'")) AS sQ" & _
" ON tFD.[Insect_Date and Time] = sQ.LastDT " & _
"WHERE (tFD.GroupID = '%G'")
strSQLDetails = Replace(strSQLDetails, "%G", mGroupID)
Mar 17 '11 #1
Subscribe Reply
3 2321
hype261 207 New Member
I can't see an obvious error in your syntax, but generally what I do in this situation is to copy the query and go to the query designer and put it on sql mode and paste it in. The query designer gives must better error messages on what is the problem than VBA.
Mar 17 '11 #2
reply
Emmanuel Ayivi 19 New Member
I copied the SQL query and pasted it in the designer and it says "Expected end of statement. so I tried going through but could not see anything wrong with it but the saying the is an error
strSQLDetails = "SELECT tFD.* " & _
"FROM [tblFeesDetails] AS tFD" & _
" INNER JOIN" & _
" (SELECT LAST([Insect_Date and Time]) AS [LastDT]" & _
" FROM [tblFeesDetails]" & _
" WHERE ([GroupID] = '%G'")) AS sQ" & _
" ON tFD.[Insect_Date and Time] = sQ.LastDT " & _
"WHERE (tFD.GroupID = '%G'")
Mar 17 '11 #3
reply
Rabbit 12,516 Recognized Expert Moderator MVP
The code you pasted into the SQL query editor is VBA code. That's not valid SQL.
Also, are you sure it's supposed to be = "%G"
and not Like "%G"
?
Mar 17 '11 #4
reply
Sign in to post your reply or Sign up for a free account.
Similar topics
1 2262 Regenerating ASPNET Login Account by: Iced Crow |last post by: How do you regenerate the ASP_NET login account? The password got changed which hosed everything. I can no longer see my web services and need to reset the ASP account. How do I do this? Thanks ~IC ASP / Active Server Pages |
4 3586 Newbee question - why no create user in DB2 ? by: cmc |last post by: Hi, I 'm new to DB2 (from Oracle background) and have some fundamental question. In Oracle, you create user account "within the database" to let user to logon to the database. There is no tie between the unix account (or other operating system) and the oracle user account - you can logon to the server machine dose not mean you can logon... DB2 Database |
14 6144 How to change the account that ASP.NET uses by: Mr.KisS |last post by: Hi, How to change the account that ASP.NET uses for this virtual directory to one that has rights to the SQL Server box. Or how to use impersonation set in the Web.config file for the asp application, referring to an account that has rights to the SQL Server box. ASP.NET |
6 4154 Login/VBA script to login to Access 2000 by: cyndithomas via AccessMonster.com |last post by: I new to Visual Basic and am struck on a issue. Have created a Login in Screen for Remote User to access and input data. Want the Remote to be able to login & access the Input Form, and Manager to Login to another screen to view data. Form 1 is rmFieldReq (Remote Users Form) Form 2 is frmREquests (Manager Form) Below is my Code Microsoft Access / VBA |
871 Error while creating a new user login, using c# by: mig |last post by: Hi I was writing a piece of code to create a new user login on my machine, which runs vista. I get this error: "General Access Denied Error" at newUser.CommitChanges() in the following code: public static void AddUser(string userName, string password) { DirectoryEntry activeDirectory = new DirectoryEntry("WinNT://" +... .NET Framework |
1090 Create user within the Login Control by: TheDude5B |last post by: Hi, I have a problem with existing customers from an old site, coming to my new asp.net 2.0 site with the user roles and membership, and trying to login with their old details. As you know, the new built in membership encrypts passwords (I know you can use the system without encrypting the passwords, but this what i have unfortunetaly... ASP.NET |
1590 DirectoryEntry without using admin user: how to check if account'sexpired by: Big Charles |last post by: Hello, Programming in VS2003-ASP.NET 1.1, I have this problem: Using DirectoryEntry and without any admin user, how can I check if a domain account, that try to login, has expired? Scenario: User load web application and login using account and password of the Active Directory. But user account of ActiveDirectory has expired (or password... .NET Framework |
1 1336 i need a help in C Sharp "Create a login pange" by: nazmyonline |last post by: i hv created a login form on C sharp .net i need 2 connect this form to MS Access database . there s a table user account from there i hv created 2 column " Username ,password " whn i press the login button check the database n i need 2 login i hv uploaded dat application here plz help me .. its very important 4 me .. i hope i vl... C# / C Sharp |
5 1804
How to dynamically login into a client computer by: reachkars |last post by: Hi, I need to know if it is possible in .Net to dynammically login or enter credentials or unlock a locked machine through another machine which has Admin access(logged on by an administrator). The reason I need this is, Am working on a project where in I assign unique id's to set of computer users, For eg: .NET Framework |
1 1814 Custom user login system edition by: munkee |last post by: I have modified Richard Rensel's Security Demo 2000 in order to produce a custom user login system. One of the aspects which I am succesfully using is the basic user grouping level: Access ID - Access title - Access description. This allows me to check the allowed access a user has when opening a form and enabling/disabling certain... Microsoft Access / VBA |
7328
What is ONU? by: marktang |last post by: ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main... General |
7251 Changing the language in Windows 10 by: Hystou |last post by: Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language... Windows Server |
7474
Problem With Comparison Operator <=> in G++ by: Oralloy |last post by: Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ... C / C++ |
1 7228 The easy way to turn off automatic updates for Windows 10/11 by: Hystou |last post by: Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For... Windows Server |
5775
AI Job Threat for Devs by: agi2029 |last post by: Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then... Career Advice |
4811 Couldnt get equations in html when convert word .docx file to html file in C#. by: conductexam |last post by: I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert... C# / C Sharp |
3305 Windows Forms - .Net 8.0 by: adsilva |last post by: A Windows Forms form does not have the event Unload, like VB6. What one acts like? Visual Basic .NET |
1700 transfer the data from one system to another through ip address by: 6302768590 |last post by: Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system C# / C Sharp |
1 887
How to add payments to a PHP MySQL app. by: muto222 |last post by: How can i add a mobile payment intergratation into php mysql website. PHP |
By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.
To disable or enable advertisem*nts and analytics tracking please visit the page.