paindivine
Registered User.
- Local time
- Today, 01:12
- Joined
- Dec 13, 2006
- Messages
- 23
I have a database that I plan to use to help us manage an old "Remedy" system....
There is a field for "Ticket number"
I want to be able to click a button and have this ticket open in Remedy.
Remedy DOES have a link system. When I creat a link it creates a file like this:
Ticketnumber.ARTask
The contents of the file are simple:
The name of the file seems to be irrelevent.
How can I programatically get the button to re-write the ticketnumber into that file, in that spot (after the letters "NTRS") and then have it open the link? I figure I can keep 1 file in the working directory and just re-write that same file over and over again... I just don't know enough about VB or macros to figure it out.
There is a field for "Ticket number"
I want to be able to click a button and have this ticket open in Remedy.
Remedy DOES have a link system. When I creat a link it creates a file like this:
Ticketnumber.ARTask
The contents of the file are simple:
Code:
[Shortcut]
Name = NTRS-Trouble
Type = 0
Server = samson
Join = 0
Ticket = NTRS422904
The name of the file seems to be irrelevent.
How can I programatically get the button to re-write the ticketnumber into that file, in that spot (after the letters "NTRS") and then have it open the link? I figure I can keep 1 file in the working directory and just re-write that same file over and over again... I just don't know enough about VB or macros to figure it out.