Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Maine, USA
    Posts
    258
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Parameter value of WHAT? (2000)

    I am getting an "Enter Parameter Value" box when opening a form. The problem is, that the field that it wants a parameter value for has a longer name than can show on the Parameter box, which as near as I can tell cannot be sized to show the whole thing. How can I find out what field it is looking for a parameter value for so I can find and fix it?
    (I had several queries that pulled information from other forms underlying the default values for fields on this form, and I'm trying to remove those queries, but apparently I've missed one. So it's looking for for a parameter value for Forms!FormName!FieldName - but I can't see the whole field name. If I could it would give me a clue which field has this leftover query. I THINK I've searched the data properties in all of them, but since I'm still getting this message, I must be missing one)

    Thanks for any help. I am tearing my hair! <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>
    -cynthia

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Parameter value of WHAT? (2000)

    If you have a search tool such as Find and Replace from Rick Fisher (you can download a free evaluation copy if you don't), you can search tables, queries and forms for the part of the parameter that you can see.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Maine, USA
    Posts
    258
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Parameter value of WHAT? (2000)

    Thank you! This might be a good solution to all KINDS of things that get buried deep inside Access applications.
    -cynthia

  4. #4
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Maine, USA
    Posts
    258
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Parameter value of WHAT? (2000)

    Well, I installed that Add-in, but the Add-in manager couldn't find it. He has info on that problem in his help files, but I decided I was investing too much time in fixing the fix. It looks like a great little Add-in, so I think I'll tinker with that at a later date.

    HOWEVER - just getting out of my rut by starting down that road you proposed...I had a new idea. I temporarily significantly shortened the name of the form I could see that it was looking for, so that more of the field name would show in the parameter window (since Access2000 seems to transfer these kinds of changes to queries, which I don't believe Access 97 did). That gave me enough of a clue to realize which field was having the problem.

    Thanks! And I'll look forward to exploring the Find and Replace Add-in later on.
    -cynthia

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Parameter value of WHAT? (2000)

    Access 2000 only "seems to transfer these kinds of changes to queries" if you have Name Autocorrect turned on. Unfortunately, having it turned on is responsible for the lion's share of wierd behavior in Access 2000 and has a huge impact on both bloat and slow performance. I recommend turning it off in every database and making sure you keep it that way.
    Charlotte

  6. #6
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Maine, USA
    Posts
    258
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Parameter value of WHAT? (2000)

    Thanks for the tip, Charlotte. It seems like a nice feature. Too bad it's flukey! I'll turn it off.
    -cynthia

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Parameter value of WHAT? (2000)

    Name AutoCorrect not only causes weird behavior, but it also slows down opening forms etc.

    If you get Find and Replace to work, you can use that to change names globally in your database; I have never had problems with that.

    Another such utility is SpeedFerret from Black Moshannon Systems. They also have a free demo download. It is more expensive to purchase than Find and Replace, but it has a broader scope - Access 97-2002, Visual Basic 5 and 6 and SQL Server 6.5, 7 and 2000.

Posting Permissions

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