Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Basalt, Colorado, USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'Enter parameter' dialog for deleted field

    <img src=/S/confused.gif border=0 alt=confused width=15 height=20>When I open a query I get "Enter Parameter downtime.tower_chair_no" dialog. I can leave the parameter blank and everything still works. The field used to exist in the table the query is based upon, but was not needed, so I deleted it from the query and then deleted it from the table.

    Now, the only way I can get the dialog to stop coming up is to put the field back in the table as a dummy field. Apparently there is some reference to the field in the query even though the field is not included in the query.

    Is there any way I can figure out what the reference is so that I can finally get rid of the dummy field. (Not a big deal to leave the field in, it just bugs me to have a field I don't use).

    Thanks,
    Dan

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Enter parameter' dialog for deleted field

    Is it in the Parameters list? (With your query open in design, select Query | Parameters... from the menus)

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Basalt, Colorado, USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Enter parameter' dialog for deleted field

    Found the problem, there was a field in the query which was an expression refering to the useless field. After deleting it, I no longer get the dialog.

    Not sure, but may have originally deleted the field from the table when it was still included in the query, and the expression was created at that time. I did not see the field until just now. <img src=/S/blush.gif border=0 alt=blush width=15 height=15> <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

Posting Permissions

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