Some files can contain viruses...
Suppress Office warning when running batch file from within access 2010
I have a batch file that runs when I click on a command button on a form. It makes a backup of all my files and resources for the database. When I click the button, Access gives me a warning saying:
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
Virus Security Warning Opening PDF
I have a cmd button that opens pdf files saved on the server. This works fine on a number of PCs but on 1 machine the user keeps getting the warning:
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
Comparing a table or query from two different files
I have a lot of Macess files, sometimes I want to compare two tables from two different files if they have same information or one file is missing information the other file has. For exp. I have a lot of addresses in all the files.
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.
Updating all the references to external files in .accdb files
Does anyone knows a solution to change the path of the linked files in an Access database file? I'm thinking in a script, first we need to get the list from the accdb about the existingfile references, then modify them.
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.
Access - Automatical retrieve files
Dear MS Access super users.
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?
Importing multiple files at once
I am looking for an easy way to import multiple files (50 ) Pipe Delimited txt files into a table (Append to all 1 table) so I can do some data manipulation. All the files have a different file name; however, have the same layout. I am not too familiar with VBA.
Importing multiple files at once
I really need some help. I am looking for an easy way to import multiple files (50+) Pipe Delimited txt files into a table (Append to all 1 table) so I can do some data manipulation. All the files have a different file name; however, have the same layout. I am not too familiar with VBA.
Converting excel files to access files for an online nursery plant pricelist
I have some 2010 excel files with thousands of rows of information that I have used for years to produce our nursery online pricelist. Now we are re-organizing our nursery and pricelist and I want to convert to access files. But I have several questions.
(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
Where to added/install a database file in Windows 7
I have an A2007 file with a lot of helper files such as Office templates, and icons and other files used by Access to do its job e.g. an ini file for settings and multi language things.
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.
Hyperlinks in access
If a field contains multiple files that need to be hyperlinked in a column, do I need to separate those files into different columns?
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.
Query on or before date
I have a table for files in our office. There is a field for date files are received and a field for date files are completed.
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).
Use files from other Office programs in your Access forms and reports
Using files from other Office programs
The concepts you must understand in order to use files correctly, such as whether to link or embed them, and whether to use bound or unbound files. It also briefly explains OLE (Object Linking and Embedding), the technology that some Access components use to store and display files.
Storing files in a database
How to add fields to your database tables and either link to or embed file data in those fields.
Adding unbound files to forms and reports
How to add files that remain fixed as you move through the records in a database or the pages in a report.
Adding bound files to forms and reports
How to add files that change as you move through the records in a database or the pages in a report.
Updating and editing links and files
How to update links to your files, display updated files automatically and manually, and edit files in Access.
Solving common display problems
What to do when you see file names instead of the files themselves, and "Package" in your table fields instead of a specific Office file type.
Multiple Excel files and need to import them in to access
I have been given a very large number of excel files and need to get them imported into access. The first folder alone has 900 spreadsheets.
The sheets I have looked at have headers and the data doesn't start till row 12 or so. Only one sheet per file.
Here is what I need to happen:
The excel files, all of them, would need to be opened and have a copy paste special to get rid of the formulas in the excel files, then saved.
Then all of the files in a specified directory would need to be imported into a specified table in access.
I don't know much about doing this in vb, but I am thinking that is where this needs to be done.
Office 2003 security basics
Learn about security fundamentals in Microsoft Office programs and what you can do to help protect your computer and documents. Find out about digital signatures, some basic information about macros and viruses, and how to create strong passwords to help protect your documents.
merging PDF files
I am using PDFCreator to print reports to files which works fine. Is there a way to merge the files into one (1) pdf file? I am using VB code to do this
Browsing for a file macro
I have a DB that I use to import two files, the DB then merges the records in the two files and generates a report with running sums and such. I use this quite often and I don't want to keep going throught the process of importing the files manually. And I tried using the transfertext feature but its limited to a certain filename and location, and the files that I import have different names and most of the time different locations as well. I would like to be able to use the browse feature. This way I can point to the file that needs to be imported and be done with it. Hope someone has the answer
I have a folder that contains several files. The are text files however the extension is not txt but a different word. Can someone provide a code example of importing these files into one table?
File name looks like this: textfile.information
The content is formatted like this:
I'm looking for a code example that demonstrates looping through these files and adding the content to one table. The column headers should be set up once and then ignored (for exmple, 'anumber:' would be a column header, anything after that is the data).
Help pulling data from one table to another
I am a file clerk. I have created a database to track the paper files that I am accountable for. Every day I get requests from workers for various files. I have split the database so that multiple users can access the db and edit or change the status of files.
In the be I have the main db with fields required for the files and I have another database (table 2)with similar fields that I use to generate an email form that workers fill out to request files.
Access then automatically pulls that data from the email form and inserts in to table 2. I pull those requested files then enter the data in to table 1 so that I know the who/what/where of a files location.
I want to be able to automatically insert info from table 2 into table one after I have pulled the file and checked it out.
Fetching data from one table to another
I am a file clerk. I have created a database to track the paper files that I am accountable for. Every day I get requests from workers for various files. I have split the database so that multiple users can access the db and edit or change the status of files. In the be I have the main db with fields required for the files and I have another database (table 2)with similar fields that I use to generate an email form that workers fill out to request files. Access then automatically pulls that data from the email form and inserts in to table 2. I pull those requested files then enter the data in to table 1 so that I know the who/what/where of a files location. I want to be able to automatically insert info from table 2 into table one after I have pulled the file and checked it out
I've created 3 mdb files. One consist of forms, reports, queries and links to my tables. Other 2 files consists of tables. How should I relink them using VB when I move my data files somewhere in anothether folder