Open an Access database Import data like Microsoft Query

Ed

Here's one way for points 1 and 3

Please Login or Register  to view this content.

It uses the form initialization code to get the distinct entries from table access_table1, field col_1 from database c:\temp\test2.mdb and loads them into a combobox. Same syntax for a listbox.

I'm not sure what you mean by point 2. Data range properties from what? / where???


HTH

rylo

Thanks for the response. To answer your question, Data Range Properties is part of MS Query. When you select a range on a worksheet and import data in that range, the Data Range Properties' form gives you different options on how the returned data is used.

I have looked at your code and other code from the web. All of which is very similar. Is there a way to have multiple tables or multiple fields for multiple combo boxes on the same user form, without having to go thru all of that code?

In other words, do I need to open more connections and assign recordset variables for each control on a user form? I realize more SQL statements will be needed. Isn't there an ADO recordset control that can be placed on a user form that handles most of the work?

Also, is there a way to open a table as read only or read/write?

Thanks
ED

Ed

You only need to open the one connection. From that you could either open multiple recordsets, reuse the same recordset for each item, or, depending on your database table / query structure, you could have 1 recordset that has all the data for all your output areas, and use the single loop to fill each output from the same recordset.

There are probably various ways to code your requirement, but without some specifics, the above generalisation is the best I can come up with.

You can open tables with different access methods. Again, depends on what you want to do will determine your approach. Are you trying to add new records? or update existing records???


rylo