Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-09-2007, 12:10 AM   #1
GUIDO22
Newly Registered User
 
GUIDO22's Avatar
 
Join Date: Nov 2003
Location: Rochester, Kent
Posts: 408
Thanks: 6
Thanked 1 Time in 1 Post
GUIDO22 is an unknown quantity at this point
Question Personnel / Document Storage, Archive

Hi
My database is to have a Personnel data area whereby I can store all relevant details for employees within the company.
I plan to incorporate a feature whereby I can alos maintain a history of documentation written and issued including links to the actual documents for that employee during their time with the company.

Has anyone done a similar thing they would be willing to allow me to use?
I figure this would contain links to work documents stored on the hard drive in a specific folder. Selection of a specific item from a historical list - would invoike Word /similar and display the appropriate file...

Any ideas would be gratefully received.
Thank you.

__________________
There are 10 types of people in the world. Those who understand binary and those who don't.
GUIDO22 is offline   Reply With Quote
Old 08-09-2007, 12:58 AM   #2
GaryPanic
Smoke me a Kipper,Skipper
 
Join Date: Nov 2005
Location: England
Posts: 3,183
Thanks: 5
Thanked 7 Times in 6 Posts
GaryPanic will become famous soon enough
ghudson - has done somthing along these lines - check out his samples for opening a directory - (the same has about 4 options on how to do this and simlair stuff)
if you cna get this working it is fab..( this is on my list to do - so i haven't been able to get it to do 1005 of what I want)

g
GaryPanic is offline   Reply With Quote
Old 08-09-2007, 02:37 AM   #3
GUIDO22
Newly Registered User
 
GUIDO22's Avatar
 
Join Date: Nov 2003
Location: Rochester, Kent
Posts: 408
Thanks: 6
Thanked 1 Time in 1 Post
GUIDO22 is an unknown quantity at this point
Thanks Gary - any chance you can post me some links have done a search on GHudson but there is tons of stuff and Im not too sure what the item header desciription would be that I am looking for.....

__________________
There are 10 types of people in the world. Those who understand binary and those who don't.
GUIDO22 is offline   Reply With Quote
Old 08-09-2007, 02:57 AM   #4
GaryPanic
Smoke me a Kipper,Skipper
 
Join Date: Nov 2005
Location: England
Posts: 3,183
Thanks: 5
Thanked 7 Times in 6 Posts
GaryPanic will become famous soon enough
found a version of the file - zip format on Access 2000
Attached Files
File Type: zip update.zip (99.9 KB, 83 views)
GaryPanic is offline   Reply With Quote
Old 08-09-2007, 05:38 AM   #5
GUIDO22
Newly Registered User
 
GUIDO22's Avatar
 
Join Date: Nov 2003
Location: Rochester, Kent
Posts: 408
Thanks: 6
Thanked 1 Time in 1 Post
GUIDO22 is an unknown quantity at this point
Thanks - this example DB shows how to Shell Execute files which is OK.

However, I am more specifically after code that will track document changes from within Access ie. allowing user to create and save say Word documents whilst maintaining file name/ location information against an employees history record .....

Thereby keeping a history of all documents written to a particular employee etc.
__________________
There are 10 types of people in the world. Those who understand binary and those who don't.
GUIDO22 is offline   Reply With Quote
Old 08-10-2007, 03:21 AM   #6
GUIDO22
Newly Registered User
 
GUIDO22's Avatar
 
Join Date: Nov 2003
Location: Rochester, Kent
Posts: 408
Thanks: 6
Thanked 1 Time in 1 Post
GUIDO22 is an unknown quantity at this point
For those interested - I found the following which uses a Rich Text Editor OCX which does everything I need to perform the function detailed previously but has the added advantage that the RTF code is maintained in table format within Access with little DB bloat!

Check it out : Rich Text Control
__________________
There are 10 types of people in the world. Those who understand binary and those who don't.
GUIDO22 is offline   Reply With Quote
Old 08-10-2007, 03:28 AM   #7
GUIDO22
Newly Registered User
 
GUIDO22's Avatar
 
Join Date: Nov 2003
Location: Rochester, Kent
Posts: 408
Thanks: 6
Thanked 1 Time in 1 Post
GUIDO22 is an unknown quantity at this point
For those interested - I found the following which uses a Rich Text Editor OCX which does everything I need to perform the function detailed previously but has the added advantage that the RTF code is maintained in table format within Access with little DB bloat!

Check it out : Rich Text Control


__________________
There are 10 types of people in the world. Those who understand binary and those who don't.
GUIDO22 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert a word document in another word document cherosoullis Word 5 08-17-2011 12:24 AM
Automate different document numberring for different depts? pradaloh Modules & VBA 1 07-01-2007 11:22 PM
Send Record to Word Document shenty General 4 06-12-2007 04:42 AM
Need to print document based on database - HELP! Debased General 2 11-03-2004 11:10 AM
Creating a report from a Word document Amy Scivally Reports 3 07-08-2003 11:12 AM




All times are GMT -8. The time now is 05:38 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World