Topics Search

Some files can contain viruses...

Some files can contain viruses...
Views: 68
Whenever clicking a URL to an exe, Access always pops up a "Microsoft Office" warning dialog window:
"Some files can contain viruses or otherwise be harmful to your computer." How to disable the annoying warning message?
Sponsored Links:

Similar posts...

 

Comparing a table or query from two different files

Comparing a table or query from two different files Icon
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

Updating all the references to external files in .accdb files Icon
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.
 

Converting excel files to access files for an online nursery plant pricelist

Converting excel files to access files for an online nursery plant pricelist Icon
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

Where to added/install a database file in Windows 7 Icon
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.
 

Query on or before date

Query on or before date Icon
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).
 

Set the number of files shown in the list of recently used files

Set the number of files shown in the list of recently used files Icon
Microsoft Office programs display the last few documents you opened in that program so that you can use those links to quickly access the files. This feature is turned on by default, but you can turn it off, turn it back on, clear, or adjust the number of files that it displays. If this feature was turned off and you subsequently turn it back on, only the files that you open and save after you turn it on are listed.
 

Multiple Excel files and need to import them in to access

Multiple Excel files and need to import them in to access Icon
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.
 

Help pulling data from one table to another

Help pulling data from one table to another Icon
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.
 

Import multiple txt files and filename?

Import multiple txt files and filename? Icon
I have a question regarding import of multiple Text files.

These files all have different names but will always be found in the same location.

C:\Documents and Settings\computer\Desktop\F FILES

I have little VBA knowledge and am wondering if I can import these files into an existing Access table tbl_Table via a macro?

A number of problems:

1. It does not import directly into the existing table, instead it creates a new table tbl_Table , I'd like to import directly into the existing table without using append or similar.

2. I cannot get it to import ALL files in the folder.

3. I'd like to import the first 7 characters of the filename into a field (KEY).
 

Import only Files not already imported

Import only Files not already imported Icon
To state my overall goal, I have a directory with Excel 2007 files. These files come in daily. They are imported to an Access 2003 database during various times throughout the month.Currently a user has to remember the last file that was imported so they do not import it again.

Here is what I am trying to do which will result in automatic import of files so users don't have to worry who imported last and where they left off.

1. Open all .xlsx files in the given directory, save them as .csv. (This part I have done)
2. Obtain a table with files that have already been imported (done)
3. Have Access compare only the .csv filenames found in the given location to the table and import using the TransferSpreadSheet method only the new files then add the filename to the table.

I can import all .csv files but need help comparing them to filenames in an existing table.
4. I'll then delete all .csv files in this location so it appears nothing has changed and write the macro so all the steps occur everytime the database is opened (this I'll work on myself)

Can anyone clue me in how to compare a filename to an existing table?