Some files can contain viruses...
"Some files can contain viruses or otherwise be harmful to your computer." How to disable the annoying warning message?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Some files can contain viruses or otherwise be harmful to your computer.
It is important to be certain that this file is from a trustworthy source.
Would you like to open this file?
Is there a way to keep this window from popping up?
I've tried "DoCmd.SetWarnings False" but it didn't work
Some files can contain viruses or otherwise be harmful etc etc
Would you like to open this file - Yes / No
The file is opened using the following code to construct the file name so it does not use a hyperlink field on the form which I know is a problem.
stCompanyName = "Haulage"
stPricingFile = Me.PricingId & stCompanyName
stFileName = "S:\CRMQuotes\" & stCompanyName & "\PricingMatrix\" & stPricingFile & ".pdf"
Macro security is set to low
I want to update one of two files. How do I compare these two files. Both files should have same First and Last name . Id appreciate answers.
It is required because all the files will be moved from their current places to another file share so these accdb files will lose their connections to the linked files and they will become useless completely.
Somehow these paths need to be updated automatically. We are talking about hundreds of files, there's no solution to do it manually, it is impossible in a short term.
I have another question regarding the validation data project that I am currently working on.
I need to validate two CSV files everyday.
However I have a concern right now, since I receive 2 CSV files everyday and I will be using MS Access to compare the two files everyday.
Is it possible for MS Access to automatically retrieve these files and allow user to compare the files?
(1) When I convert each file to access it seems impossible to get rid of the root excel files. I guess that could be a blessing because it would be easy to modify through the root excel files. But I wonder if in the long run it might some way be a problem.
(2) I would like the primary key fields to be the plants names rather than numerical code and I wonder if that will work ok.
I tried to attach sample excel files to this note but my 2010 excel files were not accepted
in XP my installer program I made myself created a folder in the Program Files folder of the users computer and these files were saved there.
I then put a link on the users desktop to a small program that called the database.
Now we are going to big school now and I have to create a new installer for Windows 7.
So my question is where should I be saving my files.
I notice that if I now want to save files in Program Files the user is going to have to elevate my .exe or other program under UAC.
It seems that what I have to do now is save my files in two places. Static files that are only read can be in program files and then anything that is read and written to such as a userssettings saved in an .ini file would have to be in there own user folder.
In other words, only one file per hyperlink per cell in Access?
now I have three files stored in one column, but they all have different hyperlinks. When a link is created, all three files go to that URL, but this is not wanted.
I would like to make a parameter query to show files which were current at a particular time period - I.e. files that were received on or before a certain date (to be entered) AND files that were completed on or after a certain date (to be entered) OR files that are not completed (completed field is null).