Hided query become unhide after run the macro

  • Thread starter Thread starter Lawrence
  • Start date Start date
L

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
 
Lawrence,

Can you please give us the details of the macro - all actions and
relevant arguments. Thanks.
 
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
 
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.
 
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



Steve Schapel said:
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.
Click to expand...
Click to expand...
 
Back
Top