473,320 Members | 2,020 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Document Control System through Ms access

I've been handed a little task of developing a document control system in ms access. Its require that the "documents" will be in ms word and also pdf formats.
Never having done this before has anyone had to make something similar?

Any guidlines to follow to start the process?

I,m trying to map out what is wanted but like many enduser requirements its a case of well, your doing it.....

I have put together a simple rationale
douments names, ownership, version and review information recorded in access. Then I'm supposed to be able t call the doument through access for reviewing then archive out of date versions leaving the "live doument" as the one everyone will have read-access to

any ideas?

Gareth
Jul 22 '07 #1
4 8038
ADezii
8,834 Expert 8TB
Hi Guys!

I've been handed a little task of developing a document control system in ms access. Its require that the "documents" will be in ms word and also pdf formats.
Never having done this before has anyone had to make something similar?

Any guidlines to follow to start the process?

I,m trying to map out what is wanted but like many enduser requirements its a case of well, your doing it.....

I have put together a simple rationale
douments names, ownership, version and review information recorded in access. Then I'm supposed to be able t call the doument through access for reviewing then archive out of date versions leaving the "live doument" as the one everyone will have read-access to

any ideas?

Gareth
I've created a simple Document System in which the Documents are not stored internally, only their Filenames are, but unfortunately I don't have the time to explain it fully. All Documents (*.doc and *.pdf) exist in a Documents Folder underneath the Folder where your Database resides. I'll Post the code and if you have any questions, please feel free to ask and I'll definately get back to you. Sorry for the confusion and non-explanation but at least it's something to get you started.
Expand|Select|Wrap|Line Numbers
  1. 'Copy and Paste into a Standard Code Module
  2. Public Function fPathToFile(strFileName As String) As String
  3.   fPathToFile = Left$(CurrentDb.Name, InStrRev(CurrentDb.Name, "\")) & "Documents\" & strFileName
  4. End Function
Expand|Select|Wrap|Line Numbers
  1. Private Sub cmdOpenFile_Click()
  2. Dim retVal, strPathToFile As String
  3. Dim strWordPath As String, strAdobePath As String
  4.  
  5. 'Absolute Path to File is derived here.
  6. 'The FileName Field contains only the File Name as in MyFile.doc
  7. If Len(Me![FileName]) > 0 Then
  8.   strPathToFile = fPathToFile(Me![FileName])
  9. Else
  10.   MsgBox "There is no File to Open", vbExclamation, "Missing File Name"
  11.     Exit Sub
  12. End If
  13.  
  14. 'Substitute your own Paths if necessary
  15. strWordPath = "C:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE "
  16. strAdobePath = "C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe "
  17.  
  18. Select Case Right$(strPathToFile, 3)
  19.   Case "doc"
  20.     retVal = Shell(strWordPath & strPathToFile, vbMaximizedFocus)
  21.   Case "pdf"
  22.     retVal = Shell(strAdobePath & strPathToFile, vbMaximizedFocus)
  23.   Case Else
  24.     'only valid Extensions now are *.pdf and *.doc, can adjust later if needed
  25. End Select
  26. End Sub
Jul 22 '07 #2
many thanks Ill get on it as soon as I get back to my office

Gareth
Jul 22 '07 #3
I have also just been given the exact same task!
I'm trying to also make a login form, and restricted access depending on the department that each person is in. Im completely new to Access other than the dull stuff in school I never paid attention to! But Im sure your script will be very useful.. thanks very much!
Jul 27 '07 #4
ADezii
8,834 Expert 8TB
I have also just been given the exact same task!
I'm trying to also make a login form, and restricted access depending on the department that each person is in. Im completely new to Access other than the dull stuff in school I never paid attention to! But Im sure your script will be very useful.. thanks very much!
You're quite welcome, but in the future please do not jump in on someone else’s
Post. Create a separate Post of your own and clearly state your problem.
Jul 27 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

12
by: Kepler | last post by:
How do you get the height of the client browser in IE? Both document.body.clientHeight and document.body.offsetHeight return the height of the document. If the page is long and there's a vertical...
1
by: TD | last post by:
I'm using iText in an app to create and print documents to network printers. I launch acrobat via the command line as shown on this page... ...
2
by: paul meaney | last post by:
All, myself and another developer have been staring blankly at a screen for the past 48 hours and are wondering just what stunningly obvious thing we are missing. We are trying to load up 2...
2
by: Nathan Sokalski | last post by:
I would like to change the <title></title> of a page from a user control. I have been unable to find any property in VB that allows me to do this. The only thing I have been able to find that might...
5
by: c676228 | last post by:
Hi, I guess I am confused. In aspx script, I mean (you won't use Codebehind="enrollinfo.aspx.vb", but mix code with html and code together) You can access user control's property directly. Since I...
12
by: Christian Roth | last post by:
Hello, I am merely asking this for my own understanding: Processing instruction's data part is not entity-aware, i.e. character and numercial entities are not resolved at parsing time. E.g., ...
3
by: thompson_38 | last post by:
I am currently working on a C# application that uses an axWebBrowser control which displays HTML pages. This is being done to reuse an existing web application which resides on a client's...
5
by: mikez | last post by:
Hi, We recently built a very basic file management system for a client in Access 2003 (to use with incoming tif scans). In it we used Microsoft's Document Imaging activex viewer (from Office...
3
by: MarkusJNZ | last post by:
Hi, does anyone know of a good (Preferably free but don't mind paying some $$ for source code) basic document sharing application? Basically, a single admin should be able to upload files to a...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.