Recent content by Flo79

I found the answer I was looking for here: http://www.loresoft.com/Applications/FileSearch/Download/default.aspx Paul Welter has created "FileSearch is a simple and fast file searching component that uses the Windows file search API. Source code and examples included." The FileSearch.dll...

CautionMP, I've used the Application.Filesearch object. The problem it has is that it no longer works in Office 2007. Also, I find it too slow. From what I've read using APIs is the fastest method.

I am working on a function that returns a file's path based on its name and a search directory. I am using the "SearchTreeForFile" API to do this. The problem is that this API does not accept wildcard characters in the file name. From What I've read the "FindFirstFile" API is a much more...

PHV, I had no idea! Thank you for that.

Hi There, I am hoping someone could help me with the following: In Excel 2003, when editing the contents of an active cell, I would like to be able to insert a line feed character (vblf) when pressing control and enter simultaneously. So far I've been able to create the below sub which...

Hi there: I am trying to build a custom function that searched my computer for a file and returns the path to that file. I have successfull using a function build by Dev Ashish that enables me to dfind a file with a specific name which I have included bleow. My problem is that I now need...

You should take a look at the following site: http://www.mapilab.com/download/ Advanced Security For Outlook

Something that has puzzled me for quite some time is whether there is a means to create a hyperlink to a file that won't break if either the location or name of the referenced file changes. I heard from someone that every file has some kind of a unique ID that only disappears if the file is...

I was recently trying to determine a way to parse a delimited string into individual records. For example, when importing MS Outllok data into Access, contact categories are exported like this (Category 1; Category 2; Cateory 3 etc.) for each contact. In order for one to more effectively use...

PHV, You helped me greatly by mentioning "Split Function." It was the search term that I should have been using. I found a solution to my problem here: http://www.mvps.org/access/strings/str0003.htm The original code is I think by Dev Ashish, I modified the 2 functions needed slightly to...

Hi There, I am looking for a function in vba that would do the following: I have a Table (A) with records that look like this: Record 1 Column 1 = 23 Column 2 = a,b,c,d I need a function to create another table (B) where records in table (A) are transformed to look like this: Record 1...

Hi There. I have been using an access database to manage a large variety of PDF files. I have written some code that looks for a file with a specific name on my computer and appends the hyperlink to that file into a table when it finds it. I am now looking to improve this further: Is...

Here is some sample code. I am using win2pdf software to create pdf files from access. This software is relatively cheap and can be controlled easily through VBA. You need to have this software in order for the below code to work. Code --------------------------------------------------...

Hi, I have two PDF files, "PDF_1" and "PDF_2". I want to write VBA code that merges PDF_1 with PDF_2, then saves PDF_2 (which now should be a product of both files) Here is the code that I have been able to gather: It does absolutely nothing for some odd reason...

Hi there, I am rattled by the fact that I cn't seem to find the solution to the following problem: I need vba code that will merge 2 pdf files into one. Both files already exist outside of Microsoft Access. I am using Distiller 6.0. I need this to work completely without user interaction...