VBA 里面做准考证 相片名字是考生考号,当主体加载时,照片自动对应填充到图片框,代码如下:Private Sub 主体_Format(Cancel As Integer, FormatCount As Integer)
Dim imgpath As String
imgpath = Application.CurrentProject.Path + "\照片\" + kh.Text + ".jpg"
If Dir(imgpath) = "" Then imgpath = Application.CurrentProject.Path + "\noimg.jpg"
stuimg.Picture = imgpath
End Sub在VB里用DataReport做准考证要如何实现这个功能!
Dim imgpath As String
imgpath = Application.CurrentProject.Path + "\照片\" + kh.Text + ".jpg"
If Dir(imgpath) = "" Then imgpath = Application.CurrentProject.Path + "\noimg.jpg"
stuimg.Picture = imgpath
End Sub在VB里用DataReport做准考证要如何实现这个功能!
做准考证的时候: 相片不用一个一个给出路径,根据考号,如果相片名字跟考号一样,就自动加载到图片框中。(图片不需要在数据库中存放)
imgpath = App.Path + "\照片\" + kh.Text + ".jpg"
Set Picture1.Picture = LoadPicture(imgpath)
k = DataControl1.Recordset.Fields("kh").Value
Set pic.Picture = LoadPicture(App.Path & "\" & k & ".jpg")考号(kh)、考生相片名字是: 考号.JEPG 每一个证只能显示第一个人的相处,不会根据考号自动选择,请高人帮忙看看!!!
Dim k As String ActiveReport1.Field1.Text = DAODataControl1.Recordset.Fields("kh").Value
If ActiveReport1.Field1.Text = DAODataControl1.Recordset.Fields("kh").Value Then
k = DAODataControl1.Recordset.Fields("pho").Value Set pic.Picture = LoadPicture(App.Path & "\" & k & ".jpg")
End If
End Sub
自己解决了!!!