Auto Populating A Text Object

Legacy Poster

• 24 de agosto de 2011 16:09

I am trying to design a new label for our stockroom. I have the label set up to ask for a part number, quantity and employee number. What I am having trouble with is getting it to auto populate the location. We have an excel file with part numbers and locations. I was hoping to be able to use the input for the part number to look at the excel file to find the corresponding location and print it on the label.

Hope that makes sense.

Thanks

0

• 

  Susan Chen

  Moderador

  ★ BarTender Hero ★

  • 25 de agosto de 2011 09:57
  Hi, Mishkakc:
  
  You can setup a query propmt to achieve what you want
  
  Step 1: Connect to the right database through Bartender
  Step 2: On the File-> Database Connection Setup-> Click on “Query” Tab
  Step 3: Setup a New Prompt
  Step 4: On the Query Prompts screen, put the Query name(For example: Part number query) and Print-time user Prompt(For example: Part Number) in
  
  Step 5: Test with File->Print Preview
  
  
  It will show the corresponding location in the database for the selected part number
  
  
  
  Thanks!

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 25 de agosto de 2011 15:40
  [quote name='Susan C - Seagull Support' timestamp='1314266230' post='446']
  Hi, Mishkakc:
  
  You can setup a query propmt to achieve what you want
  
  Step 1: Connect to the right database through Bartender
  Step 2: On the File-> Database Connection Setup-> Click on “Query” Tab
  Step 3: Setup a New Prompt
  Step 4: On the Query Prompts screen, put the Query name(For example: Part number query) and Print-time user Prompt(For example: Part Number) in
  
  Step 5: Test with File->Print Preview
  
  
  It will show the corresponding location in the database for the selected part number
  
  
  
  Thanks!
  [/quote]
  
  
  Hi Susan,
  
  Followed your instructions and it works, thanks.
  
  Just one more question though.
  
  Here are the steps I need to take to print my label.
  
  Click on Print - Print Wizard - Enter Data for Query window opens
  I now type in the part number and click Prompt
  Print Wizard - Prompt Dialog window opens
  I then type in the Part Number (again), Quantity, and Employee #
  Click Print and we get our label with the correct information.
  
  Is there a way to enter the part number only once?
  
  Thanks

  0

Iniciar sesión para dejar un comentario.