Recent content by John liem

How to write VBA to link Excel spreadsheets: A.xls, B.xls, C.xls .... n.xls to respective tables Tbl_1, Tbl_2, Tbl_3 .... Tbl_n and then create an Union Query on all this tables. The number of Excel files is a variable, so the number of linked tables are variable as well. Excel File A.xls will...

Pat, Thanks for your suggestions and solution.

How can I create a column in a query that reflects automatically the table name? Example: Table_ABC. has fields: ID, Material, Qty. I want to create automatically a column/field in the Qy_ABC with "ID", "Material" and "QTY", and in additon into it, next to "Qty" a filed/column is called "Name"...

How can open Outlook for a new email and automatically insert auto-signature (including the logo) using VBA from Excel (Excel 2000). Thank you.

Thanks GHudson, it works as I want, great help!!!

I have found an example of database which I can use in my application, but what I want to know is how I can de-select my selections. In this example, I am using the "Form3" example and want to de-select the selected items in "List10" after the button "Add items" has been pushed. Thanks.

multicrit.zip sample Hi Doug, Do you have any ideas how I can deselect the highlighted selection after the result button is pressed using a command/statement in Access? Thanks in advance, John

Hi lledar, appreciate and thanks for your help. It works as I want.

In your example, you are only using 3 criteria in 3 different comboboxes. The query1 will only have 8 criteria lines. What will happen than if I am using all my 8 criteria fields in 8 different comboboxes, The query1 would have like 256 lines of criteria lines which Access can not handle.

I think, I haven't explain it right, the selection criteria has 8 fields: name, address, city, country, region, sub-region, organization and company. Depends on what I have chosen in each field from the 8 criteria, the query will result the right record(s).

What I am trying to achieve is to run a query with 8 field selection criteria which I can choose using a dropdown fields in a form "Fm_Selections". This Form has a button to run the query Qy_Selection using Tbl_Main. The result of this query will show the records which match the criteria, which...

I have a query which has 8 criteria fields, meaning that I will need 128 grid rows to build complete conditions with OR and AND functions to cover all the possible conditions from the selection criteria fields. How many query grid rows I can use without exceeding the maximum rows. I have tried...

Thanks calmwind, I'll give it a try.

I try to run a query from a customer table which output only double records and filter out unique single records. So, ONLY the same customers with different home addresses will appear on the query result. Thanks.

Hi Mike, Yes, I did realize a few days ago that I could strech the line down. Thanks anyway!