Query as a switchboard item?

  • Thread starter Thread starter Deanne
  • Start date Start date
D

Deanne

How would one create a button on a switchboard which will
run a query so that the end users can import info into
Excel? A report is not needed, but the info is.
 
Hi,


Under the click event of the button, add a line of code that would
do the transfer (many flavors)

DoCmd.TransferXXX

The transfer methods accept a query as "source" of data being so
exported.


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top