Hello John the exact error is
runtime error '2185'
"You can't reference a property or method for a control unless the
control has the focus"
this is generated with te following code:
Private Sub Form_Current()
Me!Image19.Picture = "D:\Product_jpg\" _
& Me!PhotoFileName.Text
End Sub
RossB
--- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote:
>
> Ross-
>
> What's the exact error you're getting? And what's the code in
your Current
> event?
>
> John Viescas, author
> "Building Microsoft Access Applications"
> "Microsoft Office Access 2003 Inside Out"
> "Running Microsoft Access 2000"
> "SQL Queries for Mere Mortals"
> http://www.viescas.com/
>
>
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED]
On Behalf
> Of flytrap45
> Sent: Saturday, November 19, 2005 7:36 AM
> To: [email protected]
> Subject: [ms_access] Import Photos into a Access 2000 File
>
> I must be dumber than dirt but I am having a problem with this/ I
am
> attempting to show a prodoct picture on a form in products
database.
> I have about 1500 products & 1500 pictures.
>
> in my infinite wisdom I installed all the disk file names
> (C:\Products\product1.bmp etc,etc) as one of the fields in
a 'product'
> table . (This was a fairly easy task in VBA as the productID
matches the
> product picture)
>
> BUT, to show each picture on the form (or report)I am attempting
to change
> the image.picture property of an image
> control (Which is the filename& Path) using the 'OnCurrent'
event.
> This event produces an error when i try to change the control
property.
>
> I am sure I am being dense but how do you have a product picture
in a
> database without manually typing in a filename for every record??
>
> SIncerely RossB
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor --------------------
~--> Get
> fast access to your favorite Yahoo! Groups. Make Yahoo! your home
page
> http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM
> -------------------------------------------------------------------
-~->
>
>
> Yahoo! Groups Links
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
