Force Save Location

[Justin G]

Is it possible to force the destination folder for all form saves by users?
Or at the very least can it be set so that whenever the save-as option is
used the default folder can be set to the same shared folder each time?
Thanks in advance.

 

[John W. Vinson]

On Tue, 18 Aug 2009 11:05:01 -0700, Justin G <Justin

Is it possible to force the destination folder for all form saves by users?
Or at the very least can it be set so that whenever the save-as option is
used the default folder can be set to the same shared folder each time?
Thanks in advance.

What are you "saving"? What kind of "folder"? Is this Microsoft Access we're
talking about? If so, Forms store data in Tables - not in folders.

 

[Justin G]

Sorry, total novice at Access. This would be the created output from Access.
Let's say a customer quote that was created based off user inputted data. We
want to save that file to a network folder but do not want the user to have
access to save anywhere they want.

 

[John W. Vinson]

Sorry, total novice at Access. This would be the created output from Access.
Let's say a customer quote that was created based off user inputted data. We
want to save that file to a network folder but do not want the user to have
access to save anywhere they want.

Again:

What is it that you want to save? A Report (which can be output as a .pdf file
in 2007)? An exported text file? An email?

You can use the VBA functions OutputTo or TransferText to create a file, and
you can specify the folder and filename of the output - but this operation is
fairly advanced VBA, not something that is "built in" to Access; you'll need
to program it yourself.

 

[MailListMgmt]

Is there a way to have separate folders for input & output for every table?
For example, the access tables are saved into C:\tables & when we export the
tables to Excel, those have C:\excel as default settings.

Saved exports only work if you use the same tables, correct? Ours are never
named the same, and I'm just trying to see if I can set different folders as
the default for input & output so I don't have to browse for the different
folders each time I create an Access table.

 

[John W. Vinson]

Is there a way to have separate folders for input & output for every table?
For example, the access tables are saved into C:\tables & when we export the
tables to Excel, those have C:\excel as default settings.

Saved exports only work if you use the same tables, correct? Ours are never
named the same, and I'm just trying to see if I can set different folders as
the default for input & output so I don't have to browse for the different
folders each time I create an Access table.

I'm sorry, we seem to be talking at cross purposes, or perhaps about different
programs!

Access tables are NOT stored external to Access. Unless you're using a linked
table (such as a dBase file or an Excel spreadsheet), and Access Table is an
object *WITHIN* the .mdb or .accdb file. Access tables are NOT stored in
c:\tables, and they cannot be, since they have no independent existance.

Saved exports can be exported... wherever you choose to export them. Exporting
tables is NOT routine in any Access database I use; it's a technique you can
call upon for special purposes, but would not be typically used day to day.

And you would ordinarily create a propertly normalized set of tables ONCE, at
the design phase of a database application, and not create new tables
thereafter.

Evidently you are doing something quite different, and something that I do not
understand. Could you explain?