Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: RohanP
  • Content: Threads
  • Order by date
  1. RohanP

    Opening Files From VB

    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...
  2. RohanP

    Minimum Value in Group 2 from Aggregated result in Group 3

    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...
  3. RohanP

    Suppress Duplicate Sub Report

    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 ______________________________ -...
  4. RohanP

    CR Distribution

    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? ______________________________...
  5. RohanP

    Database Dlls

    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...
  6. RohanP

    Report Location to Sql Server

    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...
  7. RohanP

    Limit records in the detail section using RDC

    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 ______________________________ -...
  8. RohanP

    In this example of Procedure SetTab

    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...
  9. RohanP

    Stored Procedures or what?

    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...
  10. RohanP

    Sql Server 7 on Client's PC?

    I have made an DBapplication using VB6 & Sql Server 7 next I have to install it on clients machine... is it necessary to have Sql Server 7 installed on the clients PC?? If not which supporting files I have to include while installation ? Help will be appriciated...
  11. RohanP

    Creating a Mirror Image of Database

    For handling huge data every year, we r creating diffrerent databases for each year (DB0203) on New Financial Year which will reside on the same server. I wanted to know abt Sql Syntax or some other method which i could handle from VB, which will Copy the Table structres & Relationships of...
  12. RohanP

    Multiline property of TextBox

    Is there a API which will set the VBTextBox's Multiline Property at run-time?? ______________________________ - Regards Rohan (India,Mumbai)
  13. RohanP

    Automation Error .. Crystal OCX Problem

    Hello There, I am using crystl32.ocx. Sometimes before or after displaying the report. An Error flashes & both crystal report window & Exe terminates.. The Error is :- Run-time error '-2147417848 (80010108)': Automation Error. I dont find any problrm in my VB Code or the reportitself. The...
  14. RohanP

    Crystl32.ocx registration problem

    Hi There, I have made a software using vb/sql server/crystal reports 7. Reports r made in Crystal Reports Designer, to display report frm VB I am using Crystl32.ocx component. The problem is crystl32.ocx is unable to register. Whenever I try to register it executing - REGSVR32...
  15. RohanP

    Crystl32.ocx registration problem

    Hi There, I have made a software using vb/sql server/crystal reports 7. Reports r made in Crystal Reports Designer, to display report frm VB I am using Crystl32.ocx component. The problem is crystl32.ocx is unable to register. Whenever I try to register it executing - REGSVR32...
  16. RohanP

    Crystl32.ocx registration problem

    Hi There, I have made a software using vb/sql server/crystal reports 7. Reports r made in Crystal Reports Designer, to display report frm VB I am using Crystl32.ocx component. The problem is crystl32.ocx is unable to register. Whenever I try to register it executing - REGSVR32...
  17. RohanP

    Tips on Project Documentation

    I have made a Exports Management System in Visual Basic 6 And Sql Server 7 as Back End. The project is ready & already implimented. Now I have to document the project, i.e. making a user manual, Software Documentation. I have very less idea about making documentations (never made any) & there is...
  18. RohanP

    Tips on Project Documentation

    I have made a Exports Management System in Visual Basic 6 And Sql Server 7 as Back End. The project is ready & already implimented. Now I have to document the project, i.e. making a user manual, Software Documentation. I have very less idea about making documentations (never made any) & there is...
  19. RohanP

    Development of Fax Software from VB

    Hello There, I want to try making a Software which send fax thru Vb Application. But, I dont have any idea abt it. Which Object to use?? or to use APIs?? Pls provide me information if possible. ______________________________ - Regards Rohan (India,Mumbai)
  20. RohanP

    Error:20599 Cannot Open Sql Server

    Hi There, I had made a Exports Application in VB6,Sql Server7 & Crystal Reports 7 which was working fine but, I had to Format the Data Server for Virus reason & Configure Sql Server. Configuration is perfectly done & Software is working fine but while accessing the reports on client machine...

Part and Inventory Search

Back
Top