Is there a way to insert a small photo into an existing text field and make it controlled so it would only be seen on a certain record??
Using access 2003 and XP-PRO for and O/S.
Competent Performer
Windows XP 
Access 2003
Is there a way to insert a small photo into an existing text field and make it controlled so it would only be seen on a certain record??
Using access 2003 and XP-PRO for and O/S.
MS MVP - Access Expert
Windows 7 Access 2010 (version 14.0)
See this example here
Boyd Trimmell aka Hitechcoach
Database Architect and Problem Solver
Microsoft MVP - Access Expert
25+ years specializing in Accounting, Inventory, and CRM systems
"If technology doesn't work for people, then it doesn't work."
Competent Performer
Windows XP Access 2003
I am still not sure how to prep a table to insert bitmaps into a row or column so I can display the bitmap from a text field on a form as an embedded object. ??
MS MVP - Access Expert
Windows 7 Access 2010 (version 14.0)
First, you can NOT insert an image into a text field. You must use an OLE Object data type.
Second, you should avoid storing images as a OLE Object. You will quickly bloat your database to the 2 gig limit. When that happens you an corrupt your database beyond repair. I have done it.
If you must store the image in the table then I would recommend this: DBPix
Boyd Trimmell aka Hitechcoach
Database Architect and Problem Solver
Microsoft MVP - Access Expert
25+ years specializing in Accounting, Inventory, and CRM systems
"If technology doesn't work for people, then it doesn't work."
Competent Performer
Windows XP Access 2003
I get your meaning. I think I will just park the pics in a specific location and just insert a link on a particular record form.
Thanks for your help.....
Posting Permissions
Reply With Quote