run the associated application for a file from access vba

Dsperry101 via AccessMonster.com

Hi Everyone,
I have a work order database . I am trying to allow user's to attach files
to the workorder (ie cad dwq's , text files , pdfs, pictures etc) I have the
attachment logic resolved but now I want to go to the workorder and open any
selected attachment from access using the associate application( ie .txt run
notepad with the txt file as the file it opens , run adobe's reader when the
file has a .pdf extension etc).
I haven't been able to find anything on the web or in my reference books.

--
Danny C. Sperry

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200612/1

Dec 19 '06 #1

Subscribe Reply

1934

chris.nebinger

Try Application.FollowHyperlink ("C:\File.txt")

Chris Nebinger
Dsperry101 via AccessMonster.com wrote:

Hi Everyone,
I have a work order database . I am trying to allow user's to attach files
to the workorder (ie cad dwq's , text files , pdfs, pictures etc) I have the
attachment logic resolved but now I want to go to the workorder and open any
selected attachment from access using the associate application( ie .txt run
notepad with the txt file as the file it opens , run adobe's reader when the
file has a .pdf extension etc).
I haven't been able to find anything on the web or in my reference books.

--
Danny C. Sperry

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200612/1

Dec 19 '06 #2

Similar topics

266

How to Assemblies held in GAC access their associated config files

by: Gerard | last post by:

Hi, I am developing a set of assemblies which will be shared by many applications and so I intended to place them in the GAC at runtime. However, these assemblies have associated configuration...

.NET Framework

1585

executing program by clicking on an associated file (ext)

by: Marco Martin | last post by:

Good Day Group, I'm trying to make my application open and run some code when a user clicks on a file with an associated extension. This is *my* understanding of what actually happens, please...

C# / C Sharp

2886

Open associated application with filestream

by: J | last post by:

Hi, I know that to launch an application that is associated with a particular file I can use Process.Start(filename), but that assumes the file physically exists somewhere. My problem is I...

C# / C Sharp

7227

by: rrober07 | last post by:

Hello, My Setup is I have a Web Server machine(Devweb01), Database SQL Machine(Devsql01), a Client Machine(local machine) I have configured the SQL machine as follows: 1) Added local Aspnet...

ASP.NET

2309

Can I open a .DBF file without the associated .CDX file?

by: Arthur Naoumidis | last post by:

I have an AS.net web app that I am using to upoload data files into my application. I am trying to upload a DBF file and I don't have access to the associated CDX file - is there some option in the...

ASP.NET

1696

by: boy | last post by:

I got the following error message when I access the web application, in which the web application use SPPI to connect to database. "Login failed for user '(null)'. Reason: Not associated with a...

ASP.NET

1563

Determining the application currently associated w/ file type...

by: Vagabond Software | last post by:

I'm writing an application where then end-user will want to view and print (not edit) TIFF and JPEG images. For now, I simply use the System.Diagnostics.Process.Start method to open the desired...

Visual Basic .NET

6666

Get file's associated application / app icon

by: =?Utf-8?B?TG9hbldvbGY=?= | last post by:

I'm working on a Windows Explorer-like application. What is the best way to find out what application is set to open a particular type of file? Is there a function to do this? Do I have to go...

Visual Basic .NET

1509

Loading associated files

by: flarefight | last post by:

I am trying to make a a simple databasing GUI interface and and have created a module to deal with parsing the data from a file and a GUI based program that displays this data using PyQt4, i know...

Python

7216

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7098

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7303

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7471

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5028

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4699

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3187

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

1528

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

407

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General