A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Image Handling in an Access Database



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old May 8th, 2009, 12:54 PM posted to microsoft.public.access
Knickerless Parsons
external usenet poster
 
Posts: 5
Default Image Handling in an Access Database

I'm using Access 2007 to develop a simple personnel database.

One of the fields in the main table is an OLE object which has been
used to store an image of each staff member. Up to now, the users
access the table directly and paste the image in from an open word
document. There is also an associated form that allows the users to
update some (not all) of the numeric and string data.

I've been asked to tidy up the application so I'd like to include the
image in the data entry form with a browse button so it can be
replaced by browsing to an alternative jpeg file. I suppose a remove
button would also be useful.

The form is used for entering new records as well as modifying
existing ones.

I've spent a hour or so googling around but can't find anything that
fits my requirements exactly. I don't suppose any of you would have a
simple solution handy or can point me in the right direction?

It's important that the images are stored within the database and I
would like the solution to work in older versions of Access (2000 and
2003).

Thanks in advance,
Dave.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:41 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.