Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Querys

Status
Not open for further replies.
Tom123456

Tom123456

Programmer
Apr 2, 2003
70
SE
Hello all, How do I create a query at runtime and open a form with the result. Example the SQL statement "SELECT Name FROM Persons" open a form frmPersons and show all the names. (The textfield that contain the name can be static in the form).




- Tom
 
Sort by date Sort by votes
Hi

It might be a little easier to display the results in a listbox, depends on the data that you want to display I guess..

Code: 
Dim stSQL as String

stSQL = "Select Name " _
    & "FROM Persons;"

Me.lstListBox.RowSource = stSQL
Me.lstListBox.Requery
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

chiefvj
  • Locked
  • Question
all querys adding at least 5-40 kb to my frontend database
Replies
8
Views
28
lameid
lameid
mfleming
  • Locked
  • Question
Combine & Search Querys for Report??
Replies
4
Views
21
Trevil
Trevil
kenneth72
  • Locked
  • Question
remotely modify access forms/querys/reports
Replies
2
Views
16
kenneth72
kenneth72
OIE
  • Locked
  • Question
trouble with subforms and querys...
Replies
7
Views
27
OIE
OIE
stigejg
  • Locked
  • Question
MS ACCESS 2000 and long names on querys/tables?
Replies
1
Views
15
930driver
930driver

Part and Inventory Search

Sponsor

Back
Top