Search results for query: *

Hi There, I have created an application which show list of files in a listbox eg:- ListBox Values D:\File1.doc D:\File1.xls D:\File1.mdb D:\File1.pdf I want my app to open selected file on click of a button. if user select value 1 then file1.doc should open with its associated program i.e...

Hey Dude, Thankz a thousand times. I had to use simple logic rather that useing next & prev functions. it worked out fine i just had to use sub-report to get the result in the header. Thankz Again ______________________________ - Regards Rohan (India,Mumbai)

Hi There, I have a 3 groups in a report. Group 3 has a Formula (Formula1) returning average of a field based on group 2. eg:- Average({Table.Field},Group3) I want to display the minimum Value returned by Formula1 in Group2's Header. How can I do that? if i write Minimum(Formula1,Group2) it...

Hello Guys I hv a sub report in the detail section of the main report. if there is a duplicate subreport record in the same group the sub report should be invisible. I tried checking the Suppress If Duplicate option of sub report but it dosent work. Pls Help ______________________________ -...

Hi There, I have made a Client/Server App in VB6 & used CR8 for Reporting. Package is installed on 3 client machine whenever there is some change in rpt files I have to replace rpts on all the client machines. Is there a better way of distributing CR Rpt Files? ______________________________...

I am using RDC to display reports frm vb6 I am getting an error on client's PC that Database DLL cannot be found & client is not able to view reports. I have used pdsoledb.dll in my rpt files, as per information I got the dll should be present even on the client machine but I am not able to...

Server Name - Rohan username - sa dbname - exports1 ______________________________ - Regards Rohan (India,Mumbai)

I unchecked the Save Data with Report option but still the report is not refereshing with specified Database. :( is it so difficult to get this solution? ______________________________ - Regards Rohan (India,Mumbai)

I tried this out MsgBox crxDatabaseTable.TestConnectivity) & " " & crxDatabaseTable.Name Every Table is returning True Value I asume that means connectivity is successful. But database is still not changing. But If I pass SqlString to the report object it is working fine. Giving...

I Tried the below code but was not opening Exports1 DB but showing Exports DB's data :(. But When I added this line of code (Report.SQLQueryString = "Select * From Customer") as there is only 1 table in the dummy report, Between code Report.DiscardSavedData and...

I have tried this Report.Database.LogOnServer "pdssql.dll", "Rohan", "Exports1", "sa" 'Use a For Each loop to change the location of each 'DatabaseTable in the Reports DatabaseTable Collection For Each crxDatabaseTable In Report.Database.Tables...

In this example the location property of the DatabaseTable Object for each table in Report is set to MDB File. ****************** For Each crxDatabaseTable In Report.Database.Tables crxDatabaseTable.Location = App.Path & "\xtreme. mdb" Next crxDatabaseTable ****************** I...

How to limit records in the detail section? eg:- Suppose DetailSectionRecords is a property Report.DetailSectionRecords= 10 Only 10 records in detail section per page will be printed. what is the code for doing the same?? pls help its very urgent ______________________________ -...

In this example of Procedure SetTableLocation For the DatabaseTable, Location is set to the MDB File i.e. the access DB, but i want to set the location to Sql Server 7 with the Login Name - sa & Blank Password? object.SetTableLocation "xtreme.mdb", "Customer", "&quot...

Thankzzz all u guys for ur help. :) ______________________________ - Regards Rohan (India,Mumbai)

Giving same error... Invalid Object Name 'db1.dbo.inserted' Even after I changed the Trigger as mentioned below... create trigger update_agentmaster on agentmaster for update as update db2.dbo.agentmaster set [name] = i.[name], address = i.address, tdsrate = i.tdsrate, comm = i.comm from...

Insert & Delete Triggers r working fine but the Update Trigger is giving an error ------------------------------ Invalid Object Name 'db2.dbo.inserted' ------------------------------ Because of this error previously i created inserted & deleted tables ;o), but now I have deleted both the...

hi osjhonm I created 2 tables inserted & deleted in db1, after making some changes in ur statements triggers were created successfully, but they r not doing the job they have to. these r the minor changed statements - create trigger insert_agentmaster on agentmaster for insert as insert into...

Hi there, There are 2 Databases is made in Sql Server 7 residing on same server. Both r mirror image of each other. having common tables. One of the Table is AgentMaster residing on both the Databases. If a row in DB1's AgentMaster is updated, suppose the address of Agent is changed, the...

If a Project is made in VB6 - MSAccess.. it is not necessary to install MS-Access on clients machine. Some of the supporting files fetch data from Access DB the MDB file.. In the same way in case of single user application made in VB & Sql Server, is it necessary to install Sql-Server on clients...