Store Picture In Access

[a_20120]

Hi every one,
Needed ur urgent help, I want to insert picture in the IMAGE CONTROL on the form (Not Directly in Table) , and after filling all data...when I click on SAVE BUTTON, all the Data store in the table...
if possible, plz reply me as soon as u can...

 

[a_20120]

Help !!!

Any One help me plz, Help me with above thread...there should be some one answer me, specially Mr. OldSoftBoss, who is the Maker of the Sample Picture DB...

 

[snc]

it is just a idea but in the table but a file path to where the picture is held and place the picture infront so when you save a picture u save a bitmap to a folder and just save the file path and pull out the picture when you need it ???

 

[Oldsoftboss]

I must have answered this question a thousand times. Do a SEARCH if it is that URGENT

 

[a_20120]

Store File Name + Extension

Hi All,
I want to store the file name and it extention, not all the path of the picture...but I dont know what is the error...also when I change the place of the DB folder, does not recognise the path...plz see the attached file

 

[a_20120]

Just have a look at the attached file

I dont know, why I cant store the name and the extension of Picture file...

I tried and searched much, but still dont know what is the problem?

 

[a_20120]

Plz Anyone specialy Mr. OldSoftBoss find the problem...I tried but could not...

 

[ColinEssex]

Your search should have found this thread complete with a sample Db

here

Col

 

[a_20120]

Dear ColinEssex,
Plz try to add new Image, after clicking on SAVE button, the error 3163 appears... plz try the DB once

 

[Oldsoftboss]

Try this......

 

[Oldsoftboss]

Or if you put the Db and all the images in the same folder.....

 

[a_20120]

Thanks All

Could u plz have a look at the attached file...
and also I used the functions MID(), INSTRREV() to separate the file name and its extension from the Full Path...

 

[a_20120]

Thanks Mr. OldSoftBoss,
Plz have a look at the aboveThread...plz

 

[Oldsoftboss]

Insert a listbox and paste the following as the rowsource:

SELECT tblPicture.PicSN, tblCategory.CategoryName, tblDistrict.DistrictName, tblCrop.CropName FROM tblCrop INNER JOIN (tblDistrict INNER JOIN (tblCategory INNER JOIN tblPicture ON tblCategory.CategoryID = tblPicture.PicCategory) ON tblDistrict.DistrictID = tblPicture.PicDistrict) ON tblCrop.CropID = tblPicture.PicCrop;

 

[Oldsoftboss]

a20120
Do you have a VB background? You have a strange way of using forms without a recordsource, and then using code to add directly to the table recordset. Normally, if you put an entry in, you could simply use the undo command to exit without saving.

Not sure what you are trying to achieve with the Db, the sample I posted will parse the file name and break it up into it's individual parts so you can save any parts you want.

Dave

 

[a_20120]

Thanks Much Mr. OldSoftBoss,
Could u plz put the attached file, How did u do, Bcoz I am really confused...

 

[a_20120]

Mr. OldSoftBoss,
Could u plz put the attached file,bcoz I am in need of that, I should do that as soon as possible, if possible plz put the attached file, How to make a review Form for Images through the list box.

 

[a_20120]

Hi All,

Thanks for the replying, Could u plz guide me how to connect List Box with Image Control, also with Customised Navigation Button?
For further information see the attached DB...

 

[a_20120]

Hi every One,
Plz some One solve the above DB problem...

 

[a_20120]

Hi All

There should be some one who can help and guide me!!!
I tried much but unfortunately really confused, also thanking Mr. OldSoftBoss!!! for helping me...