473,320 Members | 2,117 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.

TOOLS: Adding docs (PDF) to a database

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
6 7595
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
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
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
"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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: wcc | last post by:
Hello group, I wonder what tools/modules are avaible to manipulate PDF ducument, i.e., merge, split, rotate page, crop, etc.. I checked the PyPI page and seems the only one may fit the need is...
4
by: trevor.niemack | last post by:
Hello I am currently learning VB.net and I am using the tutorial on VB express. One of the tutorials is about adding a database and then creating a visual input or amendment screen but event...
3
by: benkollam | last post by:
Hi, I have problem updating the changes in the dataset to the database. I am using an Access database and following is the code used for adding a new row. Please help Private Sub...
1
Ali Rizwan
by: Ali Rizwan | last post by:
Hi I have a database having columns Stationary, Furniture, Electronics etc. I want to add a column Others using vb6 how can i do that. I know to update, adding rows but dont know how to add a...
0
by: Miloann | last post by:
I am evaluating an inhouse application developed in MS Access 97 but has been converted to 2007. I would like to evaluate data integrity, program bugs, and globally health of the design. Does...
1
by: raaaz | last post by:
Hi dears, I am adding a record in Access database using AddNew method of recordset. here is the code of the page .. <% Set RsLibBuild = Server.CreateObject ("ADODB.Recordset")...
0
by: jakeesgirl | last post by:
I have an existing database I created in sql server 2000 express that I connect to through the program I'm creating in c# visual studio express. However, I want to add the actual database to my...
4
by: jaz215 | last post by:
hi! how do i add a record in a database without using the datacontrol and adodc. i want to rework my code to using purely codes and not being dependent on the design on vb. so far i have. Set rs...
10
by: freddie007 | last post by:
The error seems to be error due to space or character set ========================================== Error Executing Database Query. Incorrect string value: '\xC2\x96 Jan...' for column 't61'...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
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)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.