Q Question Boy Mar 27, 2008 #1 Is there an easy vba function... to determine if any table have field to embed objects (images, docs, etc.)? Thank you, QB
Is there an easy vba function... to determine if any table have field to embed objects (images, docs, etc.)? Thank you, QB
T Tom van Stiphout Mar 28, 2008 #2 On Thu, 27 Mar 2008 14:39:00 -0700, Question Boy Sure, just test if currentdb.TableDefs("YourTable").Fields("YourField").Type = dbLongBinary I'm sure you can add the loops over the Tabledefs collection and within that over the Fields collection. -Tom.
On Thu, 27 Mar 2008 14:39:00 -0700, Question Boy Sure, just test if currentdb.TableDefs("YourTable").Fields("YourField").Type = dbLongBinary I'm sure you can add the loops over the Tabledefs collection and within that over the Fields collection. -Tom.
