By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,544 Members | 2,065 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,544 IT Pros & Developers. It's quick & easy.

TOOLS: Adding docs (PDF) to a database

P: n/a
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
May 29 '07 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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.OrderID)
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
May 29 '07 #2

P: n/a
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.supernews.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

May 29 '07 #3

P: n/a
You can also open a document with the Application.FollowHyperlink 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]" <a@m.comwrote in message
news:%2******************@TK2MSFTNGP04.phx.gbl...
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.supernews.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


May 29 '07 #4

P: n/a
"Larry Linson" <bo*****@localhost.notwrote in
news:u%Y6i.3724$D31.1612@trnddc01:
You can also open a document with the Application.FollowHyperlink
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/
May 29 '07 #5

P: n/a
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_Click()
Me.cmdMyButton.HyperlinkAddress = "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*****@localhost.notwrote in message
news:u%Y6i.3724$D31.1612@trnddc01...
You can also open a document with the Application.FollowHyperlink
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]" <a@m.comwrote in message
news:%2******************@TK2MSFTNGP04.phx.gbl...
>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.supernews.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



May 29 '07 #6

P: n/a
Thanks, Arvin and David. I haven't used Application.FollowHyperlink 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]" <a@m.comwrote in message
news:OK**************@TK2MSFTNGP04.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_Click()
Me.cmdMyButton.HyperlinkAddress = "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*****@localhost.notwrote in message
news:u%Y6i.3724$D31.1612@trnddc01...
>You can also open a document with the Application.FollowHyperlink
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]" <a@m.comwrote in message
news:%2******************@TK2MSFTNGP04.phx.gbl. ..
>>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.supernews.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



May 31 '07 #7

This discussion thread is closed

Replies have been disabled for this discussion.