Go Back   Access World Forums > Microsoft Access Reference > Sample Databases

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-06-2019, 10:56 AM   #1
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,383
Thanks: 68
Thanked 2,698 Times in 2,583 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
cheap alternative to Access Imagine

sample picture-capturing database.
currently saving the image (bmp) to external folder.
but can also be save to an Attachment field.
the codes are not that organized so modify it as you wish.
the code comes from an excel forum with some modification
to adapt with msa.
code is 32 bit and 64 bit compatible.
tested on msa 2019 x64.
any questions, ask the original author 'coz I have not fully review the code.
Attached Files
File Type: zip photoCapture.zip (65.7 KB, 39 views)

__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 10-07-2019, 09:30 AM   #2
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,383
Thanks: 68
Thanked 2,698 Times in 2,583 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: cheap alternative to Access Imagine

found this error (Module1) while trying to run on x32 msa.

#Else
Private Declare Function GetDC Lib "user32" (ByVal hWnd As LongPtr) As LongPtr

should be change to:

#Else
Private Declare Function GetDC Lib "user32" (ByVal hWnd As Long) As Long
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 10-07-2019, 09:25 PM   #3
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,350
Thanks: 112
Thanked 2,841 Times in 2,591 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: cheap alternative to Access Imagine

@arnel
As mentioned in a PM to you yesterday, I've tested this repeatedly in Access 2010 32-bit but nothing happens when I take a snapshot. Do others have any success with it?
Setup Camera seems to do nothing. Setup Video gives a choice of front/rear camera. I've tried both! After clicking Take Snapshot the capture screen stays black

Also there is no GetDC declaration. There are GetWindowDC and GetDeviceCaps APIs.
All APIs look fine in 32-bit

As a side note, there is some useful code here such as getting the width of the nav pane which I may steal

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by isladogs; 10-07-2019 at 09:32 PM.
isladogs is offline   Reply With Quote
Old 10-07-2019, 11:03 PM   #4
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,383
Thanks: 68
Thanked 2,698 Times in 2,583 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: cheap alternative to Access Imagine

i've tested it now with a2010 x32 and it worked.
i am using WIA so it may or may not detect your camera (step 1).
if on step 2, you can see the video running, then you can capture the snapshot of the video.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 10-08-2019, 12:05 AM   #5
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,350
Thanks: 112
Thanked 2,841 Times in 2,591 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: cheap alternative to Access Imagine

Just to be clear, are you suggesting adding the Microsoft Windows Image Acquisition Library reference?
I just tried it but it had no effect.
What should happen when the Setup Camera button is clicked?

One more question - what is Access Imagine? Typo?
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 10-08-2019, 12:26 AM   #6
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,350
Thanks: 112
Thanked 2,841 Times in 2,591 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: cheap alternative to Access Imagine

OK - just tried it again on 2 more PCs - A2010 32-bit & A365 64-bit
After an initial crash its working on both of those but still not working on the Windows tablet I started testing with.

To answer my own question the WIA library reference isn't needed
And I assume Imagine is a typo for Imaging?

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by isladogs; 10-08-2019 at 04:16 AM.
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Uncle Gizmo (10-08-2019)
Reply

Tags
camera , id picture , photo , web cam

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
cheap ipod alternative - better features zelld Gadgets 11 02-16-2012 04:05 PM
any alternative for 'partition by' in Access sajid667 Queries 12 03-16-2011 10:56 PM
Alternative to getopenfilename in Ms-Access prabha_friend Modules & VBA 5 02-25-2010 02:44 AM
cheap laptop v cheap notebook rourkey The Watercooler 1 11-15-2006 04:59 PM
Order Forms (easy i imagine) MLife Forms 3 04-03-2003 11:48 AM




All times are GMT -8. The time now is 10:54 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World