Search results for query: *

I've got some code in my little application that allows users to browse for folders through a dialog box. However, in the browse dialog box, some of the folders shown - for example, those under My Network Places - are actually folder shortcuts, rather than actual folders. I know how to...

How can I return the full network address of a mapped drive, rather than just the local path and locally issued drive letter (e.g. "//computer1/folder1" instead of, say, "m:/folder1")? I've tried the GetAbsolutePathName method of the FileSystemObject, but I believe that it...

I've got a form - "Orders" - that has a subform called "Order Items." I've set the On Current property of the Orders form to disallow edits (e.g. Me.AllowEdits = False) in order to prevent accidental editing (the user can bypass this by pressing an "Edit" button)...

I've got a form - "Orders" - that has a subform called "Order Items." I've set the On Current property of the Orders form to disallow edits (e.g. Me.AllowEdits = False) in order to prevent accidental editing (the user can bypass this by pressing an "Edit" button)...

I have a form (Orders) that has a subform (Order Details), both of which have queries as their record sources. In the course of trying to make sure that users don't accidentally add, edit, or delete an Order Detail record, I added some code to the On Current event of the Order Details subform...

How can I make the following code not only return the subfolders within a folder, but also return subfolders within subfolders, ad infinitum? ______________________________________________________ Sub LoopDeLoop(strPath As String) Dim objFSO As FileSystemObject Dim objFolder As Folder Dim...

Is there a way to extract any/all of the File Description elements for a given file? To further clarify, in Win2K - and maybe other Win OS's (?) - , when you right-click on a file to get its properties, and click on the Summary tab, there are a number of Description elements that users can...

Is there a way, using VBA, to extract any/all of the File Description elements for a given file? To further clarify, in Win2K - and maybe other Win OS's (?) - , when you right-click on a file to get its properties, and click on the Summary tab, there are a number of Description elements that...

I've read thru some other tek-tips.com posts on how to programmatically import text files into a table in Access, and I came across some code (below) that I'm trying to make work: ---------------------------------------- Sub ImportTarFiles(strFileName As String) Dim dbs As Database Dim rst As...

I have a situation where I have a bunch of text files - all within the same directory - that need to have a particular line replaced. What I want to do is programmatically open, say n07w113a4.txt, and replace the text on a line in that file with the current filename, minus the extension. So, for...

Being very new to programming, I'm wondering how I can use VBA's File System Object to return a bunch of folder names from a specified directory. For example, if I specify the "c:\" directory, I would want to be able to output the names of all the subfolders within that directory to a...

I have a parent directory that has a bunch of subdirectories, each of which contains two or three files. What I want to do is programmatically move/copy those files nested in each subdirectory out to a single folder somewhere else, so that I can run a batch operation on the files using another...

I am trying to create a tab-delimited text file using VBA, a snippet of which is shown below. When I run the procedure, the coords.txt text file is created with what appears to be a tabs separating the values, but as it turns out, they're not. Or at least other programs don't recognize it as a...

How could I copy all files from one directory to another...for instance, from my CD drive (d:) to my hard drive (c:)? (I've read that there may be some FileCopy function, which I tried, but Access 2000 didn't seem to recognize it. I even looked for it in VBA help, but it was nowhere to be found)

What i would like to know is how to read a text file - located at, say, c:\windows\desktop\file.txt - that has a bunch of information in it, but only extract a few particular strings from it. Though I won't know the exact string values that I want ahead of time, they will always be numbers...