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!

Register Log in
  • Congratulations strongm 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. lpedde

    Upgrade from SQL 6.5 to SQL 2k

    We have been running SQL 6.5, VB6 and Crystal Reports 7 on an NT4 server. We just purchased a Win 2003 server. I understand that I have to upgrade to SQL 2000 with SP3. Does any one know if VB6 and Crystal Reports 7 play nicely with SQL 2000? Are there any major issues that I need to be aware...
  2. lpedde

    Sending Crystal Report to a file from VB

    I am using VB 6 and Crystal 7 with SQL Server 6.5. I have the following code in a VB module to prepare a crystal report to write to a file. I need to set these options on the fly because the user can also send the report to the printer. The first three lines seem to be setting the...
  3. lpedde

    Printing Crystal Report straight to printer w/ no user input

    DOH! That was it, thanks. Linda
  4. lpedde

    Printing Crystal Report straight to printer w/ no user input

    I am using Crystal Reports 7, Visual Basic 6, and OCX integration. How do I print a report to the printer without having that dialog come up waiting for the printer button to be used? I have tried report.Action = 1 and report.PrintReport and both wait for the user to "print" the...
  5. lpedde

    Returning a value from a VB Form

    That worked great! Thanks
  6. lpedde

    Returning a value from a VB Form

    This is probably very basic but I am having to teach myself VB after a background in Paradox for DOS. :) I have a VB form which allows the user to request labels for a given zip code range. From this form I call another form which prompts the user to put labels in the printer before building...
  7. lpedde

    List multiple records & Summarize those records

    I have a SQL 6.5 stored procedure that writes to a table records that contain Chapter Number Member Name Payment Type (New1yr, New2yr, Renew1yr, etc) Rebate based on Payment Type The same stored procedure writes to another table a single record for each chapter with chapter totals...
  8. lpedde

    Using Exec to update table field values

    Sorry tlbroadbent...you were right. When I first put the "Update..." into a @str variable then exec(@str) it works! Thanks.
  9. lpedde

    Using Exec to update table field values

    Actually, both the convert and str functions cause a syntax error. The original code produces an error: incorrect syntax near '0044' unclosed quote before the character string ' '. From isolating the string in a select statement I believe the error involves the @rebate and not the @header part...
  10. lpedde

    Using Exec to update table field values

    The following code is in a stored procedure in SQL 6.5. The table cnt1056 has the following structure. chapter varchar(4), New1yr int, New1yrR money, New2yr int, New2yrR money, etc... I am trying to update the count and monetary rebate amount based on the type of membership that...

Part and Inventory Search

Back
Top