Bartender Labelmaker and VB

[bhman79]

I'm trying to use Bartender label making software to make a packing list. My problem is that it pull records out of SQL and wants to print a sheet for every record. I want a list of all part numbers for an order to show on the page. What kind of script can i right that will look for a field, but then display a record other than the first??

Thanks

 

[Jon von der Heyden]

Do you know the name of the database tables and fields, specificaly those that would identify the part #'s for a particular order?

Can you see the code that is currenty being used to draw the data?

We could possible write up some SQL in a routine to pull the data. Alternatively we could use a database query but again you will need some background to the underlying database.

 

[Norie]

Doesn't the software you are using have an option(s) that could do this?

If it doesn't it doesn't seem that useful.

In Access if I wanted to create a report like this I would group by the record (ID?) and have all the part numbers associated with the order in the detail.

Then you could use various options to keep all the data for one order together on one page.