By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,931 Members | 1,247 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,931 IT Pros & Developers. It's quick & easy.

Rick Fisher's Find and Replace question...

P: n/a
MLH
I've used Rick Fisher's Find & Replace
Add-In for many years. Some of you may
be familiar with it. Last year, I asked Rick
how to limit the searches performed by
his tool to local tables only. He replied
saying to type this in the table spec
field in his application's main window:

=|(%tbl%.attributes and 1073741824) = 0|

It works perfectly. Has saved me immense
amounts of time by restricting attached
tables from the scope of the search.

I'm wondering if anyone, looking at the
criteria Rick supplied me with, can tell
me how it works? That is, is there some
underlying Access principal at work here
in the specification? What is the meaning,
for instance, of the 1073741824 value?
Mar 4 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Tue, 04 Mar 2008 14:56:33 -0500, MLH <CR**@NorthState.netwrote:

Didn't you see that 1073741824 is &H40000000?
So this is testing the Attributes property of the Tabledef for the
second-highest bit to be set.

-Tom.
>I've used Rick Fisher's Find & Replace
Add-In for many years. Some of you may
be familiar with it. Last year, I asked Rick
how to limit the searches performed by
his tool to local tables only. He replied
saying to type this in the table spec
field in his application's main window:

=|(%tbl%.attributes and 1073741824) = 0|

It works perfectly. Has saved me immense
amounts of time by restricting attached
tables from the scope of the search.

I'm wondering if anyone, looking at the
criteria Rick supplied me with, can tell
me how it works? That is, is there some
underlying Access principal at work here
in the specification? What is the meaning,
for instance, of the 1073741824 value?
Mar 5 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.