+ Reply to Thread
Results 1 to 3 of 3

Export Access search results that uses a variable to an Excel spreadsheet

  1. #1
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13
    Posts
    976

    Export Access search results that uses a variable to an Excel spreadsheet

    Hi Everyone,

    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.
    Remember you are unique, like everyone else

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,125

    Re: Export Access search results that uses a variable to an Excel spreadsheet

    build the query, based on filter controls on the form
    then export the qry

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13
    Posts
    976

    Re: Export Access search results that uses a variable to an Excel spreadsheet

    Thanks ranman256,
    Unfortunatly, I haven't been able to apply this to my database.
    I've attached a DB with the same issue & wondered if you add your Export & maybe the Search code?
    It would be great if you can add some comments as to what you're doing as I wasn't sure how it was working.
    I also tried to add a Record Count text box but the code I've added is producing an error? I wanted to show the User the count of results after the search, they then click on the Copy to Excel button & Excel opens with the search results for them to choose what they want to do.
    hanks for your help, Peter
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Ms access database Advanced Search and Export to Excel
    By kirana2014 in forum Access Tables & Databases
    Replies: 1
    Last Post: 04-29-2017, 02:42 PM
  2. From Excel, search Access database and return all matches to a variable value
    By bemidjipatriot in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2017, 11:54 AM
  3. Replies: 4
    Last Post: 11-28-2016, 10:07 AM
  4. [SOLVED] VBA to export Access Query results to Excel
    By jmzis4me in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-01-2014, 06:34 PM
  5. Search Results to an Excel Spreadsheet?
    By joebell in forum Excel General
    Replies: 1
    Last Post: 09-04-2013, 07:45 AM
  6. Export Google search results to Excel
    By WEEZY760 in forum Excel General
    Replies: 2
    Last Post: 03-23-2012, 05:50 PM
  7. Copy or Export an Access Query results back to Excel
    By MACRE0 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-18-2008, 01:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1