I have many big tables that where imported to Access. Now I want to add the
field description for them.
Is there any easy way to do that?
Thanks.
Ahron

Open the Table in Design View and you can add Field Description to each
Field.

--
HTH
Van T. Dinh
MVP (Access)



"Ahron Berdugo" <Ahron (E-Mail Removed)> wrote in message
news:193CAFDD-FA98-40DD-9005-(E-Mail Removed)...
>I have many big tables that where imported to Access. Now I want to add the
> field description for them.
> Is there any easy way to do that?
> Thanks.
> Ahron

Thank you,

Maybe i was not clear enough.
I want to add it automaticaly. I have the description in another table (as
records) and i want to add them to the original table. Copy Paste is too much
time consuming (around 2000 fields in several tables)

Thanks.

"Van T. Dinh" wrote:

> Open the Table in Design View and you can add Field Description to each
> Field.
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "Ahron Berdugo" <Ahron (E-Mail Removed)> wrote in message
> news:193CAFDD-FA98-40DD-9005-(E-Mail Removed)...
> >I have many big tables that where imported to Access. Now I want to add the
> > field description for them.
> > Is there any easy way to do that?
> > Thanks.
> > Ahron
>
>
>

It can be done, providing there is a way to determine which description
should be used for a specific field. Please provide more information about
table design and contents.

--
Gerwin Berentschot
(E-Mail Removed).(nospam)
Mr. Access - Access development and training



"Ahron Berdugo" wrote:

> Thank you,
>
> Maybe i was not clear enough.
> I want to add it automaticaly. I have the description in another table (as
> records) and i want to add them to the original table. Copy Paste is too much
> time consuming (around 2000 fields in several tables)
>
> Thanks.
>
> "Van T. Dinh" wrote:
>
> > Open the Table in Design View and you can add Field Description to each
> > Field.
> >
> > --
> > HTH
> > Van T. Dinh
> > MVP (Access)
> >
> >
> >
> > "Ahron Berdugo" <Ahron (E-Mail Removed)> wrote in message
> > news:193CAFDD-FA98-40DD-9005-(E-Mail Removed)...
> > >I have many big tables that where imported to Access. Now I want to add the
> > > field description for them.
> > > Is there any easy way to do that?
> > > Thanks.
> > > Ahron
> >
> >
> >

Field Description is an Access Property, not JET Property so you need to use
the CreateProperty method to create the Property "Description".

Check Access VB Help (DAO section) on the CreateProperty method. There are
some sample code in this Help topic also.

--
HTH
Van T. Dinh
MVP (Access)



"Ahron Berdugo" <(E-Mail Removed)> wrote in message
news:4ED47E4F-D4F6-4C59-96C7-(E-Mail Removed)...
> Thank you,
>
> Maybe i was not clear enough.
> I want to add it automaticaly. I have the description in another table (as
> records) and i want to add them to the original table. Copy Paste is too
> much
> time consuming (around 2000 fields in several tables)
>
> Thanks.
>