Switchboard

[Natasha]

Hi All,

Not sure if this is possible or not, but here goes.

I have about 5 databases that I use at any point during the day.

Is there any way of setting up a very basic Database or form, which will have links to all my other databases on it.

So If I click on Button 1, it will take me to the first DB I use etc >

Thanks for you help in advance.

Natasha.

 

[DJL]

You could make a 6th Database and just link all the forms, tables, queries etc. and then build a switchboard that loads the approriate forms.

 

[Natasha]

Thanks for that.

As it happens, that's exactly what I'd decided to do anyway.

As an extra though, On there, I have a link to a utility I use to backup my main database. On this utility, I have to browse in the path the my database.

Is there a piece of code I can use to ensure the backup 'browse' button defaults to a particular directory rather than 'my documents' ?

Thanks in advance

Natasha.
x

 

[David R]

Have you checked Tools>Options, general Tab? There's an option there for changing the default folder for your database. Would that work with your 'switchboard' database?

If you need something more specifically tied to that button, Travis wrote a message once that simply said to use this:

FileCopy "Path\FileName","Path\NewFileName"

HTH,
David R