Running SELECT query in MSACCESS

[dolovenature]

Hi,



I have the following problem. I am designing a form based on a table in ms access. I want to run a select query from a command button.

My problem is....

1) What are the way to run a SELECT query from access as a simple SQL query is not run in access directly.
2) How to create table alias?

Regards
Saikat

[John_G]

Hi -

What is is you want to do with the Select query? You have the form based on a table, but the what is the button supposed to do?

John

[JoeM]

I am afraid I am not quite clear exactly what your question is.

If you have created a Query and would like to run it from a Command Button, then when adding the Command Button, the Wizard should prompt you for what you what do.
If you select "Miscellaneous", there is a "Run Query" option. Then just select the name of the Query you want to run, and that is what your Command Button will do.

Is that what you are asking?

[dolovenature]

Actually I have a command button, and when it is clicked it should select top students based on their marks.

My code is

SELECT StudentID,STName, STMarks, City
FROM Table1
WHERE (City = "Mumbai")
ORDER BY STMarks;

After writing it is showing me the message error : expected case.
My friend told me that running a sql statement in access requires something more trics.

Please highlight.

Regards
Saikat

[JoeM]

I don't think you can run Select queries directly from VBA.
If you want to open/view a Select Query using VBA, assign the SQL code to a pre-defined saved Query, then open that Query, i.e.

Dim mySQL as String

mySQL="SELECT StudentID,STName, STMarks, City " & _
           "FROM Table1  " & _
           "WHERE City = " & Chr(34) & "Mumbai" & Chr(34) " & _
           "ORDER BY STMarks;"

CurrentDb.QueryDefs("MyQueryName").SQL=mySQL
DoCmd.OpenQuery "MyQueryName"