DBEngine in Form's macro

[Alan T]

I have several sub functions in my form's macro page, some of the sub
function has the following codes:
Dim myDB As Database
myDB = DBEngine.Workspaces(0).Databases(0)

Can I have these codes in more than one sub function?

 

[Steve Schapel]

Alan,

This is not a macro. This is part of a VBA procedure. And yes, you can
use this code within more than one procedure.

 

[Tom Wickerath MDB]

DAO is obsolete; and it has been for 10 years

 

['69 Camaro]

Everyone please note that Aaron Kem.pf is attempting to impersonate one of
our regular posters again. Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.