Results 1 to 4 of 4
  1. #1
    denny is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    3

    parameter query not working

    i have an access database that connects via odbc to our as400. the program has worked fine for years. now any paremeter query that prompts you for the parameter gets an ODBC call failed. if i hard code the parameter into the query, it works fine. for example, [begin date] prompts you for a date, this doesnt work, now if i type in 20110201 in the query, it works. i have been pulling my hair out on this one. anyone have any help on this.

    i am at my wits end on this one





  2. #2
    RuralGuy's Avatar
    RuralGuy is online now Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,899
    What was changed just before the problem showed up?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    denny is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    3
    i talked to our IT, but they say nothing. could be some change to the as400 but why would it work when i hard code the parameter into the query and not when using a prompt. this happens on all my queries that i prompt a parameter for.

  4. #4
    RuralGuy's Avatar
    RuralGuy is online now Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,899
    I don't have a good answer for you, sorry. I don't even have another suggestion to offer at this time.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to run parameter query from VBA
    By John Southern in forum Programming
    Replies: 10
    Last Post: 02-07-2014, 02:24 PM
  2. Replies: 3
    Last Post: 02-15-2011, 05:24 AM
  3. Parameter Query doesn't work
    By Kimmie in forum Access
    Replies: 5
    Last Post: 10-07-2010, 01:30 PM
  4. Parameter query
    By doss13 in forum Queries
    Replies: 1
    Last Post: 06-26-2010, 06:11 AM
  5. Parameter Query help...
    By daggy in forum Queries
    Replies: 1
    Last Post: 05-11-2010, 01:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums