Skip to main content

Search

Search

Dropdown Menus And Printing

Comments

3 comments

  • Avatar
    Shotaro Ito
    Hi Rick,
    #1 - Have you layout 2 labels (2 columns) on a page? In that case, when you print from multiple database record, the user prompt shown 2 times then print occurs.

    #2 - From BarTender 9.3, you can use TAB character (vbTab) to separate display option and input value in a dropdown list.
    [code]
    strNames = strNames & rs("ColumnName").value & vbTab & rs("ColumnValue").value & vbCrLf
    [/code]
    In BarTender 8.0 - 9.2, display options and values are the same, when you select "C" then input value will be "C".
    0
  • Avatar
    Legacy Poster
    Hi Shotaro,

    #1 No, this is a single label.

    #2 The display option works fine, the result in your script is reversed. What I need is to select from the drop down an item in column one, and then bsed on that selection print one field with the content fom column 1 and another field showing the content from column 2.

    An example would be:
    1/ select part number from dropdown
    2/ on label print part number and description as two separate fields.
    0
  • Avatar
    Ian Cummings
    Moderator
    What you would ideally want is for the database query prompt to support a pull-down list of your live data for the user to select for running the query. Unfortunately, at this time it is still just a regular text input field so this is not possible.

    The use of the VB script in the user prompt form to select a record value in a field will only work in isolation to all other fields and so is not the answer either.

    Your best bet is to use the regular database connection with no query and use the "Select Records at print time" dialog for the user to select the records to print. See the below training video that cover this:

    http://www.seagullscientific.com/aspx/training-video-(reading-data-from-database).aspx

    http://www.seagullscientific.com/aspx/training-video-(selecting-records-from-a-database-at-print-time).aspx
    0

Please sign in to leave a comment.