[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

take photo and add to access database

Posted on 2014-08-07
4
Medium Priority
?
1,189 Views
Last Modified: 2014-08-08
I'm developing a visitor database in Access 2013 and want to know if anyone knows if it is possible to take a photo from the onboard camera on the PC and place it in a designated field which will then print on a visitor badge report.
0
Comment
Question by:LJShepherd
  • 2
  • 2
4 Comments
 
LVL 58
ID: 40246675
Yes, you can.  There are a wide range of options.  In the general, the usual approach is to have the camera save the pic as a file on disk, then using an image control in a form, point to that file.   In the DB, you'd only store the description and other attributes (ie. "Date taken"), and a path to the picture.

 I would also suggest you take a look at:

DBPix,
http://www.ammara.com/dbpix/access.html

 Which makes it simple to manage and use pictures within Access.   You don't have to have this, but it makes it easier.

Jim.
0
 

Author Comment

by:LJShepherd
ID: 40247514
Hi Jim,

Thanks for your post. I will take a look at DBPix. Do I take it that I can use an access button to prompt the camera to shoot and then get DBPix to process the photo and store it in an access table ready to print on the visitor badge?

If I don't respond in the next few hours it is because I am in the UK and will not pick up any responses until tomorrow morning.

Cheers

Les
0
 
LVL 58

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 1500 total points
ID: 40248723
Les,

 The usual approach is to put up a message "Ready to accept picture", then have someone press the button on the camera.

  DBPix, Access, etc, are all designed to use the acquisition methods built into Windows and that method (and there are several) along with the camera and it's driver determine what you can do.

  So my advice would be to keep it as simple as possible.  However, yes you can do exactly that.  Take a look at:

http://www.ammara.com/support/samples/access-wia-camera-control.html

 WIA is however an old technology, but still supported in newer versions through WPD, so everything in DBPix should still work fine.  

 They offer a free download, so I would download and try the sample code with your camera and see if you can get what you want.

Jim.
0
 

Author Comment

by:LJShepherd
ID: 40248734
Excellent Jim,

Thank you. I'll give it a blast and see how I get on.

Meantime I'll accept your answer and award the points.

Cheers

Les
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question