|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 11th, 2008, 11:55 AM
posted to microsoft.public.access.queries
|
|||
|
|||
Get Distict records from a recordset multiple time using subquery
I have to load distinct records into more that one comboBox and was wondering
if it was possible to open the database once by selecting all records and using subqueries on the same records. Regards Charles 
|
|
#2
July 11th, 2008, 12:22 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Get Distict records from a recordset multiple time using subquery
Sure, you are only reading the records in a combobox. What else will you be
doing? You will trip over yourself if you open the records multiple times and make changes. Bonnie http://www.dataplus-svc.com vqthomf wrote: I have to load distinct records into more that one comboBox and was wondering if it was possible to open the database once by selecting all records and using subqueries on the same records. Regards Charles -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200807/1
|
|
#3
July 11th, 2008, 01:07 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Get Distict records from a recordset multiple time using subqu
I am using excel vba to fill the combobox but to do this I have to open the
database more than once and it is slow I was just wondering if it could be done. Regards "bhicks11 via AccessMonster.com" wrote: Sure, you are only reading the records in a combobox. What else will you be doing? You will trip over yourself if you open the records multiple times and make changes. Bonnie http://www.dataplus-svc.com vqthomf wrote: I have to load distinct records into more that one comboBox and was wondering if it was possible to open the database once by selecting all records and using subqueries on the same records. Regards Charles -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200807/1
|
|
#4
July 11th, 2008, 01:29 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Get Distict records from a recordset multiple time using subqu
So are you working in Access or Excel? If it is Excel - this is an Access
forum and you would get better help in an Excel forum. Bonnie http://www.dataplus-svc.com vqthomf wrote: I am using excel vba to fill the combobox but to do this I have to open the database more than once and it is slow I was just wondering if it could be done. Regards Sure, you are only reading the records in a combobox. What else will you be doing? You will trip over yourself if you open the records multiple times [quoted text clipped - 8 lines] Regards Charles -- Message posted via http://www.accessmonster.com
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
