This is a discussion on "Access databases.... anyone know much?" within the Databases section. This forum, and the thread "Access databases.... anyone know much? are both part of the Program Your Website category.
|
|
|
|
|
 |
||
Access databases.... anyone know much?
|
||
| Notices |
 |
|
|
LinkBack | Thread Tools |
Jul 1st, 2004, 20:32
|
||||
|
||||
|
Access databases.... anyone know much?
Does anyone know how to add a bound image to a report so that each record has its own image (for example, an image of each employee by their record...)
please help!! 
|
|
|
|
Jul 1st, 2004, 20:47
|
|||
|
|||
|
I just use the links to do the images... i don't actually bound an image into the database itself..
|
|
Jul 1st, 2004, 22:36
|
|||
|
|||
|
You can store an image in a OLE Object field, but I generally just save a link in a text field that points to the image for each record.
See the following for examples and details of the OLE technique http://search.msn.com/results.aspx?F...ess+ole+object
|
|
Jul 2nd, 2004, 08:14
|
|||
|
|||
|
Just give each image the same name as the employeeID like: 34.jpg so you can used the ID to call it.
|
|
Jul 2nd, 2004, 08:22
|
||||
|
||||
|
how do you call it though? so that I can display it in a report
|
|
Jul 2nd, 2004, 13:04
|
||||
|
||||
|
ok... does anyone know what this message means when i try to add a file to the ole field in a table:
A problem occurred when Microsoft Access was communicating with the OLE server of ActiveX Control. Close the OLE server and restart it outside of Microsoft Access. What do i have to do?
|
|
Jul 2nd, 2004, 13:39
|
||||
|
||||
|
Dont use OLE objects!!
in fact, you dont need to store anything in the DB at all!! (not even a file name) just make the image filename the same as the employeeid. You can then use the fileexists function (filesystemobject) to determine whether or not you have an image for that employee!
__________________
Rob - SEO Specialist Owner & Founder of Webforumz.com I am currently unavailable for private work
Last Blog Entry: Creative Labs threaten developer over home made drivers.... (Apr 1st, 2008)
|
|
Jul 2nd, 2004, 13:43
|
||||
|
||||
|
but how do i then make each image appear on each record in the report?
|
|
| Tags |
| access, databases |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Databases? | Apocalyptic Poet | Classic ASP | 1 | Apr 23rd, 2008 12:24 |
| ASP Multi users Access to Microsoft Access | ish | Classic ASP | 0 | Apr 26th, 2007 20:05 |
| Populating databases | DennisK | PHP Forum | 9 | Nov 16th, 2006 15:55 |
| Databases on Easily.co.uk | Paula | Classic ASP | 2 | Sep 21st, 2006 09:19 |
| no databases in phpmyadmin | Drgreenfingers | Databases | 1 | Feb 4th, 2006 21:21 |
