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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create Query 1

Status
Not open for further replies.
sucoyant

sucoyant

IS-IT--Management
Sep 21, 2002
213
US
Hello all!

Is there a way in VBA to create a query, and 'save' it so it shows in the "Queries" window?

Thanks in advance!

________________________________________
BUDDHA.gif
Buddha. Dharma. Sangha.
 
Sort by date Sort by votes
yes like this:

Dim sql As String
sql = "SELECT * FROM DBNames;"

CurrentDb.CreateQueryDef "qryTest", sql
 
Upvote 0 Downvote
AH HA! THANK YOU!

Your help is GREATLY appreciated!!!!

________________________________________
BUDDHA.gif
Buddha. Dharma. Sangha.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ziffer68
  • Locked
  • Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
2K
ziffer68
ziffer68
Johnny S
  • Locked
  • Question
Create folder based on ID field MS Access
Replies
3
Views
397
MattGreer
MattGreer
Moss100
  • Locked
  • Question
Vba code I can call from a query to reformat text
Replies
8
Views
608
Moss100
Moss100
bryger
  • Locked
  • Question
pass-through query in MS access
Replies
2
Views
513
bryger
bryger
Abbsters
  • Locked
  • Question
Access VBA Code to Prevent Duplicates in my Form Query
Replies
2
Views
492
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top