View Single Post
  #8   Spotlight this post!  
Unread 18-03-2004, 19:18
Pierson's Avatar
Pierson Pierson is offline
Registered User
no team
Team Role: College Student
 
Join Date: Nov 2001
Rookie Year: 2000
Location: Los Angeles, CA
Posts: 881
Pierson is a glorious beacon of lightPierson is a glorious beacon of lightPierson is a glorious beacon of lightPierson is a glorious beacon of lightPierson is a glorious beacon of lightPierson is a glorious beacon of light
Send a message via AIM to Pierson
Re: Access Database help...

Quote:
Originally Posted by Lindsey
I had this problem last year (I can't write code either)
I ended up figuring out how to put pictures in after the season was over.

1. Create a field in your table to hold the pictures (Design View)
2. Set the Data Type to OLE Object
3. Switch to Data Sheet view and right click in the cell instead typing in data
4. Select Insert Object
5. Select Create From File
6. Chose Browse and select the file or type in the location

The picture won't show up in Data Sheet view, you can only view the pictures through a form or a report

Hope this helps
Lindsey

One thing you will need to remember is that you will most likely need to resize the picture to something like 200x200 or 300x300.

I created our team's DB in access and got pictures working in January and I now have queries that figure out how long a person has been on a team, how much money they have brought in and other fun things.

If you have any questions, please feel free to PM or e-mail me: PC@BPRobotics.com.
__________________
Pierson
Former Captain & Fundraiser of Team 360
__________________
Join in on these fun threads:
Three Worded Story
Word Association