Finders Sweepers

  • Thread starter Thread starter Jan Il
  • Start date Start date
J

Jan Il

Hi all - Access 2002XP, W2K

I have a database in which I need to find all of a specific word,
CheckDBTAmt. There appears to be one that is in the wrong place, and it is
causing me problems with a form, and I can not locate it anywhere. I have
tried the Find feature, but, it does not find it. It is in a control or
module somewhere, but, I cant' find it. If I can have find them one at a
time and confirm they are correct, and find the one that isn't I can delete
it. But, I can't find it. I don't know if it's in a form, a control, or
something that is covert. :/

Is there a way I can do a search of the app that will bring up all these
words so I can check them out? Any suggestions would be very much
appreciated.

Jan :)
 
It is in a control or
module somewhere, but, I cant' find it.

If you do a search while in code, then make sure you check "current project"
when you do the search. this will in fact search all code in forms, reports,
and modules.

If you don't find it...perhaps it is in some sql ?
 
Jan Il said:
Hi all - Access 2002XP, W2K

I have a database in which I need to find all of a specific word,
CheckDBTAmt. There appears to be one that is in the wrong place, and
it is causing me problems with a form, and I can not locate it
anywhere. I have tried the Find feature, but, it does not find it.
It is in a control or module somewhere, but, I cant' find it. If I
can have find them one at a time and confirm they are correct, and
find the one that isn't I can delete it. But, I can't find it. I
don't know if it's in a form, a control, or something that is covert.
:/

Is there a way I can do a search of the app that will bring up all
these words so I can check them out? Any suggestions would be very
much appreciated.
Click to expand...

You can look for it in all the code, of course, but there are lots of
other places it could be hiding. There are commercial tools you can buy
to do searches like this -- some fairly inexpensive -- but I haven't
used any of them.

Here are some places to look:

Queries
RecordSource SQL statements (for forms and reports)
RowSource SQL statements (for combo and list boxes)
Filter properties of forms, reports, and tables
OrderBy properties of forms and reports
Sorting and Grouping entries for reports

If it appears to be a problem with a particular form, you can narrow
down your search quite a bit.
 
Hi Albert :-)
module somewhere, but, I cant' find it.

If you do a search while in code, then make sure you check "current project"
when you do the search. this will in fact search all code in forms, reports,
and modules.

If you don't find it...perhaps it is in some sql ?
Click to expand...

Thank you very much for your suggestions, I'll give it a try and see if I
can locate the thing. :-)

Jan :)
 
Hi Dirk! :-)
You can look for it in all the code, of course, but there are lots of
other places it could be hiding. There are commercial tools you can buy
to do searches like this -- some fairly inexpensive -- but I haven't
used any of them.

Here are some places to look:

Queries
RecordSource SQL statements (for forms and reports)
RowSource SQL statements (for combo and list boxes)
Filter properties of forms, reports, and tables
OrderBy properties of forms and reports
Sorting and Grouping entries for reports

If it appears to be a problem with a particular form, you can narrow
down your search quite a bit.
Click to expand...

Yes, so far it does seem to be creating a problem with just the one form. I
have created a new Record form, and using the criteria from an existing
queries, and filter form, and when I try to open the new form, I get this
Parameter box asking for the CheckDBTAmt. Well...you might remember that
one from a few days back for the other form. There is nothing in the new
form that I know of that relates to this at all, so I'm puzzled as to why it
is doing this. But, as you say, it may be in some of the other related data
that I am referencing. I just thought perhaps there was a way to search for
the word in the overall database. I'll try the areas that you've listed and
see if it shows up.

Thank you very much for your help and suggestions, I really appreciate it.
:-)

Jan :)
 
Thank you very much for the links/information. They seem to be very
helpful
utilities worth having on hand. This is not the first time some such a
'ghost' or 'sprite' has decided to play 'hide 'n seek' with me in an app.
One took me a week or more to find! ;o)
Click to expand...


Oh the joys of trying to clean up code... :-)
 
Hey Lynn! :-)

Lynn Trapp said:
Oh the joys of trying to clean up code... :-)
Click to expand...

......so many codes...yet...so little mind left to try to remember what I did
with 'em. <g>

Now....ahmm......while I have you here.....<heh heh>.....when I open Access,
the Add-Ins are grayed out. See......I was trying the trail version of Rick
Fisher's proggy, and it is supposed to install as an Add-In. But, when I
opened Access and went to look for it, the 'Add-Ins' on the pulldown is
grayed out. What do I need to do to activate the Add-Ins? I don't have any
others yet in the 2002 version.

Jan :)
 
Now....ahmm......while I have you here..... said:
the Add-Ins are grayed out. See......I was trying the trail version of Rick
Fisher's proggy, and it is supposed to install as an Add-In. But, when I
opened Access and went to look for it, the 'Add-Ins' on the pulldown is
grayed out. What do I need to do to activate the Add-Ins? I don't have any
others yet in the 2002 version.
Click to expand...


Hey Jan! How's it going?

Do you have the Professional Edition of Access? I think you have to have
that edition for the Add-ins to be active, but don't quote me on that
one...LOL
 
Hi Lynn :-)
Hey Jan! How's it going?
Click to expand...

Great! Getting settled into my new digs here in Northern VA. said:
Do you have the Professional Edition of Access? I think you have to have
that edition for the Add-ins to be active, but don't quote me on that
one...LOL
Click to expand...

Heh.....backpeddler! ;o))

W'll ....I have the MS Office Professional 2002 XP version. Is that the
same? Or..is the one you are talking about a standalone version?

Jan :)
 
Great! Getting settled into my new digs here in Northern VA. <g>

Ah, Northern VA...a lovely place. How long have you been out there?
W'll ....I have the MS Office Professional 2002 XP version. Is that the
same? Or..is the one you are talking about a standalone version?
Click to expand...

Hmmmmmmmm...that ought to be the right one, but then like I said, don't
quote me.
 
Great! Getting settled into my new digs here in Northern VA. said:
Ah, Northern VA...a lovely place. How long have you been out there?
Click to expand...

I came to visit in July-Aug this summer to some family research. The
Shenandoah Valley and Mts. is the homeland of my Cherokee ancestors, before
they were rounded up and exiled to OK in the Trail of Tears. I liked it so
much, I just up and moved here mid-Oct.
Hmmmmmmmm...that ought to be the right one, but then like I said, don't
quote me.
Click to expand...

This is the first Add-Ins I've tried to add since I got the new program,
which I've had over a year now, so, I'm not sure what the problem might be.
Thought I'd check to see if there was something in Access that I needed to
click, push, check, uncheck, add, delete, close, open or..?.. before I went
to the author of the proggy to see what they suggest. Not much in the Help
file that addresses this kind of situation that I could find.

Jan :)
 
I came to visit in July-Aug this summer to some family research. The
Shenandoah Valley and Mts. is the homeland of my Cherokee ancestors, before
they were rounded up and exiled to OK in the Trail of Tears. I liked it so
much, I just up and moved here mid-Oct.
Click to expand...

So exactly where are you now? I used to live in Baltimore and used to go to
Northern VA quite a bit.
This is the first Add-Ins I've tried to add since I got the new program,
which I've had over a year now, so, I'm not sure what the problem might be.
Thought I'd check to see if there was something in Access that I needed to
click, push, check, uncheck, add, delete, close, open or..?.. before I went
to the author of the proggy to see what they suggest. Not much in the Help
file that addresses this kind of situation that I could find.
Click to expand...

Well, it's a puzzle to me. I have A2002 Professional here at work and the
Add-ins menu is fully available to me.
 
I came to visit in July-Aug this summer to some family research. The
So exactly where are you now? I used to live in Baltimore and used to go to
Northern VA quite a bit.
Click to expand...

A small, ruralish town named Warrenton, kind of a circa 1950's little town
about 45 min. southwest of Washington, DC, and about 20 mins. from Manassas.
Sorta in the heart of the Civil War battlegrounds. And only a few miles
from the Shenandoah Mts. and Valley.
Well, it's a puzzle to me. I have A2002 Professional here at work and the
Add-ins menu is fully available to me.
Click to expand...

'k...here's what I found on the Add-In; Apparently, if left to its own
devices, it stores the files in a Temp folder on the C: drive. So...I guess
Access didn't know where to find it. (???) I decided to uninstall and
reinstall, in case I had not done something correctly, and when it came time
to unzip the files, I entered a folder name where I wanted it to be put
instead, and then finished the install. When I opened Access again I
noticed there was a launch file for the Add-In in the side pane in the
window, so I clicked on that and clicked on the Install tab. Then I opened
the Tools and the Add-Ins was accessible. I clicked on it and the Find and
Repair was there. So, I opened the problem app and then the Add-In and
entered what to find, and it found the problem file within *seconds*!!
Voila! All done, thank you. NEXT!! For the curious, like me, the file
was, as Dirk suggested, in the SQL of one of the queries, one that I had
obviously overlooked several times, as it was really hidden in the complex
code.

HA! Rick's little program is a real keeper! At only $37.00 it's well worth
the money, at least for me, as I'm still trying to find my way around in the
apps. After hunting for 2 days, it found it in less than 2 seconds! Like
having another set of eyes on the job, and a lot better than mine! ;o)

Jan :)
 
A small, ruralish town named Warrenton, kind of a circa 1950's little town
about 45 min. southwest of Washington, DC, and about 20 mins. from Manassas.
Sorta in the heart of the Civil War battlegrounds. And only a few miles
from the Shenandoah Mts. and Valley.
Click to expand...

Now you've done gone and made me jealous. It sounds like an idyllic place.
'k...here's what I found on the Add-In; Apparently, if left to its own
devices, it stores the files in a Temp folder on the C: drive. So...I guess
Access didn't know where to find it. (???) I decided to uninstall and
reinstall, in case I had not done something correctly, and when it came time
to unzip the files, I entered a folder name where I wanted it to be put
instead, and then finished the install. When I opened Access again I
noticed there was a launch file for the Add-In in the side pane in the
window, so I clicked on that and clicked on the Install tab. Then I opened
the Tools and the Add-Ins was accessible. I clicked on it and the Find and
Repair was there. So, I opened the problem app and then the Add-In and
entered what to find, and it found the problem file within *seconds*!!
Voila! All done, thank you. NEXT!!
Click to expand...

Aha! Way to go, Jan. Didn't I tell you that, if you keep this up, you would
be teaching me things about Access?
 
A small, ruralish town named Warrenton, kind of a circa 1950's little
town
Now you've done gone and made me jealous. It sounds like an idyllic place.
Click to expand...

Heh......after living in San Diego/Los Angeles area for 30 years, it surely
is idyllic. I haven't seen fireflies dancing in the night skies since I
left Texas...many moons ago. ;-)
Aha! Way to go, Jan. Didn't I tell you that, if you keep this up, you would
be teaching me things about Access?
Click to expand...

Aye...you did. Now... at least I have one......;o)

Jan :)
 
Heh......after living in San Diego/Los Angeles area for 30 years, it
surely
is idyllic. I haven't seen fireflies dancing in the night skies since I
left Texas...many moons ago. ;-)
Click to expand...

I can imagine that VA is a wonderful change from California. I've never been
to CA and am sure there are some lovely areas, but all I hear about the
cities there scares me worse than Dallas or Houston ever did. Ah, I love
fireflies....we have them here in Iowa every summer too.
 
I can imagine that VA is a wonderful change from California. I've never
been
to CA and am sure there are some lovely areas, but all I hear about the
cities there scares me worse than Dallas or Houston ever did. Ah, I love
fireflies....we have them here in Iowa every summer too.
Click to expand...
Yeah...even the small town of Santee where I lived, which used to be out in
the boonies, made headlines a few years ago with a shooting at our local
high school, Santana High, with 2 dead and 13 wounded, and an unknown number
of walking wounded. One of the wounded kids lived up the street from me.
http://archives.cnn.com/2001/US/03/05/school.shooting.04/

I'll take the fireflies...

Jan :)
 
Hey Lynn:

Happened to see this thread tonight. I saw you mention "Baltimore", and I
immediately began singing: "I love you Baltimore/There's the flasher who
lives next door/There's the bum on his barroom stool/They wish me luck on my
way to school..."

My family and I went twice in the last month to see the Toronto production
of "Hairspray", (my wife's friend played Edna Turnblatt...), and I've
obviously listened to the cd *way* too much lately!

Jan's place seems nice, but she's only 45 minutes from Washington, seat of
the government of the world's most powerful nation! Jan, does it really feel
"out of the way"?! I'm going to look it up on a map!


Fred
 
Back
Top