Create MSAccess Report in VB6

[Arno2001]

Hi there,

I am stuck on creating a Access report in VB6.
It is as follows: I am creating a student-teacher program where students can practice a foreign language. Now I want to gather information about the tasks students did (name, class, date, time spend, excercise# etc). These data is stored in an Access Database.

The problem: I want to create a report in Access where these data is stored and (later) printed.

When you try helping me: SUCCESS

Who can help me??

[Spooked]

Project -> Add Data Report

[Arno2001]

Yes Spooked, this it is!
But, how can I programmatically set the name of the DataEnvironment, the DEConnection and the DECommands?

What if in the database are 5 tables?

Can you please add some code. This works very well with me.


Thanx

[Spooked]

Progect -> Add Data Environment.

Set the properties of Connection1 to access your database..

[Arno2001]

Yes, I know,

but how can I change the properties of connection1, the props of the dataEnvironment and the props of the DECommands softwarematically. I can make it work for one table, but I have several tables in the database, I also want the user to have the ability to place the database where he wants.

....