+ Reply to Thread
Results 1 to 2 of 2

parameters in Excel for a query access

  1. #1
    Registered User
    Join Date
    01-06-2014
    Location
    Beirut
    MS-Off Ver
    Excel 2010
    Posts
    21

    parameters in Excel for a query access

    Hi all,
    I have an access query that ask for date values (From and To) as parameters once runned then give me the results.
    Now in Excel I would like to be able to enter the date values in two cells and have a Submit button that once clicked retrieve the query results in my sheet.
    How can this be done , note that I am not familiar a lot with VBA code.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,879

    Re: parameters in Excel for a query access

    Look at this link

    http://datapigtechnologies.com/blog/...ry-from-excel/
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Excel web query parameters?
    By Bret1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-29-2013, 07:03 PM
  2. Too Few Parameters Error Importing Access Query Results into Excel
    By dash11 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-06-2012, 04:42 PM
  3. Need help passing parameters to access query.
    By jryan15 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-04-2010, 10:34 AM
  4. Excel query and parameters
    By urbanmojo in forum Excel General
    Replies: 1
    Last Post: 07-23-2007, 12:17 AM
  5. Passing parameters from excel to access
    By Jabeen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2005, 08:06 AM

Tags for this Thread

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