Parameter value of WHAT? (2000)

Topic

New Reply

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!
-cynthia

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote