+ Reply to Thread
Results 1 to 5 of 5

No value given for one or more parameters - Access 2016 - Excel 2016

  1. #1
    Registered User
    Join Date
    03-15-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    63

    No value given for one or more parameters - Access 2016 - Excel 2016

    I have googled this error message and a lot of people have similar problems, but with different code layouts. I've tried copy and pasting as a last resort to get this code to work, but I always get the same error when running adodb and dao. Here is my code which I've typed out rather than copy and paste. I've installed Access runtime and have Microsoft Activex Dataobjects 6.1 enabled.

    Please Login or Register  to view this content.
    I've tried, i feel like, everything. Any ideas? Thanks.

  2. #2
    Registered User
    Join Date
    03-15-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    63

    Re: No value given for one or more parameters - Access 2016 - Excel 2016

    Just found out this code works with tables but not query's. Any suggestions?

  3. #3
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: No value given for one or more parameters - Access 2016 - Excel 2016

    Why not create View? And query that from outside.

    Have a read of...
    http://www.utteraccess.com/forum/Cre...-t1924479.html

    And...
    https://support.office.com/en-us/art...9-24c8f3e165ba

    Edit: FYI - You can connect to query as well. You can test using Northwind database. ex: [Order Details Extended]
    But there are limitations.
    Ex: Nz() in query will cause issue.
    Test by querying [Invoice Data] in Northwind.
    Last edited by CK76; 01-18-2018 at 03:58 PM.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  4. #4
    Registered User
    Join Date
    03-15-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    63

    Re: No value given for one or more parameters - Access 2016 - Excel 2016

    Quote Originally Posted by CK76 View Post
    Why not create View? And query that from outside.

    Have a read of...
    http://www.utteraccess.com/forum/Cre...-t1924479.html

    And...
    https://support.office.com/en-us/art...9-24c8f3e165ba
    I will look into this for sure, but I figured out my issue. It was because I was being asked for a parameter value in Access and I had to keep it from asking for a parameter value. After I could run my query in Access without being asked for a parameter value, I was then able to run the script just fine. Thank you for the links. I will definitely look into them!

  5. #5
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: No value given for one or more parameters - Access 2016 - Excel 2016

    Thanks for update. Glad you got it solved.

+ 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 2016 - changing graph horizontal access & slicer question
    By clairh2011 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-03-2017, 05:12 PM
  2. Bringing in External data from Ms-Access - Excel 2016
    By EricC99 in forum Excel General
    Replies: 4
    Last Post: 09-24-2017, 09:43 PM
  3. Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  4. [SOLVED] Issue send email with excel 2016 true outlook 2016
    By kirana2014 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-12-2017, 11:34 AM
  5. Help! Automated Email coding for Excel 2016 and Outlook 2016 problems
    By lisa6421 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2017, 08:07 AM
  6. Replies: 2
    Last Post: 05-24-2016, 10:43 PM
  7. Replies: 0
    Last Post: 05-17-2016, 07:55 AM

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