advanced microsoft access training courses in london

advanced microsoft access training courses in london - VBA

Resolved · Low Priority · Version Standard

VBA

Thomas has attended:
No courses

by - delegate Thomas [1 post] (2007 May 4 Fri, 10:38) Reply

What code should I use to connect to a database and recordset within VBA in Access? Is there a short name to refer to the database that the module (in which you are writing VBA) resides in?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 3 Wed	Southwark	5	book now	£219	£235
2003	2008 Dec 19 Fri	Bloomsbury	5	book now	£219	£235
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
2003	2009 Jan 14 Wed	Bloomsbury	8	book now	£187	£224
2003	2009 Jan 23 Fri	Bloomsbury	7	book now	£203	£230
Full Schedule: See all 45 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: VBA

by - trainer David gold contributer [428 posts] (2007 Jun 1 Fri, 10:04) Reply

Hi Thomas

There are a number of ways of connecting to an access database, and it really does depend on the current setting for your access database. Please see the link below for the most common and newest form of database connection.

Access database vba connect

Hope this helps

David