Disabling Message alerts

[KeythStone]

Hello and Thanks to All,

I am trying to auto publish files with some having date stamps in the file name and others which are replacing old files. My trouble comes in when I want to replace a file. It asks if I want to replace the file (Same name). Yes, to answer the questions. But really, I want this process to be automated and so I'm left thinking how can I:

1. Disable the message alerts so that it will automatically replace the older file with confirmation from the user.

2. Us a program to basically click "Yes" automatically.

What program would i be using? ClickYes?
How do I go about this?

Thanks again,
KeythStone

 

[Joe4]

Is this part of the Access project you are working on?

If so, you can shut off the warnings.
In Access Macros, it is the SetWarnings command (set to "No").
In Access VBA, it would look like:

DoCmd.SetWarnings False

 

[Joe4]

Based on your previous thread from today, I assumed this was an Access question and move it to the appropriate forum. If it is not, please let me know and I will move it to wherever it needs to go.

 

[KeythStone]

To All,

Actually I had posted to that forum b/c it pertained to Microsoft Windows Exploerer settings at large, not an Access application delimma.

When I am saving to a shared network drive folder and want to replace a file I'd like not to have to deal with the "Confirm File Replace" message question that pops up. Reason being that I am automating this publication process.
Some files I will date stamp, as some gracious folks helped out with earlier. There are other files which will simply be replaced.

Question include:
Will I hit that message if I automate the publishing process?
Can I get around the message?
Is there a program which auto clicks on "yes" every time I want it to do so?
What else can I do to successfully publish/replace a file automatically without Windows asking if I DO want to replace the file.

Thanks,
KeythStone

 

[Joe4]

How do you plan to automate the publication process?
What program do you intend to use (Access, batch files, VB Scripting, etc)?

I think whatever program you intend to use to build the "automated process", that is where you would need to "handle" the alerts.
If you want to use Access, the method I gave you should work. Otherwise, let us know which program you intend to use.

 

[KeythStone]

Yeah,

So I'm using Access.
In the Macro, I set Message Alerts to No.

Message still pops up, making me think that it's not a message from Access but from my OS; Explorer or something.

I've done some research online: How to disable message alerts such as this one (Confirm File Replace, Do you want to replace this file? Yes, Cancel). To no avail...

And here we are

Thanks,
KeythStone

 

[Joe4]

Sometimes it depends on the method that you are writing/saving the file (sometimes there are optional arguments that you can set in the function itself to avoid these).

What exactly does the code you have that saves/overwrites the file look like?

 

[boblarson]

How about this in VBA:

Dim strFile As String
 
strFile = "C:\FolderName\FileName.xls"
If Dir(strFile) <> vbNullString Then
   Kill strFile
End If

And then do the publish.

 

[KeythStone]

When saving a file with date stamp:

Dim StrDocIPC As String
StrDocIPC = "F:\OP_CS\Client Reporting\TEST\ipc_" & Format(Date, "yyyymmdd") & ".pdf"
DoCmd.OpenReport "AIM (Assignment,DB)_IPC", acViewPreview, "", "", acIcon
DoCmd.OutputTo acOutputReport, "AIM (Assignment,DB)_IPC", "PDFFormat(*.pdf)", StrDocIPC, False, "", 0, acExportQualityPrint
DoCmd.Close acReport, "AIM (Assignment,DB)_IPC"

When saving a file to replace:

DoCmd.OpenReport "AIM (Assignment,DB)_UPDINS", acViewPreview, "", "", acIcon
DoCmd.OutputTo acOutputReport, "AIM (Assignment,DB)_UPDINS", "PDFFormat(*.pdf)", "F:\OP_CS\Client Reporting\TEST\updins.pdf", False, "", 0, acExportQualityPrint
DoCmd.Close acReport, "AIM (Assignment,DB)_UPDINS"

I haven't begun modifying the second set of code to account for "replacing a file with same name," it's just my usual output_to code.

Thanks,
KeythStone

 

[KeythStone]

boblarson: Thanks i used that code segment and it works. I don't get a confirmation message anymore.
To all: Thanks again for all your help