advanced microsoft access training courses in london - vba
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » advanced microsoft access training courses in london - VBA

advanced microsoft access training courses in london - VBA

resolvedResolved · Low Priority · Version Standard

replyReply Fri 4 May 2007, 10:38Delegate Thomas said...

Thomas has attended:
No courses

VBA

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?

For upcoming training course dates see: Pricing & availability

replyReply Fri 1 Jun 2007, 10:04Trainer David said...

RE: VBA

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

 

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard