Results 1 to 4 of 4
  1. #1
    kkrishna is offline Novice
    Windows XP Access 2007
    Join Date
    May 2010
    Posts
    12

    Open a text file to show results...

    I created a form to filter and write the results (tab separated) to a text in the C:\Temp folder. After the macro runs, I am opening the text file, and if required, I am cutting and pasting them in an Excel file. I opted for a text file because it is simpler to write the code.

    Now I want the macro to open the text file from the C:\Temp folder at the end of the macro. I searched the internet for an answer but mostly they deal with opening, writing, reading or appending data to a text file.

    I just want to open the text file for display on the screen.


    Do we have anything like Application. OpenFile ... routine to display the file contents on the screen. Yes, the Access will open another application, in this case Notepad, but that should not be a big problem.

    I am using Access 2007.

    I'd appreciate any suggestion.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922

  3. #3
    kkrishna is offline Novice
    Windows XP Access 2007
    Join Date
    May 2010
    Posts
    12
    Thanks. I use the Shell function and now I am able to view the text file.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2007
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    That is great! Are you ready to follow the link in my sig and mark this thead as Solved?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 05-14-2012, 07:24 AM
  2. Text Box to show specific record
    By chu3w in forum Forms
    Replies: 1
    Last Post: 04-01-2010, 12:23 PM
  3. Open form based on query results
    By RobbertH in forum Queries
    Replies: 1
    Last Post: 02-10-2010, 08:13 AM
  4. Replies: 2
    Last Post: 09-24-2009, 08:07 AM
  5. Replies: 0
    Last Post: 10-16-2008, 02:39 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums