Tom,
Thank you for responding. Trouble is, the main program has no direct
connection to the DB and is required to send SQL calls to the
component which does. So, for a field called 'Name' in a table called
'Titles" I need to develop a statement such as "SELECT Name.Size FROM
Titles", which, unfortunately, doesn't cut it with Access. But in the
dark recesses of memory I seem to recall that this is doable but
cannot come up with the syntax.
Steve
On May 10, 11:02 pm, Tom van Stiphout <no.spam.tom7...@[EMAIL PROTECTED]
> wrote:
> On Sat, 10 May 2008 19:48:52 -0700 (PDT), stevew <m...@[EMAIL PROTECTED]
>
> wrote:
>
> A table (better: tabledef) has a fields collection, and each field has
> a Properties collection, and one of the properties is Size.
> ?Currentdb.Tabledefs("SomeTable").Fields("SomeField").Properties("Size")
> -> 80
>
> -Tom.
>
> >I'm using SQL within Visual Basic in conjunction with Access
> >databases. Say I am about to insert a record with a long string for a
> >particlar field. It would be useful to prevent errors to first
> >interrogate the DB to learn the maximum permissible length of that
> >field, and only then proceed to write the record. I believe I've seen
> >that done -- i.e., get Access field properties -- but don't know the
> >SQL syntax. Can anyone give me a sample?
>
> >Thank you in advance.
> >Steve
|
