By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,902 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

How to open mdb in background?

P: n/a
Is there a more efficient way to open an mdb to do stuff with it
programmatically? I'm using the below code to open another database and
inventory the form properties. I've got to open and close the database a
lot and I'm wondering if there's a better way to do it - and avoid all the
screen flashing.

Dim acc As Access.Application
Set acc = CreateObject("Access.Application")
Application.Echo False
acc.OpenCurrentDatabase varPath
acc.Visible = False
acc.DoCmd.OpenForm strName, View:=acDesign, WindowMode:=acHidden
Set frm = acc.Forms(strName)
[get form properties]
Application.Echo True
Thanks!
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Fri, 16 Jan 2004 03:29:01 GMT, "deko" <dj****@hotmail.com> wrote:

Keep it open, and send multiple commands to it.
-Tom.

Is there a more efficient way to open an mdb to do stuff with it
programmatically? I'm using the below code to open another database and
inventory the form properties. I've got to open and close the database a
lot and I'm wondering if there's a better way to do it - and avoid all the
screen flashing.

Dim acc As Access.Application
Set acc = CreateObject("Access.Application")
Application.Echo False
acc.OpenCurrentDatabase varPath
acc.Visible = False
acc.DoCmd.OpenForm strName, View:=acDesign, WindowMode:=acHidden
Set frm = acc.Forms(strName)
[get form properties]
Application.Echo True
Thanks!


Nov 12 '05 #2

P: n/a
10-4

that would make sense...
"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:ks********************************@4ax.com...
On Fri, 16 Jan 2004 03:29:01 GMT, "deko" <dj****@hotmail.com> wrote:

Keep it open, and send multiple commands to it.
-Tom.

Is there a more efficient way to open an mdb to do stuff with it
programmatically? I'm using the below code to open another database and
inventory the form properties. I've got to open and close the database a
lot and I'm wondering if there's a better way to do it - and avoid all thescreen flashing.

Dim acc As Access.Application
Set acc = CreateObject("Access.Application")
Application.Echo False
acc.OpenCurrentDatabase varPath
acc.Visible = False
acc.DoCmd.OpenForm strName, View:=acDesign, WindowMode:=acHidden
Set frm = acc.Forms(strName)
[get form properties]
Application.Echo True
Thanks!

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.