Last question was so helpful. Here is another that I have
not been able to solve and left as is for lack of
knowledge.

I have a form that is called utility. We have several
master mdb files that get used as templates for several
jobs. The utility copies the requested template(mdb file)
to a given job directory to a new provided name (name and
path are requested on the form in utitlity.mdb). The
problem is the person has to close the utility.mdb and
then locate the job directory and open the new mdb file.

Is there a procedure that would close the utility.mdb and
open the new mdb using the path and file name provided on
form in the utility.mdb?

Thanks...

Thought I tried this a few years ago. Maybe 2002 works
better than older versions as this time it worked with the
quit. I think in 95 you could not quit while in the vb
code if you openned another database...
Is this the proper way however???????
Dim MyAppID, ReturnValue
'open the new file
'MyAppID = Shell("C:\Program Files\Microsoft
Office\Office10\msaccess.exe Y:\Jobs\2005Jobs\205017
\NCmodel\NC-test3.mdb", 1)
Docmd.Quit

>-----Original Message-----
>Last question was so helpful. Here is another that I
have
>not been able to solve and left as is for lack of
>knowledge.
>
>I have a form that is called utility. We have several
>master mdb files that get used as templates for several
>jobs. The utility copies the requested template(mdb
file)
>to a given job directory to a new provided name (name and
>path are requested on the form in utitlity.mdb). The
>problem is the person has to close the utility.mdb and
>then locate the job directory and open the new mdb file.
>
>Is there a procedure that would close the utility.mdb and
>open the new mdb using the path and file name provided on
>form in the utility.mdb?
>
>Thanks...
>
>
>.
>

On Fri, 18 Feb 2005 09:24:31 -0800, "Terry"
<(E-Mail Removed)> wrote:

>Last question was so helpful. Here is another that I have
>not been able to solve and left as is for lack of
>knowledge.
>
>I have a form that is called utility. We have several
>master mdb files that get used as templates for several
>jobs. The utility copies the requested template(mdb file)
>to a given job directory to a new provided name (name and
>path are requested on the form in utitlity.mdb). The
>problem is the person has to close the utility.mdb and
>then locate the job directory and open the new mdb file.
>
>Is there a procedure that would close the utility.mdb and
>open the new mdb using the path and file name provided on
>form in the utility.mdb?
>
>Thanks...
>

Shell Environ("comspec") & " /c " &chr(34) &"newDbPatrhName" &chr(34)
Application.Quit

---
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW

Check MichKa's (TSI) utility called TSI SOON (Shut One, Open New)

http://www.trigeminal.com/lang/1033/...asp?ItemID=8#8

--
HTH
Van T. Dinh
MVP (Access)


"Terry" <(E-Mail Removed)> wrote in message
news:059701c515de$b4cd8ce0$(E-Mail Removed)...
> Last question was so helpful. Here is another that I have
> not been able to solve and left as is for lack of
> knowledge.
>
> I have a form that is called utility. We have several
> master mdb files that get used as templates for several
> jobs. The utility copies the requested template(mdb file)
> to a given job directory to a new provided name (name and
> path are requested on the form in utitlity.mdb). The
> problem is the person has to close the utility.mdb and
> then locate the job directory and open the new mdb file.
>
> Is there a procedure that would close the utility.mdb and
> open the new mdb using the path and file name provided on
> form in the utility.mdb?
>
> Thanks...
>
>