P
Paul Ponzelli
One of our databases has dozens of links to text files that are downloaded
from an external source weekly. Occasionally the fields in the downloaded
files have been modified at their original source, and the fields in the
linked tables will display #Num! instead of the values.
I know how to write VBA code to loop through a group of tables, but I don't
know how to identify those tables that display #Num! in one or more of their
fields. I've noticed that you can't search for those values manually using
the Edit-Find command.
Is there a way I can get VBA to return a list of tables that contain those
#Num! values?
Thanks in advance,
Paul
from an external source weekly. Occasionally the fields in the downloaded
files have been modified at their original source, and the fields in the
linked tables will display #Num! instead of the values.
I know how to write VBA code to loop through a group of tables, but I don't
know how to identify those tables that display #Num! in one or more of their
fields. I've noticed that you can't search for those values manually using
the Edit-Find command.
Is there a way I can get VBA to return a list of tables that contain those
#Num! values?
Thanks in advance,
Paul