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 Chriss Miller 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: *

  1. crisedefoie

    SQL MSDE Engine doesn't want to start

    Hi everybody, One of my customers has this problem. Last night, electricity shot down and when their server restart, the SQL Server (MSDE) engine didn't restart ! We try manuelly ... nothing ! We try to reboot the server ... nothing ! What ever we try, the SQL Engine doesn't start ! Has...
  2. crisedefoie

    Detail printed over header

    Good morning every one, We work on a VB.Net application with Crystal 10. We have a report with 4 sort groups without 'Repeat header on every pages'. But for one of our clients, the header of a group is repeated on the second page AND THE DETAILS ARE PRINTED OVER IT ! We tried to print this...
  3. crisedefoie

    "Unknown Query Engine Error"

    Hi everybody, I have a application in VB6 using SQL Server Databases which I connect via ADO; Crystal Report 10 is my report generator. On each of my customers, the application works fine et reports either. For one of them, the application works fine BUT when I want to print any report (even...
  4. crisedefoie

    Regional settings VIA Vb6

    Hi, I'd like to know how to get the regionals settings of a computer via vb6. (specificaly for Date) I have many users who use different settings and I need to know what theirs to show the right format on the screen. Thanks for help.
  5. crisedefoie

    Force Scroll in a MsFlexGrid

    I have a MSFlexGrid in a VB6 form that I fill with many records (and I can't see all records without scrolling). I want to force the scrollbar to the bottom of the grid because the user of my application want to be able to see the last record. But I don't see how :-( I hope I was clear...
  6. crisedefoie

    MDAC and XP Family

    Good morning everyone, I installed a vb6 application using SQL Server databases and ADO. When I want to start the application, an error message pops up : The ~ method of the ~ object failed. We found that it's when it wants first open the database. I tried to installed MDAC 2.8 but it told...
  7. crisedefoie

    MDAC problem

    Good morning everyone, I installed a vb6 application using SQL Server databases and ADO. When I want to start the application, an error message pops up : The ~ method of the ~ object failed. We found that it's when it wants first open the database. I tried to installed MDAC 2.8 but it told...
  8. crisedefoie

    Parameters are missing (Crystal 10 & VB6)

    HI I have an vb6 application using crystal 10 reports. When I want to send parameters to my reports, it doesn't work. I see the parameter prompt windows. However, my debugger tells me that the value was good. These is a part of my code : Select Case pParamDef.ValueType Case 9 'boolean...
  9. crisedefoie

    RecordCount = -1 (ADO; SQL SERVER)

    Hello! I have a reccurent problem : I have a program in VB6 using SQL Server Database. When I try to open a recordset and to know the recordcount, it always return -1!!!! I saw in other topics many advices about cursor type etc.. but ... it doesn't work neither. There is a piece of my code...
  10. crisedefoie

    Duplicate the report on the same sheet

    Hi, I have to print the same report on the same sheet (two parts invoice separated by a dotted line). Each part has its own header, detail and footer. I first put on the part 'one' in a sub report in the header and the second in the detail section. But I have to change page at the same...
  11. crisedefoie

    Connecting to MySQL database via ADO (VB6)

    It's the first time I work with MySQL. I tried to connect my VB6 application to a little database via ADO connection. Here is my connection code : DBConn.Open ("Provider=MySqlProv.3.0;" & "Data Source=" & MyDataBase;") But I always met the same error message on this...
  12. crisedefoie

    Decimal number in a selection formula

    Good morning! I have a very bizarre problem in Crystal 8.5. I want to send a selection formula that looks like : {table.BoardWidth} = 2.8 BUT it doesn't work !!!! It works only with integer or '.5' decimals (ex : 1.5, 2.5 etc...) it doesn't work even with 2.51! I tried to put...
  13. crisedefoie

    Hello, I wonder if it's possible

    Hello, I wonder if it's possible to pass the selection formula of a main report to its subreports. By exemple I want to print a list of invoices which have a subreport showing products costs and quantities summaries. The users of this report may choose custumers, products, dates or whatever...
  14. crisedefoie

    accessing a crystal report via MSDE (log on infos)

    Hello, First I apologize for my english. I hope I'll be clear anyway. I have to call a crystal report trough a MSDE connection. When I call the same report with SQL Server my connection code works fine but I really don't know how to do with MSDE connection. I trie many different ways but they...
  15. crisedefoie

    accessing a crystal report via MSDE (log on infos)

    Hello, First I apologize for my english. I hope I'll be clear anyway. I have to call a crystal report trough a MSDE connection. When I call the same report with SQL Server my connection code works fine but I really don't know how to do with MSDE connection. I tried many different ways but they...
  16. crisedefoie

    Connecting a crystal report to MSDE

    Hello, First I apologize for my english. I hope I'll be clear anyway. I have to call a crystal report trough a MSDE connection. When I call the same report with SQL Server my connection code works fine but I really don't know how to do with MSDE connection. I trie many different ways but they...
  17. crisedefoie

    Changing XML file datasource location in VB.NET

    HI I created a Crystal Report which datasource is a XML file. This file will be created and destroyed so I have to specify the location of the XML filewith each treatment. There is my code : lTblReport = Report.Database.Tables For i = 0 To lTblReport.Count - 1...
  18. crisedefoie

    Photo Background in a Crystal Report

    Hi, I want to put a photo in background in a Crystal Report(v9). As I don't know how many records it will be printed, how can I set my photo to fit in the page? Thanks!

Part and Inventory Search

Back
Top