Recent content by Johnta

Creating my own folder tree would be a massive amount of data. Ive seen recusive ways to view files but what about just folders?

Private Sub Text30_Click() Dim sUserFile As String sUserFile = Dir$("L:\Test Results\TR'S\TR" & Text30.Text, vbDirectory) On Error GoTo err Dim bb bb = Shell("Explorer.exe L:\Test Results\TR'S\" & sUserFile, 1) Exit Sub err: MsgBox err.Description End Sub This is my code so far. I cant...

I want to check and see if the file/folder exist, and if it does I want VB to open the folder and display the contents to the user. For example the user would click ID number 1122, then the application would search the I drive for folder 1122, then if a folder contains 1122 in the file name the...

Is it possible to create a file system that could search for a record using wild card characters then open the file if it is found. For example my DB form is something in the effect of http://allenbrowne.com/ser-62.html I want the user to be able to click on one of the records shown then I want...

I finally got it to work, thx oldsoftboss. Now I need to somehow make a report with a similiar search function that could print out a report based on say all the information on a set customer, which will usually consist of many records.

Okay I resloved that problem now when I try to open the form or enter data into the text box I get a "Enter parameter" text box open. This is probably a simple fix, but I havent used Access in years. Though it does work other than that.

When using the search multiple fields example ive gotten everything to work except the search text box to effect the fields in the searchlist. Could it be that it wont work if I have a massive number of fields? Here's my code: Option Compare Database Option Explicit Private Sub...