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

Open Control SQL via VBA

Status
Not open for further replies.
agfon

agfon

Programmer
Mar 25, 2005
38
0
0
US
I have some VBA which identifies all of my dbs QueryDefs - including the temporary "~sq_" type queries. Knowing the form and control that a ~sq_c is associated with, is there a way of opening the control's row source via vba?

-agfon
 
Sort by date Sort by votes
What do you mean by

opening the control's row source
 
Upvote 0 Downvote
agfon,

PWise asks a very good question here.

Can you please provide more information, if you are looking for help?

I'm assuming that you are wanting to access, via VBA, either:
1. The list of queries' names OR
2. The data for the current selected query...

Is either of these correct? Whatever the case, please provide as much detail going forward, so that others here can better answer your question.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
144
Swi
Swi
serino
  • Locked
  • Question
Help with SQL inner join statement 1
Replies
2
Views
80
serino
serino
Wolfdzn
  • Locked
  • Question
Join two seperate SQL into one
Replies
6
Views
86
dhookom
dhookom
MattGreer
  • Locked
  • Question
VBA Query - Close and Reopen db Connection when SQL Changes? 2
Replies
4
Views
101
Andrzejek
Andrzejek
dw134
  • Locked
  • Question
Working with SQL
Replies
2
Views
35
BrooksR
BrooksR

Part and Inventory Search

Sponsor

Back
Top