Go paperless

sacredarms

unread,

Sep 26, 2006, 7:23:01 PM9/26/06

to

I'm trying to add employee pictures and other information such as drivers
licences to my database much like the Northwind sample db but need hel;p in
getting started. Cannot see were the pictures are stored in the sample
database.
Help

Pieter Wijnen

unread,

Sep 26, 2006, 8:02:17 PM9/26/06

to

In simple words *don't*
Access *hates* (stored) images
store the path & look at http://www.lebans.com on how to handle them

--
Pieter Wijnen

My feeble Access pages (good links though)
http://www.thuleeng.com/access
When all else fail try:
http://www.mvps.org/access
http://www.granite.ab.ca/
http://allenbrowne.com/
http://www.lebans.com/

"sacredarms" <sacre...@discussions.microsoft.com> wrote in message
news:FBFDF5F7-D367-42D2...@microsoft.com...

--------------------------------------------------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4868 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!

Arvin Meyer [MVP]

unread,

Sep 26, 2006, 9:16:39 PM9/26/06

to

"sacredarms" <sacre...@discussions.microsoft.com> wrote in message
news:FBFDF5F7-D367-42D2...@microsoft.com...

For the "best" way to do it, have a look at:

http://www.datastrat.com/Download/Picture2K.zip

you can import everything right into your own database.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

sacredarms

unread,

Sep 26, 2006, 10:17:02 PM9/26/06

to

I downloaded picture 2k, do I link to it or import it to my database. All
help appreciated.

Thanks

Joe

Tom Wickerath

unread,

Sep 27, 2006, 3:22:02 AM9/27/06

to

Hi Joe,

I just looked at Arvin's sample. To answer your question, import

three forms: frmCreateTable, frmMain and frmPicture
one report: rptPicture and
three modules: modCallPath, modPath_File and modUtility

into your database. (You might want to first verify that you do not have any
forms, reports or modules with the same name). Make sure that your database
includes a checked reference to the "Microsoft DAO 3.6 Object Library", and
that it is higher in priority than a reference to "Microsoft ActiveX Data
Objects 2.X Library", if you have a reference set to this library (ADO). To
do this, open one of the modules that you imported. Then click on Tools >
References. You should see the DAO library as a checked reference in the
list. Dismiss the references dialog by clicking OK. Then make sure that your
code compiles, by clicking on Debug > Compile ProjectName. Correct any
compile errors if required. Close the module.

To use this functionality in your database, you simply need to open the
frmMain form.

You might want to take a look at this article for hints on how to make minor
modifications to the code, so that reference priority will not be a possible
bug waiting to bite you in the future:

ADO and DAO Library References in Access Databases
http://www.access.qbuilt.com/html/ado_and_dao.html

Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

Arvin Meyer [MVP]

unread,

Sep 27, 2006, 6:35:10 AM9/27/06

to

First, just open it up and play with it a while. While you can link to it by
setting a reference, it is much easier to just import everything into your
database and alter it as you wish.

--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"sacredarms" <sacre...@discussions.microsoft.com> wrote in message
news:43C6FF39-B9B0-4721...@microsoft.com...