Finders Sweepers

[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

 

[Albert D. Kallal]

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 ?

 

[Dirk Goldgar]

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.

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.

 

[Jan Il]

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 ?

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

Jan

 

[Jan Il]

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.

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

 

[Nick Coe \(UK\)]

I have used Speed Ferret for years:
http://www.moshannon.com

And Rick Fisher's Find and Replace gets good reports:
http://www.rickworld.com/products.html

 

[Jan Il]

Hi Nick

I have used Speed Ferret for years:
http://www.moshannon.com

And Rick Fisher's Find and Replace gets good reports:
http://www.rickworld.com/products.html

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)

Jan

 

[Lynn Trapp]

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)

Oh the joys of trying to clean up code...

 

[Jan Il]

Hey Lynn!

Oh the joys of trying to clean up code...

......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

 

[Lynn Trapp]

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.

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

 

[Jan Il]

Hi Lynn

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

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

 

[Lynn Trapp]

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?

Hmmmmmmmm...that ought to be the right one, but then like I said, don't
quote me.

 

[Jan Il]

Ah, Northern VA...a lovely place. How long have you been out there?

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.

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

 

[Lynn Trapp]

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.

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.

Well, it's a puzzle to me. I have A2002 Professional here at work and the
Add-ins menu is fully available to me.

 

[Jan Il]

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.

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.

'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

 

[Lynn Trapp]

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.

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

Aha! Way to go, Jan. Didn't I tell you that, if you keep this up, you would
be teaching me things about Access?

 

[Jan Il]

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.

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?

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

Jan

 

[Lynn Trapp]

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. ;-)

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.

 

[Jan Il]

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.

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

 

[Fred Boer]

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