Hided query become unhide after run the macro

[Lawrence]

Hi,

i have a list of query and i've hided some of them for certain reason.

When everytime i re-run the macro, some of the query will unhide again.

Could anyone tell me what happen is it ???

Thanks in Advance.
LT

 

[Steve Schapel]

Lawrence,

Can you please give us the details of the macro - all actions and
relevant arguments. Thanks.

 

[Lawrence]

Steve,

i hide a table called [Product Downgraded XXX]

then i execute a query as below

SELECT Product.* INTO [Product Downgraded XXX]
FROM Product;

then the [Product Downgraded XXX] auto unhide.

LT

 

[Steve Schapel]

Lawrence,

Can you please give details of *how* you are doing these things. If you
are usiung a macro, we would need to know *what Actions* are in the macro.

 

[Lawrence]

hi,



Query Name View
Data mode
SetWarnings No
OpenQuery Prod Update 01 - Delete Old Datasheet Edit
OpenQuery Prod Update 02 - Append to Old Datasheet Edit
OpenQuery Prod Update 03 - Delete Product Datasheet Edit
OpenQuery Prod Update 04 - Append Raw Datasheet Edit
OpenQuery Prod Update 05 - Trim(Product) Datasheet Edit
OpenQuery Prod Update 06 - Obs Materials Datasheet Edit
OpenQuery Prod Update 08 - Update Package Type Datasheet Edit
OpenQuery Prod Update 09 - Product Category Datasheet
Edit
OpenQuery Prod Update 10 - Create DG part Datasheet
Edit
OpenQuery Prod Update 11 - Add DG Datasheet
Edit
OpenQuery Prod Update 12 - Append Raw Downgrade Datasheet Edit
OpenQuery Prod Update 13 - Update Concat Datasheet
Edit
Close Query Prod Update 10 - Create DG part Prompt
SetWarnings Yes
MsgBox Product Update Complete Yes None


LT

Lawrence,

Can you please give details of *how* you are doing these things. If you
are usiung a macro, we would need to know *what Actions* are in the macro.

--
Steve Schapel, Microsoft Access MVP

Steve,

i hide a table called [Product Downgraded XXX]

then i execute a query as below

SELECT Product.* INTO [Product Downgraded XXX]
FROM Product;

then the [Product Downgraded XXX] auto unhide.