vba courses london - Microsoft Access, VBA

The UK's most regular instructor-led training courses.
Training information: vba courses london · Courses in microsoft access · Microsoft Office VBA training

Resolved · Low Priority · Version Standard

Microsoft Access, VBA

James has attended:
Access VBA course

by - delegate James [1 post] (2007 May 29 Tue, 11:57) Reply

Hi,

After creating a recordset, I was wondering how to add a new field onto a recordset and also the table that it is linked back to?

Thanks,

James

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Bayswater	0	FULL
2003	2008 Sep 3 Wed	Southwark	3	book now	£224	£235
2007	2008 Sep 24 Wed	Bloomsbury	0	FULL
2003	2008 Oct 8 Wed	Southwark	5	book now	£219	£235
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£190	£224
2003	2008 Oct 29 Wed	Bayswater	8	book now	£110	£224
Full Schedule: See all 55 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Microsoft Access, VBA

by - trainer Roy [23 posts] (2007 May 29 Tue, 19:10) Reply

Looks like you want the Fields.Append operation:

Fields.Append Name, Type, DefinedSize, Attrib, FieldValue

Find this in the Object Browser and read the Help page. Note that you have to append the field before you open the RecSet.

Sorry you found the course a bit slow, but I think it was OK for the other guys.

/Roy

· Material covered on a Microsoft Access Course
· Access VBA Handling Errors and Debugging Code
· Tips for designing databases in Microsoft Access
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Why consider Access Visual Basic training?

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips