How to print photo IDs in Access

[Laramie]

Hi everybody,

Recently I received a task, to students in the certificate information and photo printing to a 3 +1 skill certificate template, and also to spread to the Internet for the employing unit inquiries. The original data in two parts, in part, with student name, ID number, certification programs, certificate numbers and other information in Excel tables; the other part is classified by certification programs, student names in the name of the photo, pictures with a size of 90 × 120 pixels, image formats are JPG. Therefore decided to use Access to develop urgently. Anybody know how to print photo IDs in Access.

[Raine]

First you need a creating databases and tables. Follow the steps:
# Open the Microsoft Office Access, to create an empty database, and photos of the classification in the same directory under a folder.
# Use "File > Get External Data > Import" feature in Excel sheet directly into Access, save for the "Certificate Information" table.
Check and reply.

[Sam.D]

Also you need to create Certificate Information Report for this. Create a "Certificate Information" report, first insert an "image" control, set its Picture property for the certificate template image, set the size of the size of the certificate template, set its visibility in the negative, it is a good certificate information of the layout, and will not be printed; and then turn into the field you want to print a list, set a good font and font size; and finally re-insert an "image" control, placed in the local photo printing, set the size of the size of the photo, set its name to "abc".

[ZeDaX]

You can also need a to turn the menu bar click on "View > Code" command, enter the VBA coding window, write the following code:

Private Sub main _Format (Cancel As Integer, FormatCount123 As Integer)
Dim imgpath123 As String
imgpath123 = Application.CurrentProject.Path + "\" + certification program. text + "\" + name. Text + ". jpg"
If Dir (imgpath123) = "" Then imgpath123 = Application.CurrentProject.Path + "\ blankimg.bmp"
stug.Picture = imgpath123
End Sub

[ThoMas321]

You also need to creating print preview panel form access. Follow the steps:

1. Create a "Print Preview Panel", followed by placing a text box for the query, and named "inputname"; two command button "preview", "Close."
2. Turn the menu bar click on "View > Code" command, enter the VBA coding window, write the following code:

Public stuname123 As String 
Sub PrintReports123 (PrintMode As Integer)
Dim strWhereCategory123 As String
If stuname123 <> Empty Then
strWhereCategory123 = "name = '" + stuname + "'"
End If
DoCmd123.OpenReport "Certificate Information", PrintMode,, strWhereCategory123
DoCmd123.Close acForm, "Print Preview Panel"
End Sub
Private Sub inputname_Change123 ()
stuname123 = inputname123.Text
End Sub
Private Sub preview _Click123 ()
PrintReports acPreview123
End Sub
Private Sub off _Click123 ()
DoCmd123.Close
End Sub

[Macarenas]

You also need to set the main switch panel is displayed when startup. In turn click on the menu bar "Tools > start" command, open the "Startup" settings window, in the "Display Form > page" option, select the main switch panel, and abolish the "Display Database Window", so that the next time you open the Access database , it will automatically display the Main Switchboard form. Readers may also need to decide according to their own whether to cancel the menu bar and shortcut menu bar that, if the later have to display them, you can open the Access database, hold down the Shift key.Now the skills certificate printing system are complete. Best of luck.