Data environments and Reports

[aldinator]

i have two problems / questions for the fine people of vbworld.com

1) i can't use data environment: "ActiveX cannot create object"
- help!!

2) i am creating a report in vb (not access if possible) and it's only purpose is for printing and i need to know:
i have two fields (fname and lname) and i want to join them for the textbox so its one field (but not change it in the database)

thanks a lot for any help

[aldinator]

SQL could help -- i'm just throwing ideas to spark you minds (i'd try the SQL myself but i don't know SQL )

[pauleliott]

check your references for the first problem


the second in the data envir when you get it working join the fields there...should solve your problem

I work with sql if you need questions answered ...if i can

[mohdk_bh]

first pro.. i think some versions you have are old.. in os i think


if using SQL to solve it it would be easy:
also u can use Sql in dataevironment.. in datasource section

Select fname+lname as fillName from people