TOOLS: Adding docs (PDF) to a database

[Michael Kintner]

I am looking for add-on tools or code to allow me to attach scanned PDF
documents to a database record.

I would like to know if there are developer tools out there that can do the
following:
- Appending muliple as in many PDF docs to a specific record.
- Or maybe I create a folder and the AccessDB reads the contents of the
folder showing the files related to the specific record.

Kinda like a achive file manger of related files to a database record.

Note: Eventually this access database will be pushed to SQL server if that
helps.

Can anybody help me with this?

Thank you in advance.
Michael Kintner

[Tom van Stiphout]

On Tue, 29 May 2007 09:29:27 -0400, "Michael Kintner"
<no****@nospam. comwrote:

Yes that helps, because it eliminates the new Attachements feature in
A2007 from consideration.
Typically you want to store documents in the file system. Your app
would have a "root" folder option, and the files are below that root.
Sometimes they can all be stored in one folder, sometimes you want to
create a folder tree. That's more useful for humans than for programs.

Your app would also have a table with filenames, 1 to many to the main
table. E.g. if these were files about orders, you would create
tblOrderFiles:
FileID (auto, PK)
OrderID (required; link to tblOrders.Order ID)
FileName (required)

Then you write queries to select, add, delete from this table.
Then a form that uses these queries to show the files in the table,
allows the user to manipulate them (e.g. Add, Delete), and view them.

View I would do using the ShellExecute API
(http://www.mvps.org/access/api/api0018.htm)

-Tom.

>I am looking for add-on tools or code to allow me to attach scanned PDF
documents to a database record.

I would like to know if there are developer tools out there that can do the
following:
- Appending muliple as in many PDF docs to a specific record.
- Or maybe I create a folder and the AccessDB reads the contents of the
folder showing the files related to the specific record.

Kinda like a achive file manger of related files to a database record.

Note: Eventually this access database will be pushed to SQL server if that
helps.

Can anybody help me with this?

Thank you in advance.
Michael Kintner

[Arvin Meyer [MVP]]

Access 2007 is the first version which allows attachments to a record.
Earlier versions allowed embedding some document types.

You can simply open a document by using the ShellExecute api on the stored
path to the document:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Michael Kintner" <no****@nospam. comwrote in message
news:13******** *****@corp.supe rnews.com...

>I am looking for add-on tools or code to allow me to attach scanned PDF
documents to a database record.

I would like to know if there are developer tools out there that can do
the following:
- Appending muliple as in many PDF docs to a specific record.
- Or maybe I create a folder and the AccessDB reads the contents of the
folder showing the files related to the specific record.

Kinda like a achive file manger of related files to a database record.

Note: Eventually this access database will be pushed to SQL server if that
helps.

Can anybody help me with this?

Thank you in advance.
Michael Kintner

[Larry Linson]

You can also open a document with the Application.Fol lowHyperlink statement.
It's worked for documents on which I've used it whose file types were
registered.

Is it any _better_ than using ShellExecute? I don't know. Anybody have
information one way or the other?

Larry Linson
Microsoft Access MVP

"Arvin Meyer [MVP]" <[e-mail] in message
news:%2******** **********@TK2M SFTNGP04.phx.gb l...

Access 2007 is the first version which allows attachments to a record.
Earlier versions allowed embedding some document types.

You can simply open a document by using the ShellExecute api on the stored
path to the document:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Michael Kintner" <no****@nospam. comwrote in message
news:13******** *****@corp.supe rnews.com...

>>I am looking for add-on tools or code to allow me to attach scanned PDF
documents to a database record.

I would like to know if there are developer tools out there that can do
the following:
- Appending muliple as in many PDF docs to a specific record.
- Or maybe I create a folder and the AccessDB reads the contents of the
folder showing the files related to the specific record.

Kinda like a achive file manger of related files to a database record.

Note: Eventually this access database will be pushed to SQL server if
that helps.

Can anybody help me with this?

Thank you in advance.
Michael Kintner

[David W. Fenton]

"Larry Linson" <bo*****@localh ost.notwrote in
news:u%Y6i.3724 $D31.1612@trndd c01:

You can also open a document with the Application.Fol lowHyperlink
statement. It's worked for documents on which I've used it whose
file types were registered.

Is it any _better_ than using ShellExecute? I don't know. Anybody
have information one way or the other?

I've had circumstances where FollowHyperlink didn't work for some
unexplained reason where ShellExecute did. Also, I believe the error
messages are different with ShellExecute -- I found them easier to
work with than FollowHyperlink , which was often completely silent.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[Arvin Meyer [MVP]]

I've occasionally had followhyperlink fail. Now that you mention it,
however, ther is an excellent hyperlink method, that hasn't failed (on me at
least) yet:

Private Sub cmdMyButton_Cli ck()
Me.cmdMyButton. HyperlinkAddres s = "C:\Data\" & Me.txtFileName
End Sub

where C:\Data\ is the folder and txtFileName completes the fully qualified
path.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Larry Linson" <bo*****@localh ost.notwrote in message
news:u%Y6i.3724 $D31.1612@trndd c01...

You can also open a document with the Application.Fol lowHyperlink
statement. It's worked for documents on which I've used it whose file
types were registered.

Is it any _better_ than using ShellExecute? I don't know. Anybody have
information one way or the other?

Larry Linson
Microsoft Access MVP

"Arvin Meyer [MVP]" <[e-mail] in message
news:%2******** **********@TK2M SFTNGP04.phx.gb l...

>Access 2007 is the first version which allows attachments to a record.
Earlier versions allowed embedding some document types.

You can simply open a document by using the ShellExecute api on the
stored path to the document:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Michael Kintner" <no****@nospam. comwrote in message
news:13******* ******@corp.sup ernews.com...

>>>I am looking for add-on tools or code to allow me to attach scanned PDF
documents to a database record.

I would like to know if there are developer tools out there that can do
the following:
- Appending muliple as in many PDF docs to a specific record.
- Or maybe I create a folder and the AccessDB reads the contents of the
folder showing the files related to the specific record.

Kinda like a achive file manger of related files to a database record.

Note: Eventually this access database will be pushed to SQL server if
that helps.

Can anybody help me with this?

Thank you in advance.
Michael Kintner

[Larry Linson]

Thanks, Arvin and David. I haven't used Application.Fol lowHyperlink a great
deal, and had not encountered a failure, but I'll keep an eye on it. When
it fails, does it just do so on some hyperlink addresses, or always on some
records, or always for the table?

Larry Linson
Microsoft Access MVP
"Arvin Meyer [MVP]" <[e-mail] in message
news:OK******** ******@TK2MSFTN GP04.phx.gbl...

I've occasionally had followhyperlink fail. Now that you mention it,
however, ther is an excellent hyperlink method, that hasn't failed (on me
at least) yet:

Private Sub cmdMyButton_Cli ck()
Me.cmdMyButton. HyperlinkAddres s = "C:\Data\" & Me.txtFileName
End Sub

where C:\Data\ is the folder and txtFileName completes the fully qualified
path.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Larry Linson" <bo*****@localh ost.notwrote in message
news:u%Y6i.3724 $D31.1612@trndd c01...

>You can also open a document with the Application.Fol lowHyperlink
statement. It's worked for documents on which I've used it whose file
types were registered.

Is it any _better_ than using ShellExecute? I don't know. Anybody have
information one way or the other?

Larry Linson
Microsoft Access MVP

"Arvin Meyer [MVP]" <[e-mail] in message
news:%2******* ***********@TK2 MSFTNGP04.phx.g bl...

>>Access 2007 is the first version which allows attachments to a record.
Earlier versions allowed embedding some document types.

You can simply open a document by using the ShellExecute api on the
stored path to the document:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Michael Kintner" <no****@nospam. comwrote in message
news:13****** *******@corp.su pernews.com...
I am looking for add-on tools or code to allow me to attach scanned PDF
documents to a database record.

I would like to know if there are developer tools out there that can do
the following:
- Appending muliple as in many PDF docs to a specific record.
- Or maybe I create a folder and the AccessDB reads the contents of the
folder showing the files related to the specific record.

Kinda like a achive file manger of related files to a database record.

Note: Eventually this access database will be pushed to SQL server if
that helps.

Can anybody help me with this?

Thank you in advance.
Michael Kintner