How to add fields to an existing table using VBA

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
How to add fields to an existing table using VBA

Access VBA Discuss using VBA for Access programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

March 22nd, 2006, 12:03 PM

donrafeal

donrafeal is offline

Authorized User

Join Date: Apr 2004

Posts: 22

Thanks: 0

Thanked 0 Times in 0 Posts

Default

How to add fields to an existing table using VBA

How do I add fields to an existing table using VBA?

Old

March 22nd, 2006, 12:17 PM

Bob Bedell Bob Bedell is offline

Bob Bedell is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 1,093

Thanks: 1

Thanked 12 Times in 11 Posts

Default

Something like:

Sub AddColumn()

CurrentDb.Execute ("ALTER TABLE Table1 ADD COLUMN Column2 Text;")

End Sub

Set a reference to DAO.

HTH,

Bob

Old

March 22nd, 2006, 12:21 PM

Bob Bedell Bob Bedell is offline

Bob Bedell is offline

Friend of Wrox

Join Date: Jun 2003

Posts: 1,093

Thanks: 1

Thanked 12 Times in 11 Posts

Default

Don't even need the DAO reference. CurrentDb.Execute runs with out it.

Bob

Old

March 22nd, 2006, 06:11 PM

donrafeal

donrafeal is offline

Authorized User

Join Date: Apr 2004

Posts: 22

Thanks: 0

Thanked 0 Times in 0 Posts

Default

Thanks, I'll give it a try in a couple of weeks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Renaming fields in access table using VBA	imaley	Access VBA	13	August 13th, 2009 02:22 PM
Add a new record between two existing records	hsncompany	BOOK: Beginning Access 2003 VBA	0	April 13th, 2008 03:36 PM
How to replace pivot table data fields using VBA?	rstober	Excel VBA	2	August 19th, 2005 06:06 AM
Add an attribute to existing table	peter_budo	SQL Language	9	April 24th, 2005 01:35 PM
javascript - add element to existing xml?	willgotoo	XML	4	October 8th, 2004 09:33 AM