Can't hide code in app variable...

[Matthew Wells]

Hello

I have a variable dim'd as an Access.Application. I have a routine that
adds a few lines of code in a module to another database. But when I open
the module from the app variable, that code window is visible! I've used
the app.visible = false, but that doesn't work. The app.docmd.openmodule
doesn't have a hidden parameter like forms and reports. How do I keep the
code window from popping up?

Here's what I've got:

dim app as Access.Applicaiton
dim sClassName as string

sclassname = "MyClass"

Set app = new Access.Application
App.Visible = False
App.OpenCurrentDatabase <dbname>
App.Visible = False

App.DoCmd.OpenModule sClassName
With App.Modules(sClassName)
.DeleteLines 1, .CountOfLines
.AddFromFile <filename>
End With
App.DoCmd.Save acModule, sClassName
App.DoCmd.Close acModule, sClassName, acSaveNo

I've tried using a module variable, using the acSaveYes option, adding
"app.visible = false" before every line, nothing seems to work.

Any ideas?

Thanks.

Matthew Wells
MW****@FirstByte.net

[Granny Spitz via AccessMonster.com]

Matthew Wells wrote:

How do I keep the
code window from popping up?

The best way is to save the inserted code in a module in a template database
beforehand, then use TransferDatabase to export the module from the template
database to the target database and the user won't see it happening in the
background. Another way is to set Echo off when the other database opens so
the screen doesn't update during the insertion, but the user will still see
*something,* just not the text you're inserting.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200611/1