G'day David,
We went the other way and created a little VB app that displays a list
of files which have the person, organisation or job ID as part of the name.
From a person, org or job record you click a button which launches
the VB app which loads the list of matching file names.
From there if you click on a file it opens the native app for that file
with the file loaded.
The advantage of your way is that documents can be named anything
the user likes and you do not have to include an ID as part of the name.
The down side is the maintenance of the doc names table.
We also created a few other nifty features, like being able to (from
within the VB app) go to an archive directory from the default dir
and being able to search all related docs for a given text string.
At 08:05 AM 26/08/2001 -0400, you wrote:
>Have you tried using the FINDFILE(filename) to search for the file.
>
>Buddy
>
>-----Original Message-----
>From: David Atkinson [mailto:[EMAIL PROTECTED]]
>Sent: Sunday, August 26, 2001 5:12 AM
>To: RBase List
>Subject: Checking for a filename
>
>
>Ever get a day when your brain decides to go delinquent ?
>
>Table Actions records actions/activities the DBOwner wishes to record using
>columns cliID, empID, cnID,acDate,acActivity,acNotes,acID,acDateTime
>
>The columns determine which client, which company employee, which client
>employee, the date, the activity, ('phone call to/from'...) plus any short
>notes...
>
>Many entries are DB generated as the owner creates say Quotations, Invoices,
>Receives Payments and so on, rows are posted saying what was done.
>
>Should the company have written to the client, Table DocsFile enable
>document Filenames to be linked via cliID. There can be many filenames for
>each one client. DocsFile appears as a region on Form Actions.
>
>I wish to use the LAUNCH from within form Actions.
>The user selects the Client, moves to the DocsFile region, Clicks on a
>filename which is placed in a variable vacfile.
>Clicks pushbutton OPEN THAT FILE which runs OpenFile.eep and runs the
>LAUNCH command.
>Provided the filename exists LAUNCH works just fine.
>
>I also wish provide the option to create a New Filename from within
>form Actions, Region DocsFile before even launching Word or Excel.
>That filename is posted into clipboard (works fine) and can be copied from
>clipboard into Filename, when user chooses FILE - SAVE AS. It will also
>form part of 'Our Reference:' within the WORD/EXCEL document.
>
>This gives me 2 possibilities
>1. ZIP START WINWORD/EXCEL would launch the programme and the user would
>be
>instructed to immediately to save the filename using Cliboard.
>2. Create the new filename then LAUNCH to it.
>
>Here's where brain gets the giggles...
>
>How do I check in advance if the WORD/EXCEL filename exists or not ?
>If_it_does - LAUNCH would apply
>If_not - Create New or ZIP START would apply.
>
>I've been looking at CHOOSE and #LFILES but haven't resolved a method
>foolproof for users of any ability.
>
>Any fresh thoughts would be a great help
>
> David Atkinson
>skidbusters.co.uk
>
>[EMAIL PROTECTED]
Warmest regards,
Tom Grimshaw
coy: Just For You Software
tel: 612 9552 3311
fax: 612 9566 2164
mobile: 0414 675 903
post: PO Box 470 Glebe NSW 2037 Australia
street: 3/66 Wentworth Park Rd Glebe NSW 2037
email: [EMAIL PROTECTED]
web: www.just4usoftware.com.au
This email and any files transmitted with it are confidential to the
intended recipient and may be privileged. If you have received this email
inadvertently or you are not the intended recipient, you may not
disseminate, distribute, copy or in any way rely on it. Further, you should
notify the sender immediately and delete the email from your computer.
Whilst we have taken precautions to alert us to the presence of computer
viruses, we cannot guarantee that this email and any files transmitted with
it are free from such viruses.
