Member Avatar for tekrum

Does anyone knows how to make datasource location of a report fixed like in VB you can use app.path. Can anyone suggest how to do it?

Thanks in advance!

  • 3 Contributors
  • 4 Replies
  • 81 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by freshface001
Member Avatar for QVeen72

Hi,

From VB6, just before Viewing the report, Set the DB location for each tables used in the report..
What is your Database..? Access/Oracle/SQL...?

Regards
Veena

Member Avatar for tekrum

I have an access database. How do I do that?

Member Avatar for QVeen72

Hi,

Before Viewing the report , set DB location for all the Tables used in the report:

Dim tt As CRAXDDRT.DatabaseTable
For Each tt In m_Report.Database.Tables
 tt.Location = "C:\NewDB.mdb"
Next

Regards
Veena

Member Avatar for freshface001

in visual basic 6, using Data control for accessing the access database. give the data base name(*.mdb) in "DataBaseName" property of data control.and select the table in the "RecordSource" property of data control. then place no_of text fields or lables in the same form(appear Data control) for viewing the values of the access database data by selecting datasource as data controll name and select field name in the "DataFiled" property of text box or label.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.