I've got a Search Database and the User types in a text value & the DB shows the results on a continuous form.
I need to get the results of each search to Excel.
Most info advises the solution but it needs a query name to export but this query changes everytime based on the search term.
I need some help where the user does their search, views the results (Already done), then clicks the 'Export Results' button & it opens a new Excel worksheet with the search results.
I've added my search script below which produces the results.
Please Login or Register to view this content.