Adding a field to an existing table via a module

's Computer Specifications

I am trying to add a field to an existing table via a module as part of an
application. I am a new VB user and am unsure of the sytax to use. Can
anyone help.

Thanks

's Computer Specifications

Here a code snipset:

dbsData.TableDefs.Refresh
Set tdf = dbsData.TableDefs("MyTable")
Set fld = tdf.CreateField("NewField", dbText, 50)
tdf.fields.Append fld
Set tdf = Nothing
HTH
--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

"Deece" <(E-Mail Removed)> wrote in message
news:49737942-2AC1-4B92-9281-(E-Mail Removed)...
>I am trying to add a field to an existing table via a module as part of an
> application. I am a new VB user and am unsure of the sytax to use. Can
> anyone help.
>
> Thanks
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding field to an existing table	=?Utf-8?B?SlQ=?=	Microsoft Access VBA Modules	2	1st Nov 2007 02:24 PM
Problem adding a field to an existing Table	=?Utf-8?B?cm9iYmll?=	Microsoft Access Getting Started	3	25th Oct 2007 03:26 PM
Adding field to existing table	ReidarT	Microsoft Access Form Coding	2	21st Apr 2004 12:55 PM
Adding a Field using VB to an existing table.	Bobbak	Microsoft Access Forms	8	30th Oct 2003 04:43 AM
Adding a Field using VB to an existing table.	Bobbak	Microsoft Access Form Coding	9	30th Oct 2003 04:43 AM