Consulting

Results 1 to 2 of 2

Thread: Printing from selection lis

  1. #1
    VBAX Newbie
    Joined
    Nov 2022
    Posts
    1
    Location

    Printing from selection lis

    Hi, The idea : I want to use a userform (MS access) where all the welders' names are listed with a selection box(checkboxes), by selecting a person, all the welder's certificates would then appear in the selection list next to it.
    Here I would then choose which certificate to print.
    The welding certificates are on the network per person in a pdf format. In the selection list, I would like to be able to see only the file name example : WPQ2522-ASME-FM5-141.pdf.
    I am a newbie in vba, so we can provide me with a code please, or get me started.
    thx
    Attached Images Attached Images

  2. #2
    the listbox should have 2 columns (having the Fullpath, hidden).
    Control Source of your listbox:

    select [wpqField], Mid([wpqField], InstrRev([wpqField], "\") + 1) As FileName From yourTable

    Other properties (in design view)
    Column Count: 2
    Column Widths: 0; 1"
    Bound Column: 1

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •