ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Changing an Access Query in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/68705-changing-access-query-excel.html)

Osmar Mateus

Changing an Access Query in Excel
 

When I change the path of the database in the SQL statement, I lose the
parameters used in the criteria seletion. What am I doing wrong?

Thansk for your help.


--
Osmar Mateus
------------------------------------------------------------------------
Osmar Mateus's Profile: http://www.excelforum.com/member.php...o&userid=30938
View this thread: http://www.excelforum.com/showthread...hreadid=507162


Osmar Mateus

Changing an Access Query in Excel
 

I bypassed this problem using macros.

Thanks to the people who tried to help me.

Osmar


--
Osmar Mateus
------------------------------------------------------------------------
Osmar Mateus's Profile: http://www.excelforum.com/member.php...o&userid=30938
View this thread: http://www.excelforum.com/showthread...hreadid=507162



All times are GMT +1. The time now is 01:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com