Going crazy with xls file printing
So i conected a xls spreasheet to a label and wanted to choose from a dropdown list item names (one of the columns) and to print several other related fields on the same excel line. I changed to mdb source data but still cant achieve this behaviour.
0
-
You will need to add a Data Entry box onto a form to achieve this.
- Use the Database Connection Setup to link to the spreadsheet and add in a Filter to provide the lookup into the column you need to search.
- Add the fields as required to the label linked to the other database fields.
- Click on Form 1 tab at the bottom to access the Data Entry Form and then add a Drodown List item from the Data Entry Control button options.
- Add this to the form and then go into the properties of the box and from the Linked Data Source select your filter configured above from the column on the right.
- Then click on the List Items and change the Source to Database and use the Database Setup to create the connection for the Dropdown list only (it does not use the main Database Setup that the rest of the label uses).
Hopefully that will get you up and running
0 -
Thank you for your complete explination but it doesnt show up Source: Database in List Items, just "Incorporated Data" and "Visual Basic script"... Excel is added as Data Source and have linked fields on layout..
0 -
What version and edition are you using please (ie Professional 2019 etc)?
0
Please sign in to leave a comment.
Comments
3 comments