Thanks for all of the inputs.

Minh Vu

Thank you so much Noel. I tested some based on your instruction. It does work for me.

Minh

Thanks a lot Frank.

That is exactly what I need. 

Minh vu

It stops at the line:

Set rst = db.OpenRecordset("qry EmailNotification").

I'm still debugging it.  thanks

Minh

I correct my mistake to put my string in quotes, but it gave me this message:

"Run-time error 3061. Too few parameters. Expected1".

Is that because my query result has more than...

Thank you so much for a great help.  I tried Andy method, but it did not work for me.  I'm not sure that your method will work in Access 97?...

We always process the payment on 15 or end of the month.  Therefore, my data always stable and there is always no exception.  Thanks

Minh Vu 

I need to know what do you have in Institution field.  In my case, my cross tab query looks like this:

TRANSFORM Sum(a.Q) AS SumOfQ

SELECT a.product, a.location,  a.Type

FROM  tbl_a a INNER...

I know that Access has an option called briefcase/replication to deal with your issue.  I've not tried it yet in Access, but the replication in SQlserver worked for me.

Minh Vu

Thanks.  That is what I found.  Mine is working now.

Minh

Thank you so much.  It works for me.

Minh.

Yes,

I am using VBA and t-sql.  Do you have any clues how to do that? Thanks

Minh

Another one that you can use:

select a.*

FROM information_schema.table_privileges a, information_schema.tables b

where a.table_name = b.table_name

and b.TABLE_TYPE ='base table'

Minh

Hi All,

Believe it or not David Burrows's way gave me exactly what I'm looking for (Thank you so much!).  I tested couple time and it worked very well for me. ...

If your data is not changed oftenly, copy the data to local access table and use it as a datasource for your combo box.  It will run must faster.

Minh