Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Posts
    111

    Unanswered: [Enter Parameter Value] pops-up when executing a Query...

    in MS Access due to an SQL backend <bit> type. I'm pretty sure this is the cause as I have done 'a few' combinations of test which eliminates any other probable cause.

    More details:
    The MS Access Query uses a field in its <Where> clause filter. The table column behind this field is a <bit> type.
    I am using SQL Server 2005 backend and MS Access 2003.

    Many thanks in advance.

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580
    post the SQL pls.
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,418
    Provided Answers: 7
    when I get the pop up [Enter Parameter Value] most of the time its trying to display a feild value and that feild does not exist.

    or

    you are run a query that pointing to and other query which is pointing to and other query which has the [Enter Parameter Value] in it.



    what I do is [input start date ??] I use the ?? then I know I'm asking the Questions and it not the computer asking me for a missing feild
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

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