Nesting methods in Access VBA

[JGPatrick]

I would appreciate it if someone would clear up a confusion I have about VBA.
When is it OK and when is it not OK to nest methods?

For instance, the following code works fine:

Sub Prac1()

Debug.Print DBEngine.CreateWorkspace("WS1", "Admin", "", dbUseJet).Name

End Sub

But when I try to nest the CreateWorkspace method in the Workspaces.Append
method, the debug.print line generates an error message:

Sub Prac2()

Workspaces.Append DBEngine.CreateWorkspace("WS1", "Admin", "", dbUseJet)

debug.Print Workspaces(1).Name

End Sub

 

[Clifford Bass via AccessMonster.com]

Hi,

See the things I and others wrote about CurrentDB. They apply to the
CreateWorkspace method also. This works:

Sub Prac2()

Dim ws As DAO.Workspace

Set ws = DBEngine.CreateWorkspace("WS1", "Admin", "", dbUseJet)
Workspaces.Append ws

Debug.Print Workspaces(1).Name

End Sub

Clifford Bass

 

[JGPatrick]

Clifford,

Thanks for helping me understand better how VBA works.

 

[Clifford Bass via AccessMonster.com]

Hi,

Glad it was helpful. I also learned some as I looked into it a bit
further than I had in the past.

Clifford Bass