Save file prompt
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Is there a way that the user can be prompt to choose the file path where to save the file
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?
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
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.
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.
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)
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
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
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