Search Results - VBForums

Search:

Type: Posts; User: jggtz

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    7
    Views
    165

    Re: Urgent Help (easy but i am a newbie)

    The OP clearly posted

    Believe it or not, but in many places around the world they are still teaching VB6 and DAO in XP boxes
  2. Re: Run-Time Error '3021' No Current Record Found

    When using DAO .RecordCount will give you the result only after a .MoveLast method
  3. Replies
    7
    Views
    165

    Re: Urgent Help (easy but i am a newbie)

    You should investigate about:
    -How to Declare Numeric variables in VB6
    -How to accept data from the user in VB6
    -How to use arrays in VB6
    -How to calculate percentages and averages in VB6

    Then...
  4. Re: Run-Time Error '3021' No Current Record Found

    It looks like you are using DAO
    Then:
    1 Reference the DAO library
    2 Change the lines where you declare and where you open Recordset



    Option Explicit

    Public Sub modDeterminePrice()
  5. Re: Connecting VB6 with external Crystal report and database with password

    Well
    CR10 is better than CR8.5
    In design time is almost the same thing
    In CR10 You can open rpt files designed by CR8.5 and save them in version 10 or in version 8.5
    (...but once in version 10...
  6. Re: Connecting VB6 with external Crystal report and database with password

    Sorry pal, Crystal Reports 8.5 does not has the "ConnectionProperty" property that I used for provide the password to mdb at running time
    Try to get Crystal Reports Version 9 or 10 or 11
    Those are...
  7. Re: Connecting VB6 with external Crystal report and database with password

    Please, say the Crystal Reports' version
  8. Replies
    4
    Views
    170

    Re: OPOS Clearoutput problem

    The next is the code I use without problems


    'Print Ticket
    OPOSPrinter1.Open "TRSTA1U"
    OPOSPrinter1.CharacterSet = PtrCsAscii
    OPOSPrinter1.ClaimDevice 0
    ...
  9. Replies
    1
    Views
    406

    Re: Insert images in crystal reports 7

    The easiest way is to save those images in a db table and then retrieve them
  10. Re: problem in installing crystal report for visual studio 2008

    You downloaded the Service Pack, it means that it's expecting that you already had installed the CR2008
  11. Re: Put the subtotal at the end of records and not at the footer of last page

    Then place your total in the Report Footer section instead of Page Footer section
  12. Replies
    5
    Views
    450

    Re: Access Database Corruptions

    http://www.blueclaw-db.com/table_corrupted/repair_corrupted_database.htm
  13. Re: Crystal Report loading error Logon Failed.

    I mean pass the connection information to Crystal Reports to laod the rpt
  14. Re: Crystal Report loading error Logon Failed.

    You need to provide the connection information in the code using the ConnectionInfo property
  15. Re: Need your help calling a web service for school payments

    I use SOAP Toolkit 3.0 in all my projects that consume web-services

    Still available here ---> http://www.microsoft.com/en-us/download/details.aspx?id=10747

    Developing in XP, the projects work...
  16. Re: MSXML2.DOMDocument indent xml with spaces instead of tabs

    Then post the code where you are indenting the nodes
  17. Re: Load Report Failed - Crystal Reports

    Maybe parts of the next code & comments could help...
    VB.NET and CRYSTAL REPORTS
    HOW TO CALL A RPT WITH SUBREPORTS AND PARAMETERS
    -------------------------------------------------
    The following...
  18. Re: Database: Multiple Copy of Records and Paste to Another Database

    And what about a small conversion procedure?
    Open both mdb
    Read the old mdb
    Make the data conversion (change/add data)
    Write to new mdb
  19. Thread: Receipt

    by jggtz
    Replies
    3
    Views
    655

    Re: Receipt

    Some printers only accept their own api
    Others accept any reporting tool (Data Report, Crystal Reports, etc.)

    So, the best way is to select a brand that is compatible with your Windows version...
  20. Replies
    13
    Views
    933

    Re: Access password - VB6

    You should convert to a newer version first
    Create a new mdb file (version 2003 for example)
    Open it and import your tables from the older one
    Now you can set a password using Access
  21. Replies
    8
    Views
    343

    Re: where clause error

    The closing "

    Set rs = CN.Execute("SELECT * from Expenses WHERE ExpRemarks ='ABC'")
  22. Replies
    2
    Views
    293

    Re: CALCULATE number of years

    You could use the DateDiff function (if ms access)
    http://www.techonthenet.com/access/functions/date/datediff.php

    search for the difference in ms sql
  23. Re: Create new File in access 2003 using vb6

    Also, change / to \
  24. Re: Why there is too much space in my Crystal Report

    You should use another section instead of Page Footer section (for obvious reasons)
  25. Replies
    1
    Views
    292

    Problems to view threads & posts

    Hello!

    Since google, facebook, twitter,etc' links were added to bootom of threads/posts, I need to refresh IE several times to view the threads or sometimes toogle compatibility mode
    Do I need to...
  26. Re: How to write instructions on X (Exit) form

    You should use the QueryUnload event and ask for the Mode argument
  27. Re: Hi, everyone. I was wandering if there's away to get my source code back?

    Have you tried connecting the old disk to other laptop... maybe the disk is still good and the problem was in the motherboard
  28. Re: How to anchor a Label to a ListView?

    Try using the Left and Top properties of the Label related with the Top + Height and the Left properties of the ListView
  29. Replies
    15
    Views
    847

    Re: crystal report with acess 2003

    You didn't show the relevant code where you call the rpt
    I'm sure you are using the Crystal Reports OCX control and there are many reported problems when use 'sqlquery' and Access
    Te best solution...
  30. Re: Entering 13 decimals in a textbox and only write 5 to the table

    IMO the 'problem' is in the tool you use to view the table, maybe it use only 5 decimal places to show numeric fields
  31. Replies
    2
    Views
    303

    Re: Make chart like this

    Or you could use OWC
    Or you could automate Excel object
  32. Re: Need Ideas. Transactions/Temporary Tables? I have no idea

    You should insert the records when the teacher finish to uncheck the present students
  33. Replies
    15
    Views
    847

    Re: crystal report with acess 2003

    Then the problem is how you are passing the sqlquery to Crystal Reports
    Show some relevant code
  34. Replies
    12
    Views
    1,310

    Re: Total at the end of Report

    If it's not showing Sum operation then your field is not numeric
  35. Replies
    15
    Views
    847

    Re: crystal report with acess 2003

    You could use RecordSelectionFormula instead of sqlquery
  36. Replies
    12
    Views
    1,310

    Re: Total at the end of Report

    Study next example
    Report is in CR2008
    Database is in Access 2007 (but created as mdb)
  37. Replies
    12
    Views
    1,310

    Re: Total at the end of Report

    Did you follow the directions posted in post #4?
  38. Re: How do I set print job document name?

    http://support.microsoft.com/kb/154078
  39. Replies
    1
    Views
    551

    Re: Special Formating in RLDC report Field

    try just with : Format(Fields!ID.Value,"0000")
  40. Replies
    2
    Views
    1,824

    Re: Crystal Report very slow on first load

    Crystal reports takes time to load its engine the first time it is invoked
    You could try to open a dummy rpt when your application starts and catch the exception
    ...you could use another thread to...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.