Is it possible, using VB, to create a show/hide control for a query similar to its show box?. This query will be exported to Excel, so, a Form control is not a solution. Thanks.
Is it possible, using VB, to create a show/hide control for a query similar to its show box?. This query will be exported to Excel, so, a Form control is not a solution. Thanks.
Not sure what you are trying to do.
Can you provide some examples/code?
Thanks for your answer. I have a query with not few fields. Often I need to export part of those fields to Excel. I though to do it from Access but the only way I found to do it is to send the whole query to Excel and use VB to hide/unhide the fields.
Oh ok. The best way for you to do this then is to make another query based on your original query but only include the fields that you want to export.
This way you can customize the query that you want.
To do this, create a new query in Design Mode, select the Query Tab and pick the query that you are working with. Then select all the fields that you want.
Thank you, but I was thinking in a control on a unique query. Using your solution I surely will need about tenths of customized queries to solve my problem (I need to select between 6 or 8 possible fields in a 10 columns query).Oh ok. The best way for you to do this then is to make another query based on your original query but only include the fields that you want to export.
This way you can customize the query that you want.
To do this, create a new query in Design Mode, select the Query Tab and pick the query that you are working with. Then select all the fields that you want.