How to find "Missing Parameter Value" in complex Form, Subforms, e

[John D]

I'm developing a complex Form in that the Form has :

- 7 tab controls on which are 7 subforms,
- 5 of the subforms also have subforms (subsubforms)
- 14 saved queries feeding this spider web
- 10 Class modules for forms, subforms, and subsubforms
- a number of Combo and List boxes that have various row source, control
source (etc) properties

So - I'm working along doing further development today, doing lots of stuff,
do some testing and get an "Enter Parameter Value (OrgID)" dialog I haven't
gotten before. Something I did "broke" something. I don't find the problem
when I "backtrack" as best I can. I go through the entire set of forms,
subforms, queries, modules - and still can't find what I broke.

Is there some way to find out WHAT is missing "OrgID" - what query, form,
module, lbo, cbo is not getting a value for OrgID? Seems like there ought to
be a better way than having to dig, dig, dig and hope to run across the
problem.

Thanks - John D

 

[Arvin Meyer [MVP]]

I use a third party program called Speed Ferret to find my problems. In
fairly short order, it will search every property of every object in the
database and present you with a list. You can also limit your search to just
certain objects. It isn't free, and it isn't very cheap either $199, if I
remember correctly, but it is incredibly useful for finding and/or replacing
anything in an Access database, a SQL-Server database, or a VB project.

http://www.speedferret.com

 

[Klatuu]

The problem with Speed Ferret is that it doesn't work with versions newer
than 2000. You can use it with new versions, but you must have an older
version installed for it to work.

I have found it to be a mediocre product from a confused company. They have
been saying they will have a 2003 version out for almost 3 years now. They
even had a big deal for a cheap upgrade if you purchased the (hasn't been
released yet) 5.0 within 30 days of it's release.

I much prefer a $37.00 product from Rich Fisher. You can download a trial
version here:
http://www.rickworld.com/download.html

Also, I use a tool called MZTools that not only has a great find/replace
feature for your VBA code, but some other very valuable features. The price
is good, too. (free)

http://www.mztools.com/v3/download.htm

 

[Arvin Meyer [MVP]]

My copy of Speed Ferret (4.1) works with all versions through Access 2003,
VB 6.0, and SQL-Server 2000. I haven't tested it with later versions. I have
only tried Rick Fisher's product in Access 2.0, and while good, wasn't as
fast as Speed Ferret. The price is certainly much better though.

In the VBA IDE, I am usually happy with the Find and Replace tools in Access
itself. I do use MZTools extensively for other things though. It is an
outstanding addin for Access and VB. Another product you might be interested
in, which is free for personal use is ExamDiff, which is outstanding for
looking at any possible difference in 2 text documents. Using:

http://www.datastrat.com/Code/DocDatabase.txt

will save the entire database (without the tables0 as text files, making it
easy to check opn the differences in any form, report, or module.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Klatuu]

Thanks for the info, Arvin.
Do you have a version prior to 2003 installed on the same computer you are
using Speed Ferret on in 2003?
I have not tried using it. Their web site says a pre 2003 version installed
is required for it to work on 2003. I took them at their word.

Thanks for the suggestion on the document compare tool. I'll give it a try.

 

[Arvin Meyer [MVP]]

I did have a machine at my old job that had 2003 only installed, but it had
been upgraded from XP, so I can't be sure if something didn't linger.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com