Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rockfish12
  • Order by date
  1. rockfish12

    Return Target of Folder Shortcut

    Actually, that thread looks very promising - I think it will work. Thanks very much for providing that... Now, regarding what seems to be your thinly veiled skepticism that I actually looked for relevant threads: believe it or not, the search terms "shortcut" and "target&quot...
  2. rockfish12

    Return Target of Folder Shortcut

    Thanks, but I tried that already. I found a couple of threads that looked promising, but nothing that I was able to make work.
  3. rockfish12

    Return Target of Folder Shortcut

    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...
  4. rockfish12

    Return full network address of mapped drive

    Thanks, DrJavaJoe and paulbent. I give both of these suggestions a go.
  5. rockfish12

    Return full network address of mapped drive

    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...
  6. rockfish12

    How to keep subform editable when entering new record?

    Thanks, Frink and BSMan. Frink, you were spot on about what was happening. I implemented both of your ideas and my form works great now. Thanks again for the help!
  7. rockfish12

    copying records from one table to another?

    Not exactly sure what you mean by "at a given date", but maybe this will help get you started... http://www.accessfreak.net/KeywordSearchDetail.asp?page=13&order=id&recordkey=195
  8. rockfish12

    Keep subform editable

    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)...
  9. rockfish12

    How to keep subform editable when entering new record?

    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)...
  10. rockfish12

    Can't add new record in subform

    Never mind, I figured it out. I modified one of the command buttons on the main Orders form to set the AllowAdditions subform property to True.
  11. rockfish12

    Can't add new record in subform

    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...
  12. rockfish12

    How can I make this recursive?

    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...
  13. rockfish12

    Extract File Properties>Description>Comments

    Thanks, vb5prgrmr...had to modify to suit Access VBA environment, and it worked great!
  14. rockfish12

    Extract File Properties>Description>Comments

    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...
  15. rockfish12

    Programmatically extract File Description Comments

    Thanks for your help. I should have specified that all of the files are plain text files, in .txt format. I tried saving one of them as a Word Document, but unfortunately, it looks like Word loses the comments in the conversion. Is there any way to either get Word to preserve these comments...
  16. rockfish12

    Programmatically extract File Description Comments

    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...
  17. rockfish12

    Import text file into Access table

    Wait, I may have figured it out - it I had to uncheck the ActiveX 2.5 library. Your solution worked great. Thanks!
  18. rockfish12

    Import text file into Access table

    Thanks, Wayne. You're exactly right - the text file is just a bunch of filenames (with full paths) that I want to read into that table, except for a few header lines at the top. Anyways, that fixed the "variable required" problem, but now I'm getting a "type mismatch" error...
  19. rockfish12

    Import text file into Access table

    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...

Part and Inventory Search

Back
Top