Topics Search

Save file prompt

Save file prompt
Views: 29
I have a macro that exports a table to an excel file using the OutputTo option in the macro builder. The macro works fine, but every time I run it, I get a prompt that the file already exists, and it asks if I want to over write the existing file. Is there a way to get rid of the prompt and just automatically over write the file?
Sponsored Links:

Similar posts...

 

Prompt users to choose the file path where to save the file

Prompt users to choose the file path where to save the file Icon
I exported the db with the TransferSpreadsheet method, seems like I have to specify the file path when writing the code.

Is there a way that the user can be prompt to choose the file path where to save the file
 

OutputTo Options

OutputTo Options Icon
I am building a button to export reports to an excel spreadsheet. I know how to use the OutputTo with variables to save a file to a specific place.

Example:
DoCmd.OutputTo acOutputReport, stDocName, acFormatXLS, stDocPath, False

But they want the ability to specify the directory location, kind of like when you do a file save as and then select where you want the file to go.
Other than putting a prompt in for them to type in the path/file name, what other options would allow them to specify the location and name of the file?
 

Saving & Overwriting existing Excel files

Saving & Overwriting existing Excel files Icon
I am using a macro to run and save queries into existing Excel files. I get a prompt for every file, there are nine, asking if I want to overwite the existing file and I am asked to answer yes or know.

I have had a look at similar threads around this and tried using Setwarning to off as the first line of the macro. This worked OK for all of the delete query messages which stopped, but the overwrite message prompt still appears. I even tried putting the Setwarning before every Outputto line, but this didn't work either.

Is it possible to stop the save as prompts using Macro commands
 

Save Prompt....

Save Prompt.... Icon
I have created a Database form which has more than 25 fields (some of which are combo boxes), there are about 1000+ rows.

On selection of a particular client (via Combo box) records are filled in the respective fields (it reads the row information).

Some of the Combo boxes are Distinct.

Currently, if the user selects anything in the Combo box/fields it get updated/saves the information in the master table.

Query
I don't want a save button on the Form - Is it possible to create a prompt which has a save/cancel/undo button - the prompt checks for any changes done on the form that would include anyfield and Combo boxes - the prompt would occur only after the user select another client - the prompt would not occur if no changes are done.
 

Access Does Not Prompt to Save Changes in Design View

Access Does Not Prompt to Save Changes in Design View Icon
Does anyone know why Access 2003 does not prompt me to save changes made in design view. It automatically saves the changes. I looked everyone on the internet and I can't find a resolution to this headache.
 

Opening command prompt and running app with parameters/options

Opening command prompt and running app with  parameters/options Icon
I need to setup our system so it exports a file, and then encrypts it using a specific software.

I got the file exporting, and I can open the command prompt but it doesn't run the supplied information. I've googled around and pieced this bit of code together. Any suggestions would be great.

(By the way, just typing into the command prompt works fine)
 

Saving reports in Word on specified paths

Saving reports in Word on specified paths Icon
I m new to this and have scoured this forum with no avail. I have a report that a user can generate, showing all of the files he's read and the dates he read them, which works perfectly. I want to create a macro that will output to the report to an .rtf file, save the file, and then open the file in Word. Problem is, that I want it to save it on a path to a common folder and have Access save it in that folder as a new file using the primary key (which is the last four of the user's ssn, or can be their last name) as the name of the file. That way each time they update the information and save the report, it will overwrite the previously generated save file, yet it will be stored in the folder under their name/ or last fouras well.

So far, I can get it to save and open the file, but using the macro I can only save each form under one single path and filename (under the "Output File" string
 

Report does NOT open on BUTTON CLICK

Report does NOT open on BUTTON CLICK Icon
I have a button on my form, when user clicks it, it will run

docmd.openreport ("rptDay4")

instead of the report popping up, a box appears showing "now printing" and a save prompt opens asking where I want to save the file
 

Prompt for changes to be saved in Access

Prompt for changes to be saved in Access Icon
Access 2003/XP/2000/97 automatically saves changes to the database when entering information on a form. How can I prompt a user to save changes like in other applications?
 

Export into Excel without saving first?

Export into Excel without saving first? Icon
I have a report that has an Excel and PDF icons and when they are clicked, gives users a prompt to save either in Excel or PDF format.

My question is.would be it possible to override the saving part? Can you export it into Excel first then save? Users just wanna view the file in Excel without having to save the report first.

Is it possible? Can it be done using a macro of some sort