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

Globally Check Contents Of Table

P: n/a
Tom
I have linked to an Excel spreadsheet with 15 columns. The cells in the
worksheet should only contain a cap X or be blank. Lowercase x is also
acceptable. ("" is not acceptable) Is there a way to globally check the entire
linked table to see if there is anything else but an X, x or blank in any cell
in the table or does this need to be done column by column?

Thanks!

Tom
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
The manual find in Access (the one you get when clicking the binoculars button on the
toolbar) has the option to search an entire form or table for an item. To do it from code,
you would need to do a FindFirst/FindNext on each column.

--
Wayne Morgan
"Tom" <th*******@bellsouth.net> wrote in message
news:aU*****************@newsread1.news.atl.earthl ink.net...
I have linked to an Excel spreadsheet with 15 columns. The cells in the
worksheet should only contain a cap X or be blank. Lowercase x is also
acceptable. ("" is not acceptable) Is there a way to globally check the entire
linked table to see if there is anything else but an X, x or blank in any cell
in the table or does this need to be done column by column?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.