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. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
OLE Object Makes Database to Large
BTW, below is some of the text I saved from posts on this.....I just "got
by" on this, did not write these nor do I know them well enough to answer questions without digging back into what we did. - - - - Store the pictures in a separate folder from the database. Add a field named PicturePath to your table and record the full path to the picture for each record. Add an image control to your form. Be sure you have PicturePath in the recordsource of your form. Put the following code in the Current Event of the form: Me!NameOfYourImageControl.Picture = Me!PicturePath. - - - - Add an image control from the toolbox for displaying your pictures. Select the image control, open properties, find the picture property and bind it to the path to your picture in your table as Fred describes. |
#12
|
|||
|
|||
OLE Object Makes Database to Large
Thanks Fred. That should help alot!
"Fred" wrote: BTW, below is some of the text I saved from posts on this.....I just "got by" on this, did not write these nor do I know them well enough to answer questions without digging back into what we did. - - - - Store the pictures in a separate folder from the database. Add a field named PicturePath to your table and record the full path to the picture for each record. Add an image control to your form. Be sure you have PicturePath in the recordsource of your form. Put the following code in the Current Event of the form: Me!NameOfYourImageControl.Picture = Me!PicturePath. - - - - Add an image control from the toolbox for displaying your pictures. Select the image control, open properties, find the picture property and bind it to the path to your picture in your table as Fred describes. |
|
Thread Tools | |
Display Modes | |
|
|