Hi Gurus

I am still looking for a way to start one database with another. That is, I
have a form where the user can click a button that closes the existing
database and opens an another one. Does anyone know how to do that???

Tia alias cheers

- Nicolaas

Yep. michka knows.

Go to www.trigeminal.com, and look at their TSOON utilitiy (Shut One, Open
Next).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"WindAndWaves" <access@ngaru.com> wrote in message
news:uVhPc.7972$N77.398832@news.xtra.co.nz...[color=blue]
>
> I am still looking for a way to start one database with another. That is,[/color]
I[color=blue]
> have a form where the user can click a button that closes the existing
> database and opens an another one. Does anyone know how to do that???[/color]

hey allen,

thank you. Great game btw there in Perth... very exciting.

"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in news:410daca6$0$16328
$5a62ac22@per-qv1-newsreader-01.iinet.net.au:
[color=blue]
> Yep. michka knows.
>
> Go to www.trigeminal.com, and look at their TSOON utilitiy (Shut One, Open
> Next).[/color]

.... or maybe write a couple of lines of code?

Shell SysCmd(acSysCmdAccessDir) & "MsAccess.Exe" _
& " " & Chr(34) & Child & Chr(34), vbNormalFocus
Quit

--
Lyle
--
use iso date format: yyyy-mm-dd
http://www.w3.org/QA/Tips/iso-date
--
The e-mail address isn't, but you could use it to find one.