Holy Toledo John, You are a genius Thank you very much
Ross B --- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote: > > 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 --------------------~--> 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/
