By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

Pointing Form at a Query

ChaseCox
100+
P: 294
Is it possible to have a comb box that will allow you to select between two different queries?

Also, is it possible to have the ability to select which database the form is looking at by having the user type in the exact location of the DB? All of the DB's have the same info and titles, just for different product lines. Thanks for all the help!
Jan 3 '07 #1
Share this Question
Share on Google+
6 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Is it possible to have a comb box that will allow you to select between two different queries?
I don't understand the question Chase can you give more details please.

Also, is it possible to have the ability to select which database the form is looking at by having the user type in the exact location of the DB? All of the DB's have the same info and titles, just for different product lines. Thanks for all the help!
It doesn't work this way. Each front end points to a particular backend location. Changing this 'on the fly' is dangerous and to be avoided.

Mary
Jan 4 '07 #2

ChaseCox
100+
P: 294
I don't understand the question Chase can you give more details please.



It doesn't work this way. Each front end points to a particular backend location. Changing this 'on the fly' is dangerous and to be avoided.

Mary
I would like to have one form that would have the option to look at different queries, that I can select from a Combo Box.
Jan 4 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
I would like to have one form that would have the option to look at different queries, that I can select from a Combo Box.
Do all queries have the same list of fields?
Jan 4 '07 #4

NeoPa
Expert Mod 15k+
P: 31,186
Is it possible to have a comb box that will allow you to select between two different queries?
Are you talking about queries that the form is bound to?
In other words changing the RecordSource of the form on the fly.
I believe that is possible and could be done in the AfterUpdate event of the ComboBox.
Also, is it possible to have the ability to select which database the form is looking at by having the user type in the exact location of the DB? All of the DB's have the same info and titles, just for different product lines. Thanks for all the help!
As the RecordSource property can be changed on the fly, and it can also take a SQL string, it should be possible to replace it with some SQL that inludes the database explicitly within it. Great care (checks should be done) should be taken by the program to ensure that the data source is valid before making the switch though (See Mary's post above).
Jan 4 '07 #5

NeoPa
Expert Mod 15k+
P: 31,186
Every time I post today it seems the page refreshes and there is my new post - after two other new posts have gone in. I hope that's not too confusing :(.
Jan 4 '07 #6

MMcCarthy
Expert Mod 10K+
P: 14,534
Every time I post today it seems the page refreshes and there is my new post - after two other new posts have gone in. I hope that's not too confusing :(.
No more than usual -lol
Jan 4 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.