creating a new select query using CODE BUILDER

  • Thread starter crazy_beautiful_012
  • Start date
C

crazy_beautiful_012

i would like to ask how to create a select query using the cod
builder on access.

what i want to do is this
on my access FORM if i click a button, it should select a record fro
th
table students with a specific criteria
how do i start the code in the code builder
can you show me a sample code that i could base my work on
just implementing a simple sql statement to access a record on m
database in access
 
G

Guest

Hi Crazy!
LOL

The SQL for a select statement would be as follows:

"Select tblStudents.* from tblStudents Where tblStudents.FieldName =
'Criteria';"

Replace:
tblStudents with the real name of your table
FieldName with the real name of the field you want to search for specific
criteria
"Criteria" with the real criteria... LOL

If you want to give me some more details I would be happy to provide more SQL.

-- Take Care & God Bless ~ SPARKER ~
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Expression Builder available in Code Builder? 3
Public Functions in SQL statements... 4
Access Closes itself? 2
Using Code instead of Criteria 2
Enable or Disable Checkbox with expression builder 2
How to write an append query on a recordset 1
How to do an append query to a table from a recordset 2
SQL statement works in a query, but not in VBA 5

Top