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 » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Cannot insert Pictures again



 
 
Thread Tools Display Modes
  #1  
Old April 28th, 2005, 11:39 AM
Peter
external usenet poster
 
Posts: n/a
Default Cannot insert Pictures again

Hi,

We manage to insert the photos for Employee (JPG Files) on
our database.

However, we would like to allow end users to insert the
photos by themselves (i.e. giving them the choice of the
location and drive that they can insert the JPG file) ?

I have given an advice to use the MS Common Dialog Control
but there is problem. Some one advices me to use the
Common Dialog API in an Access Database.
http://support.microsoft.com/?kbid=303066

In this way, I change the coding as follow:

Private Sub Command1_Click()
Dim strFile As String
If LaunchCD(Me) "" Then
ImageBox.SourceDoc = LaunchCD(Me)
ImageBox.OLETypeAllowed = acOLELinked
ImageBox.Action = 1
End If
End Sub

ImageBox is the name of the container for the JPG file.

It works when we insert graphics in ImageBox if it is
blank (ie insert graphics successfully the first time).
However, when we attempt to insert again, there is error.
And it points to the line "ImageBox.Action = 1".

Your advice is sought.


 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot insert Pictures again Peter Using Forms 0 April 28th, 2005 11:37 AM
publisher crashes when trying to insert pictures after updates ins wniel General Discussions 1 April 6th, 2005 10:41 AM
insert pictures by automation? ljb Powerpoint 2 January 25th, 2005 01:15 PM
Insert Pictures into merge document Jeff Bendert Mailmerge 4 September 15th, 2004 08:14 AM
Insert pictures in powerpoint Rafe Powerpoint 4 June 9th, 2004 02:36 AM


All times are GMT +1. The time now is 12:37 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.