Re: [MS_AccessPros] Displaying a PDF File

 

Hi Art,

I don't have time to dig in right now ... perhaps someone else will jump in.

Meanwhile, perhaps this might be useful:

Accessing TWAIN compatible scanner in Visual Basic

http://lmik.sweb.cz/

Alternately, perhaps see if there is a forum for your device and see if anyone else has asked about controlling it from VBA. did your driver come with an API?

 respectfully,

crystal
 
~ have an awesome day ~

On 6/26/17 11:34 AM, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] wrote:

This particular scanner is a HP Desktop 1051 using a TWAIN driver and it is connected directly to my desktop via USB. One the system goes live it would be any TWAIN Scanner . So I will need to be able to fill my cmdScanner combo box with whatever scanner is installed on the machine. Here is the link to scanner's user manual.

HP Deskjet 1051 All-in-One Printer User Guides | HP® Customer Support

HP Deskjet 1051 All-in-One Printer User Guides | HP® Customer Support Manuals or User Guides for your HP Deskjet 1051 All-in-One Printer

With Warm Regards,

 

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265  Ext. 130

Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."  

---

From: "crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Monday, June 26, 2017 10:49 AM
Subject: Re: [MS_AccessPros] Displaying a PDF File

 

Hi Art,

I did not look at the file with your screen shot of the form. More important, what is your scanner Make and Model, and how is it connected? And, if you can find it, where is a link to its documentation? thanks

respectfully,
crystal

~ have an awesome day ~

On 6/26/17 9:58 AM, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] wrote:

That is exactly what I want to do. I am currently working on a document management System for Access and I have a form called frmScan and on the form is a cmdScan button that I need to activate the scanner and then scan it in. It will be kept as an external file. I will upload the screen to the needs assistance folder to give yo a better idea of what I am after.

With Warm Regards,

 

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265  Ext. 130

Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."  

---

From: "crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Sunday, June 25, 2017 7:25 PM
Subject: Re: [MS_AccessPros] Displaying a PDF File

 

Hi Art,

that depends on your scanner ... what happens to the files that are scanned. Where do they go?

As for pulling 'into' Access, I highly recommend you keep it stored as an external file -- perhaps just move and rename it.

respectfully,
crystal
 
~ have an awesome day ~

On 6/25/17 11:31 AM, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] wrote:

Ant ideas how to pull a file from a scanner into acess/ 

With Warm Regards,

 

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265  Ext. 130

Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."  

---

From: "Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: "MS_Access_Professionals@yahoogroups.com" <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, June 22, 2017 12:02 PM
Subject: Re: [MS_AccessPros] Displaying a PDF File

 

I see how that would work and I implemented into my project and it works fine. But now I need to be able to do the same thing but bring the document in from a scanner. Any ideas? 

With Warm Regards,

 

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265  Ext. 130

Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."  

---

From: "crystal 8 strive4peace2008@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, June 21, 2017 4:34 PM
Subject: Re: [MS_AccessPros] Displaying a PDF File

 

hi Art,

here you go :)

How To Display PDFs In A Form
- by Programming (Steve Bishop)
https://www.youtube.com/watch?v=KeyoRBTAa9I

once you add Web Browser Control, which can display any file accessible not just file on the net, click on the Base URL property and then the Expression Builder and select the source, which can be a calculated field in the RecordSource.  This sets the Control Source for the Web Browser and links it to your form

This example is to also allow the user to browse to a file to show but you may not need that part.

respectfully,
crystal

~ have an awesome day ~

On 6/20/17 11:08 AM, dbalorenzini@yahoo.com [MS_Access_Professionals] wrote:

Is there a way to display a PDF file within access. Maybe a control or something? If possible,  how would I implement it?

__._,_.___

---

Posted by: crystal 8 <strive4peace2008@yahoo.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (10)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___