RE: Question On Opening a DB

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



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
"AussieInNZ" wrote:

> Oh C'mon - someone must know how to solve this simple problem!!
> --
> LqdGold
>
>
> "Anne" wrote:
>
> > 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"
> >
.



Relevant Pages

  • RE: Question On Opening a DB
    ... I have been waiting for a response to your? ... > 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, ... > Dim strDB As String ...
    (microsoft.public.access.modulesdaovba)
  • RE: Question On Opening a DB
    ... "Anne" wrote: ... > 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, ... > Dim strDB As String ...
    (microsoft.public.access.modulesdaovba)
  • SourceForge.net Sitewide Update: Jan 26th, 2005 (fwd)
    ... I just returned from an enjoyable Open Source conference in Hawaii ... open sourced the database under the name Derby. ... The CVS client SF.net staff recommend for MS Windows users is ... priority technical support. ...
    (comp.os.linux.announce)
  • Re: Is this possible??
    ... I understand Windows security but since I've not seen A2007 live, ... The backend is on the server in it's own file. ... database, but everyone does not need to have access to tblwage which is ...
    (microsoft.public.access.tablesdbdesign)
  • Re: How many companies are buying new AS400s
    ... Just like you do in iSeries navigator. ... SAVEPOINTs and ROLLBACKs are easy in any database that supports them, but what about analysis of the actual individual entries? ... Is it as easy to do this in Windows or Linux? ... I know how OS/400 work management lets me tune it so the customer is happy during those three or four minutes and is just as happy during the remaining 23:56 of the day. ...
    (comp.sys.ibm.as400.misc)