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
4 8038
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. -
'Copy and Paste into a Standard Code Module
-
Public Function fPathToFile(strFileName As String) As String
-
fPathToFile = Left$(CurrentDb.Name, InStrRev(CurrentDb.Name, "\")) & "Documents\" & strFileName
-
End Function
- Private Sub cmdOpenFile_Click()
-
Dim retVal, strPathToFile As String
-
Dim strWordPath As String, strAdobePath As String
-
-
'Absolute Path to File is derived here.
-
'The FileName Field contains only the File Name as in MyFile.doc
-
If Len(Me![FileName]) > 0 Then
-
strPathToFile = fPathToFile(Me![FileName])
-
Else
-
MsgBox "There is no File to Open", vbExclamation, "Missing File Name"
-
Exit Sub
-
End If
-
-
'Substitute your own Paths if necessary
-
strWordPath = "C:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE "
-
strAdobePath = "C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe "
-
-
Select Case Right$(strPathToFile, 3)
-
Case "doc"
-
retVal = Shell(strWordPath & strPathToFile, vbMaximizedFocus)
-
Case "pdf"
-
retVal = Shell(strAdobePath & strPathToFile, vbMaximizedFocus)
-
Case Else
-
'only valid Extensions now are *.pdf and *.doc, can adjust later if needed
-
End Select
-
End Sub
many thanks Ill get on it as soon as I get back to my office
Gareth
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!
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.
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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...
...
|
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...
|
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...
|
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...
|
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.,
...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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...
| |