Have to create a catalogue in Ms Acess

[pakiyabhai]

Ok , I have Micorosoft Access 2k2 , I have to create a catalgoue ,for some items in my dad's company with the emphasis on picture ,

PICTURE MUST be displayed properly in jpg format , and everday 30-20 pictures are added , i like to store it in folders ....like

1 June - 7 June ----> 1 -2 -3 -4
(Parent Folder) (sub-folders)

Now, I have read this topic here

http://www.tek-tips.com/gfaqs.cfm/lev2/4/lev3/27/spid/181/sfid/279

which allows to load picture without storing .

So I go like , I create a table.

1. Item Code - No.
2. Date
3. Item Name- Text
4. Picture < IS THIS REQUIRED > ?????

Now according to wat the article says

http://www.tek-tips.com/gfaqs.cfm/lev2/4/lev3/27/spid/181/sfid/279

, i load an image , properties , delete the image , insert the given code , and run the forum but I get the error


put this code in current thing , when I run it get the error

&quot;MICROSOFT CANNOT FIND THE FIELD 'ID' REFFERED in my database, i am asked to debug and the focus comes on the IInd line of the code ..... &quot;

I need help with this now , if any1 knows a better software or something to create the catalogue or the answer to wat I am doing wrong , please do reply !

thanx in advance

 

[thornmastr]

Have you considered using a hyperlink to point to your image.

Robert Berman

 

[pakiyabhai]

if I use hyperlink , will the image be displyaed in forms or reports ??

 

[oharab]

What you need to do is store just the path to the image file in the database file.
On your forms put this code in the OnCurrent event

if me!pixpath<>&quot;&quot; then Me!Image14.Picture =me!pixPath

where Image14 is your empty picture file and pixpath is the field with the path to the file.
On reports you have to put it in the OnPrint event.

Enjoy

Ben ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------

 

[pakiyabhai]

thanx for replying oharab


now as u said

if me!pixpath<>&quot;&quot; then Me!Image14.Picture =me!pixPath

where Image14 is your empty picture file and pixpath is the field with the path to the file.


Now , U will have to help me out here again .Just c this suppose my pictures are stored in c:\mydocs , their name is say A.JPG , B.JPG , C.JPG bla bla so the code will be

if me!c:\mydocs\<>&quot;&quot; then Me!A.JPG.Picture= me!C:\mydocs

is this the right code ???? I am getting a ifthen compile error

becoz I haave many pics in there how will read it all ?? I konw I am doing something wrong

 

[oharab]

Lets take your table as an example

Set it up like:

1. Item Code - No.
2. Date - Date/Time
3. Item Name - Text
4. Picture - Text

in the picture store the full path to the picture:

Item Code Date Item Name Picture
1024 01/01/2002 Widget C:\June1\1\2\Widget.jpg
.
.
.

On your form and reports put on an empty, unbound picture frame and call it imgPicture
On the OnCurrent event of the form put:

if me!picture<>&quot;&quot; then Me!imgPicture.Picture =me!Picture

As each record is viewed, the onCurrent event fires and loads your picture, stored in the field &quot;picture&quot;, into the picture frame.
I suggest you visit

http://members.tripod.com/accdevel/imaging.htm

for a downloadable example of what I mean. It's far easier to work through a working example than try to feel around in the dark!

Good luck, let us know how you get on.

B ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------

 

[pakiyabhai]

unbound empty picture frame ??

How do i insert that ??

Is it the same thing as insert -> picture or somethign diffrent ...


man I am such a beginner at access


---

OK i made the table as u said , inserted 2 records , went to forum , used wizard to import fields, now pls clear out this empty unbound object frame thing , so I can continue .........

----


The site u have given is excllent , I am looking at the pictures and tryna figure em out .

P.s 0> All of em uses Visual Basic

 

[pakiyabhai]

ok mr. oharab,

dome a small favour , create a small datbase with 2 record(for images use hyperlink or just give the refrence on your comp , i will change that ), and with a forum ..

email it to me at thegame_ya@Yahoo.com , that will be the best example for me

or please troubleshoot as I go along !!

 

[Guest_imported]

i got it man , thanx oharab

 

[oharab]

Sorry I didn't reply, was out of the office most of the day. Glad you got it sorted.

B ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------

 

[Francescina]

You could use the Graphic for Access Wizard (see

http://www.unsoftwareag.com/toGWA.htm)

to store the photos inside the table without bloating it. It works very well, even with ACCESS 2002.

 

[pakiyabhai]

mr. fracescina , GIWA looks good , but I wanna atleast try it out first , be4 buying , this is a straight forward buy without even buying

Any other programs ?? suggestion welcome