ADO-Dataenvironment Question
I use the following instructions to attach to an
Access database table using ADO and the Data environment:
DataEnvironment1.phone1
Set rs = DataEnvironment1.rsPhone1
How can I change "Phone1" in these instructions or build these instructions at runtime to reflect a different table name(the table name is being selected from a long list of table names at runtime)
Thanks---Tennisnet
Re: ADO-Dataenvironment Question
Instead of using a DataEnvironment command to open your recordset, try to open the recordset dynamically using the DataEnvironment connection (DataEnvironment1.cnn) like this:
set rs = DataEnvironment1.cnn.Execute("SELECT * FROM " & strYourVariable
where strYourVariable is a table name in your database.
Alternately, you can define a command for each table, and then use a select case to determine which command to use at run time.
Hope this helps
Jason