Question On Opening a DB

[Guest]

I'm using the code below to open a database from another database.

How do I make the newly opened database the current windows application,
and how to I maximize the window?

Thanks in advance for your help.

Const strConPathToPurchase = "\\wrobuff2\purchase log\"

Dim strDB As String

strDB = strConPathToPurchase & "purchase log.mdb"
Set appAccess = _
CreateObject("Access.Application.8")
appAccess.OpenCurrentDatabase strDB
appAccess.DoCmd.OpenForm "frmPurchaseList"

 

[Guest]

Anne

Did u ever work out how to do this?

I have been waiting for a response to your ? as have similar problem.

If u can help greatly appreciate.

Miles

 

[Guest]

Oh C'mon - someone must know how to solve this simple problem!!

 

[Tim Ferguson]

Oh C'mon - someone must know how to solve this simple problem!!

Have you looked up help on the methods of the access Application object?
Perhaps something along the lines of .Activate or .Maximise..?

Tim F

 

[Perturbed by (Oxy)Morons]

Oh C'mon - someone must know how to solve this simple problem!!

Simple. And yet in just over two weeks I notice you haven't figured it out.

A bit rude, don't you think?

 

[Guest]

Hi, have you managed to solve this problem yet as I am stuck on the very same
thing. I think I'm going mad. The documentation regarding this method is
nearly as poor as the method itself. This looks like another half hearted
attempt by MS to provide us with extremely usefull functionality and failing
miserably just like Conditional Formatting, ha ha what a joke that is! I wish
I could send a bill - to BIll for the countless hours of wasted time I have
spent, fighting to open another database from a databse and colouring in text
boxes when they meet criteria. I agree with you, should be simple but isn't!!
I think all the MS programmers were called over to .NET to help out and are
too busy patting themselves on the back to finish off VBA. I am, I'm going
mad. Anyway sorry to go on but any help would be hugely appreciated before I
jack it all in and go and sell shells on a beach somewhere to tourists and
chill out and never pick a laptop ever again.
regards Dave