Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Having picture(s) in a database 4

Status
Not open for further replies.
EllieFant

EllieFant

MIS
May 15, 2001
513
US
This is a personal use database that I am wanting to create for a friend.

She collects Fenton Glassware (has a huge collection). What I want to do for her is create a database where she can have information about each piece of glassware that she has. It will have lots of information to input which is no problem.

My question is what is the best way to let her insert a picture into the record? I know I don't want the pictures in the database, but just linked to it.

Then my next question is going to be how to go about printing these pictures in a report (generated by a query)?

What I know she is going to want to do is be able to pull up all her "red" "vases" and print it out so that she will be able to take it with her when she goes shopping. Not that she really minds having duplicates :)

Ellie
**Using Access 97**

lena.wood@wgint.com (work)
elliefant@starband.net (home)
 
Sort by date Sort by votes
In your table, store the pictures in a field. Set the data type to OLE Object. Then you'll have to go toeach record, go to the menu and go Insert/Object and follow the Wizards....

In your report, add a Bound Object Frame, and makes it's reord source that field.
 
Upvote 0 Downvote
OK, got that part figured out. Now, how can I make it really simple for her to insert the picture for those that she has pictures for? Is there a way to make it so she can click on a command button on the form and have it ask her to locate the picture?

I looked in the button wizard. I am sure it is really simple...but I don't know anything about writing code for access. I am trying to learn. Just takes EXTREME baby steps.

Thanks
Ellie
**Using Access 97**

lena.wood@wgint.com (work)
elliefant@starband.net (home)
 
Upvote 0 Downvote
No way to make an insert picture button? Ellie
**Using Access 97**

lena.wood@wgint.com (work)
elliefant@starband.net (home)
 
Upvote 0 Downvote
OK - just getting antsy - sorry - *smacks my own hand* Ellie
**Using Access 97**

lena.wood@wgint.com (work)
elliefant@starband.net (home)
 
Upvote 0 Downvote
Simple actually.

DoCmd.RunCommand acCmdInsertObject

Now, this will fire an error if you're not in the table. I would suggest creating a form and binding all the fields to your table. You're picture will be a bound object frame. Name it objPic .Put a button on the form called cmdAddPic, set the caption to Add a Picture, and put the following code behind it

me.objPic.setfocus
DoCmd.RunCommand acCmdInsertObject


 
Upvote 0 Downvote
Do I put this in the On Click event procedure for my command button on the form? Ellie
**Using Access 97**

lena.wood@wgint.com (work)
elliefant@starband.net (home)
 
Upvote 0 Downvote
It works like a dream!

I have one more question about this subject. The person I am making this database for is not a big computer user and I would like to make this is easy as possible.

Can it be made so that it will automatically know that I want to create this from a new file and make it a link or is this something she will have to choose each time?

Thanks again for all your time and help! Ellie
**Using Access 97**

lena.wood@wgint.com (work)
elliefant@starband.net (home)
 
Upvote 0 Downvote
Is there a link or a URL for learning about pictures as OLE objects? I really want to learn how to do this, and believe me, you all have helped me leaps and bounds. Ellie
**Using Access 97**

lena.wood@wgint.com (work)
elliefant@starband.net (home)
 
Upvote 0 Downvote
Ellie,
She is going to have to point to where the picture is being stored, and she will have to click the "link" option in the insert object dialog box. I don't think there is a way around it. :(

HTH
 
Upvote 0 Downvote
Guess it is down to making her a step by step manual on using this. Gotta love screen capture.

Thanks anyway. Ellie
**Using Access 97**

lena.wood@wgint.com (work)
elliefant@starband.net (home)
 
Upvote 0 Downvote
Hi, Ellie!

My advise: never save pictures in the Access DB table fields notably if you want to save many pictures. I have big problem with huge DB (~650Mb with 500! photos). Now I search for way how to extract these photos from DB. Save in the table only links to these image files. You can create field type OLE Object or Hyperlink.
If you use action InsertObject for saving picture into OLE Object field then check Link ie. save only links.

Aivars
 
Upvote 0 Downvote
Well I believe there is a way to make the pictures linked all the time. I do this in my DB so that it doesn't get as big as other DBs. If you have your form in Design View and Right Click on the OLE Bound Ojbect Frame and go to Properties then you should find in the ALL tab a line that says OLE Type Allowed. If you put this on Linked then the Link Check box in the InsertObject window will always be checked and also Grayed out so it cant be unchecked. If that is what you are after.

Nate
 
Upvote 0 Downvote
If you use the standard Microsoft method of storing pictures, database size becomes a serious issue. However!...

There are controls out there, relatively inexpensive by the way, that work around this size problem and store pics efficiently making this type of storage reasonable. That way we don't have to worry about the path of external picture files.

Gary
gwinn7

 
Upvote 0 Downvote
For example. In our office, we have a database that stores our photos. The size of the database is just under 400MB. Sounds large right? Well, its small if you are storing 6500+ pictures! Another advantage is the load time verses a linked picture. Its fast!

Gary
gwinn7
 
Upvote 0 Downvote
Thank you for all your tips and advice.

By clicking the link check box that makes the pictures stored outside the database, correct?

As for the speed of the database....this database is going to be more for inventory of a collection for insurance reasons. I know she will be using it for other reasons, but speed isn't a big issue at this time.

You guys are the GREATEST and I wish I could give each of you a dozen little stars by your names...PURE GOLD at that. :) Ellie
**Using Access 97**

lena.wood@wgint.com (work)
elliefant@starband.net (home)
 
Upvote 0 Downvote
Nate,

THANK YOU for your tip on making the pictures the linked kind all of the time. This will really cut down on the number of steps she will have to take to insert a picture. This is exactly what I was wanting to do...make it as simple as possible. Ellie
**Using Access 97**

lena.wood@wgint.com (work)
elliefant@starband.net (home)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Using Access Database Without Having MS Access
Replies
9
Views
860
grnzbra
grnzbra
ameedoo3000
  • Question
switch between two open database
Replies
12
Views
535
Andrzejek
Andrzejek
renigar
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
368
renigar
renigar
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
652
TheresAlwaysAWay
TheresAlwaysAWay
PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
266
PizMac
PizMac

Part and Inventory Search

Sponsor

Back
Top