S
SoniaC
I am trying to display a picture in a form without storing the pictures in the table.
I followed the instructions in the help file for this procedure that come in the help access but something is not working. The ImagePath Text field will change from record to record when I select the record at the combo box linked to the form, but the picture is not changing at all.
I did everything following the help file as follow:
"To display pictures that change from record to record without storing them in a table, create a text field to store the locations of the image files. You must store the locations of the pictures in a text field if you want to display the pictures in a data access page. You can also use a text field to store the location of pictures and then use those pictures in a form or report, but you must use Visual Basic event procedures to display the pictures. "
Then I add the event procedure as follow, where ImageControlName is Image13 and ImagePath is ImagePath and the path to the picture is the path for the first record in the list (F:\Converted Files\10301.JPG), then:
1.. If the field list isn't displayed, click Field List on the toolbar.
2.. From the field list, drag the field that contains the locations of the pictures to the form or report.
3.. In the toolbox, click the Image tool .
4.. On the form or report, click where you want to place the object.
5.. In the Insert Picture dialog box, specify the path to any picture, and then click OK. For example, you can type the path to the picture for the first record.
6.. Double-click the form selector or the report selector to open the property sheet.
7.. Click the Build button next to the OnCurrent property box, and then click Code Builder in the Choose Builder dialog box.
8.. Create the following event procedure. Substitute the name of the image control on your form or report for ImageControlName and the name of the control containing the path for ImagePath.
Private Sub Form_Current()On Error Resume NextMe![ImageControlName].Picture = Me![ImagePath]End Sub9.. On the File menu in the Visual Basic Editor, click Close and return to Microsoft Access.
10.. Click the control that is bound to the text field containing the location of the pictures, and then click Properties on the toolbar to open the property sheet..
11.. Click the Build button next to the AfterUpdate property box, click Code Builder in the Choose Builder dialog box, and create the following event procedure. Substitute the name of the image control on your form or report for ImageControlName and the name of the control containing the path for ImagePath.
Private Sub ImagePath_AfterUpdate()On Error Resume NextMe![ImageControlName].Picture = Me![ImagePath]End SubThis event procedure enables you to add or change a picture location in Form view.
12.. On the File menu in the Visual Basic Editor, click Close and return to Microsoft Access.
Please help.
I followed the instructions in the help file for this procedure that come in the help access but something is not working. The ImagePath Text field will change from record to record when I select the record at the combo box linked to the form, but the picture is not changing at all.
I did everything following the help file as follow:
"To display pictures that change from record to record without storing them in a table, create a text field to store the locations of the image files. You must store the locations of the pictures in a text field if you want to display the pictures in a data access page. You can also use a text field to store the location of pictures and then use those pictures in a form or report, but you must use Visual Basic event procedures to display the pictures. "
Then I add the event procedure as follow, where ImageControlName is Image13 and ImagePath is ImagePath and the path to the picture is the path for the first record in the list (F:\Converted Files\10301.JPG), then:
1.. If the field list isn't displayed, click Field List on the toolbar.
2.. From the field list, drag the field that contains the locations of the pictures to the form or report.
3.. In the toolbox, click the Image tool .
4.. On the form or report, click where you want to place the object.
5.. In the Insert Picture dialog box, specify the path to any picture, and then click OK. For example, you can type the path to the picture for the first record.
6.. Double-click the form selector or the report selector to open the property sheet.
7.. Click the Build button next to the OnCurrent property box, and then click Code Builder in the Choose Builder dialog box.
8.. Create the following event procedure. Substitute the name of the image control on your form or report for ImageControlName and the name of the control containing the path for ImagePath.
Private Sub Form_Current()On Error Resume NextMe![ImageControlName].Picture = Me![ImagePath]End Sub9.. On the File menu in the Visual Basic Editor, click Close and return to Microsoft Access.
10.. Click the control that is bound to the text field containing the location of the pictures, and then click Properties on the toolbar to open the property sheet..
11.. Click the Build button next to the AfterUpdate property box, click Code Builder in the Choose Builder dialog box, and create the following event procedure. Substitute the name of the image control on your form or report for ImageControlName and the name of the control containing the path for ImagePath.
Private Sub ImagePath_AfterUpdate()On Error Resume NextMe![ImageControlName].Picture = Me![ImagePath]End SubThis event procedure enables you to add or change a picture location in Form view.
12.. On the File menu in the Visual Basic Editor, click Close and return to Microsoft Access.
Please help.