The Acronis Global Cyber Summit 2019 will be held at the Fontainebleau Miami Beach Resort on October 13–16, 2019, and it promises to be the must-attend event for IT infrastructure managers, CIOs, service providers, value-added resellers, ISVs, and developers.
ORDER BY
Hi EE
I have the following and a mental block
Set rsBooked = "SELECT ID FROM tblBooked" & "ORDER BY [ID] ASC"
Not working where have I gone wrong. Any help appreiated
chestera
I have the following and a mental block
Set rsBooked = "SELECT ID FROM tblBooked" & "ORDER BY [ID] ASC"
Not working where have I gone wrong. Any help appreiated
chestera
Who is Participating?
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get this solution by purchasing an Individual license!
Start your 7-day free trial.
I wear a lot of hats...
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
Experts Exchange Solution brought to you by
Your issues matter to us.
Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.
Start your 7-day free trial
reason being there is no space for your joined string and that created an syntax error
>> Set rsBooked = "SELECT ID FROM tblBooked" & "ORDER BY [ID] ASC"
>> Set rsBooked = "SELECT ID FROM tblBooked" & "ORDER BY [ID] ASC"
Why not simply:
Set rsBooked = "SELECT ID FROM tblBooked ORDER BY [ID] ASC"
or:
Set rsBooked = "SELECT ID FROM tblBooked ORDER BY 1"
/gustav
Set rsBooked = "SELECT ID FROM tblBooked ORDER BY [ID] ASC"
or:
Set rsBooked = "SELECT ID FROM tblBooked ORDER BY 1"
/gustav
everyone is focusing on the SQL, except Rgonzo.
1. you have to define the SQL correctly, Rgonzo did this although I cannot understand at all why anybody feels the need to define the SQL string by separating the SELECT and Order By clauses:
strSQL = "SELECT ID FROM tblBooked ORDER BY ID"
2. The second is that cannot open a recordset by setting a value to a string.
set rsBooked = currentdb.OpenRecordset(st
1. you have to define the SQL correctly, Rgonzo did this although I cannot understand at all why anybody feels the need to define the SQL string by separating the SELECT and Order By clauses:
strSQL = "SELECT ID FROM tblBooked ORDER BY ID"
2. The second is that cannot open a recordset by setting a value to a string.
set rsBooked = currentdb.OpenRecordset(st
Gustav Brock
Getting same error as with my example Compile error Type mismatch. Tried Ryans version same result
Alan
Getting same error as with my example Compile error Type mismatch. Tried Ryans version same result
Alan
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access
From novice to tech pro — start learning today.
Experts Exchange Solution brought to you by
Enjoy your complimentary solution view.
Get this solution by purchasing an Individual license!
Start your 7-day free trial.
pls try
Open in new window
Regards