Re: adding hyperlinks to a table....

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The concept shouldn't be too complicated. However, for the coding aspect on
what will you base the document name? Let me ask the question differently.
I grasp your numbering system. That part is fine. What I'm trying to
understand is how do you want your code to identify what type of ducument it
is currently renaming.

Let say your user creates a document and named it AccntTplt.doc and then
goes and enters it into your db. Based on what will I know what to rename
it too? Hoe can I programmitically identify if its 121 - Accounts Payable
or 122 - Accounts Recievable?

or am is this going to be identified in a field or series of
listboxes/comboxes on the form? Not that I'm looking to complicate things
further, but are all these docs going to be put in the same directory or are
there going to be directories for Accounts Payable and another Accounts
Recievable with sub-directories for each document type?

Given me a few more details and will be able to create the detailed code.

Daniel






"M G Henry" <mr_mikehenry007@xxxxxxxxxxx> wrote in message
news:1169833559.730873.68080@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Daniel,

The example of the numbering is as follows:

there are 3 sets of 3 separate 3 digit numbers, that are concantenated
togeter to form a 9 digit number.

The first 3 digit number represents one of 21 current divisions some
examples are:

121 - Accounts Payable
122 - Accounts Recievable
these are fixed numbers.

The second 3 digit number represents one of 10 current Document types
some examples are
200 - Procedure
300 - Template
these also are fixed numbers.

The third 3 digit number represents an autonumber that is put in when
the first two sets of 3 numbers combine. This number is a primary key.
some examples of how this would look in the final concatenated number
would be

121-200-001 would be the first accounts payable procedure document
121-200-002 would be the second accounts payabel procedure document,
etc.....

This concantenated number would be stored as docnum,

Ideally I would like to read the value of docnum, and use it to move
and rename the document and save it on the g drive in the appropriate
folder...

for example, the path would be
"G:\Documents\Accounts Payable\121-200-001.doc" for a word document,
.xls for an excel spreadsheet, etc....

this way people could create documents on whatever drive they are
working on, but a copy of the approved form would be saved in a folder
and access to that folder would be limited by groups to only certain
people.

Thanks for the help Daniel

On Jan 19, 1:41 pm, Daniel <Dan...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
For the file moving/renaming...manipulation Douglas Steele answered this
really well in another post, so take a look at
ithttp://groups.google.ca/group/microsoft.public.access.externaldata/br...

For the autonumbering, give me an example of the format you wish to use
and
we'll see how to write the code for it.

Daniel



"M G Henry" wrote:
another nice feature would be to have the ability for a data string
that the database will generate ( similar to a catalog number ) be
allowed to be used to rename the file name from whatever the 15 or so
people writing documents would name them, to a number that the database
already assigns ( that part is working fine now ) and then move the
renamed files to specific directories given the logic that would be
built into the program.

just would need to know how to go about renaming... but with a auto
generated name ... if possible.

Daniel wrote:
You basically need to use a file dialog. Take a look at
http://www.mvps.org/access/api/api0001.htm

For a working example put together I would suggest taking a look at
the
Album Sample database which can be found at

www.cardaconsultants.com/en/samples.html

The import function, to import images, does exactly this.

Daniel

"M G Henry" wrote:

I am working on a new database and part of the requirements will be
to
be able to take existing documents that are in existing folders and
add
the path to a field that is a hyperlink field called: foundin
in the table named: document in the form of a hyperlink...

I am trying to come up with an easy way to be able to search the
drives
( similar to windows explorer ) and come up with a path, and then
transfer that path into a field on a form ( and of course the
linked
table) for each of the documents....

I would like to have something that is user friendly... any ideas
??- Hide quoted text -- Show quoted text -



.

Relevant Pages

  • Re: adding hyperlinks to a table....
    ... togeter to form a 9 digit number. ... and rename the document and save it on the g drive in the appropriate ... but a copy of the approved form would be saved in a folder ... people writing documents would name them, to a number that the database ...
    (microsoft.public.access.forms)
  • Re: Layout Hell-o
    ... RW> Databases return a four digit year. ... After the database developer solved the Y2K problem, ... I had disputes with my colleages who stored ... "Es sind nicht die Generäle und Könige, die die Geschichte machen, ...
    (comp.lang.cobol)
  • Re: autonumber
    ... "Ron Weiner" wrote: ... the database is secured and I am the only one with admin access. ... into your table with a 8 digit number. ...
    (microsoft.public.access.formscoding)
  • Re: finding unmatched data
    ... Probably need more specifics about how your database is set up (rows used, ... headers) to give a more specific answer. ... vs. P.O. Box or South Maple vs. S. Maple. ... I am trying to account for 5 digit postal code vs. zip+4, however, if ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Layout Hell-o
    ... RW>>> Databases return a four digit year. ... LW>> who stored calender dates in the database as 6 digit entities, ... user written software, where Y2K-problems could arise and advised ... corsaire, corsaire et demi." ...
    (comp.lang.cobol)