Ross- I assume PhotoFileName is a text box. As the error message implies, a text box has a Text property only when it has the focus. I suspect you want the value in the text box. Just use Me.PhotoFileName.
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: Sunday, November 20, 2005 5:23 PM To: [email protected] Subject: [ms_access] Re: Import Photos into a Access 2000 File 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 ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/u8TY5A/tzNLAA/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/
