Search:

Type: Posts; User: Carmell

Page 1 of 3 1 2 3

Search: Search took 0.08 seconds.

  1. Replies
    1
    Views
    3,609

    Re: Crystal Report Amortization Schedule

    I create a formula to my crystalreport and added to my details how ever it only produce one line of details which is the end date of the loan


    local numbervar i ;
    local stringvar output;

    for...
  2. Replies
    1
    Views
    3,609

    Crystal Report Amortization Schedule

    I am actually trying to create a report that shows the Amortization Schedule using Crystal Report. I am curious if its possible to do this with this kind of format.

    I have an input coming from...
  3. Re: Error 20515 A date is required here.

    Thank you guys for your help.

    I solved the problem using Lavolpe solution.

    :)
  4. [RESOLVED] Error 20515 A date is required here.

    160495

    I'm getting this error when generating report.

    The error falls in this line.


    .SelectionFormula = "{View_MasterInfo.EmployeeType} <> 'RANK & FILE' and...
  5. Replies
    12
    Views
    19,945

    Date Format VB6

    The value of my dates in my database is ="MMDDYYYY"
    I insert it using this code:


    replace(convert(varchar(10), date, 101), '/', '')

    it returns like this output

    06072018
  6. Replies
    1
    Views
    2,645

    Group By Hour (VB6)

    How can I group by transactions like this
    '0:01AM -1:00 AM' and it will interpret as 01
    '1:01AM-2:00 AM' as 02
    '10:01 PM-11:00 PM' as 23 and so on..


    because I need to create a txtfile with...
  7. Re: The database file has changed. Proceeding to fix up the report!

    This is my problem for a year now hehe
  8. Sql 2005- find the difference between rows

    I dunno if it its possible to generate a table that find the difference of one row to another.

    Just like this:

    157461

    it is group by by ID and sorted by date..
    Let's assume that the...
  9. Replies
    0
    Views
    2,307

    A date-time is required here VB6 CR8.5

    What do you think is wrong in my code?

    I have this error, see the pic below.
    157457


    Set rs = New ADODB.Recordset
    rs.CursorLocation = adUseClient
    strsql = "SELECT * FROM...
  10. Replies
    2
    Views
    2,764

    VS 2013 Connection String

    Hi I am starting to learn VB.NET and I am little bit confused right now.
    I want to create a connection string dynamically at run time.

    I made a module for it and I want to call it everytime I...
  11. Replies
    0
    Views
    3,257

    Sum of sum of groups

    WHY IT RETURNS 0 WHEN I CREATE A FORMULA FIELD IN CRYSTAL REPORT?

    CODE:


    if {Consumption_Branch;1.CLASSIFICATION}="CHILLED" then
    if {Consumption_Branch;1.Vatable}=True then
    global numbervar...
  12. Replies
    3
    Views
    759

    Re: Stock ledger vba

    I'm actually looking for an idea of how to do that. The table is located at SQL SERVER 2005 and I'm working with VB6. I want to create a button that allow to insert those data in one table including...
  13. Replies
    3
    Views
    759

    Stock ledger vba

    Hi I want to create a stock ledger from my given tables.

    tbl_ItemInventory


    CODE
    DESCRIPTION
    BEGINNING QTY
    UOM
    DATE
  14. Replies
    8
    Views
    4,904

    Re: Slow

    If stogrid.Row >= 1 And stogrid.Col = 4 And stogrid.TextMatrix(stogrid.Row, 4) <> "" Then
    For i = 1 To stogrid.Rows - 1
    If Trim(checkinventory(stogrid, issuedby)) <> Empty Then
    itm...
  15. Replies
    8
    Views
    4,904

    Re: Slow

    actually i dont know what WINE is hehhehe
  16. Replies
    8
    Views
    4,904

    Re: Slow

    Hi , the database stored in a local computer only.
  17. Replies
    8
    Views
    4,904

    Re: Slow

    Oh I'm sorry ,
    here's the code for that function


    Function SearchUOM(strS As String, UOMStr As String, Row As Long)

    Call con

    If rs.State = 1 Then rs.Close
    rs.CursorLocation = adUseClient
  18. Replies
    8
    Views
    4,904

    [RESOLVED] Slow

    I made a program that the user can enter an item per row, however if the row is already 15 rows above the system is already hanging/lagging/freezing the user needs to wait a minute to process the...
  19. Replies
    3
    Views
    729

    Generate .txt file

    Can someone please help me how to generate a text file from sql table?

    The text file will save into a certain location?

    I will have an export button that will trigger the generation.

    I am...
  20. Replies
    4
    Views
    1,046

    Re: Loop

    Thanks to all of you for enlightening me.

    here's my final working code now, based to your suggestions.


    Do Until rs.EOF = True
    If Not rs.Fields(6).Value = 0 Then
    rrgrid.AddItem "" & vbTab...
  21. Replies
    4
    Views
    1,046

    [RESOLVED] Loop

    Please help me.
    I'm having trouble using loops.

    This is my current code:

    While rs.EOF = False

    rrgrid.AddItem "" & vbTab & rs.Fields(0).Value & vbTab & _
    rs.Fields(1).Value & vbTab & _...
  22. Replies
    4
    Views
    798

    Re: Temporary Table

    thank you for your help :)
  23. Replies
    4
    Views
    798

    Temporary Table

    Hi I need help,

    Is it possible to combine tables using temporary table?

    For example I have 2 tables.

    tbl_NewHire
    Name
    Birthday
    DateHired
  24. Replies
    3
    Views
    4,729

    Re: Invalid parameter name

    thank you for your help
  25. Crystal Reports group footer appearing on following page

    Hi.

    I've got a report which has a group footer.

    The footer sometimes appears by itself on a page. The previous page is full and so the footer (just some totals) appears on the following page.
    ...
  26. Replies
    3
    Views
    4,729

    Invalid parameter name

    Good Day!

    I need your help guys, I'm having a problem calling my report using parameters.
    I got this error.

    148129


    I'm trying to print a report that filters the date selected by the user.
  27. Re: The database file has changed. Proceeding to fix up the report!

    if I'm going to recreate my reports same thing happened. the error still occurs.
  28. Re: The database file has changed. Proceeding to fix up the report!

    it's alter because I click the modify option to view the codes for stored proc

    by the way i tried to recreate the report however the error still there
  29. The database file has changed. Proceeding to fix up the report!

    Everytime I print the report. There is always a pop-up error of "The database file <file name> has changed. Proceeding to fix up the report!" then click OK.
    This is so annoying. I understand that...
  30. Thread: Error 20515

    by Carmell
    Replies
    4
    Views
    1,237

    Error 20515

    142449

    i encounter that error only on my computer, i tried to install it on other computer but it works fine...


    help pls...:confused:
  31. Replies
    2
    Views
    804

    Consolidate data

    Hi, I need your idea guys regarding on my problem. I have a table for example name fruits, the data on it is already fixed. The problem is it consist of 900000+ rows so it takes time for the data to...
  32. Replies
    6
    Views
    4,604

    Re: Flexgrid get Selected Value

    it triggers also the same error..
    on first attempt it works,
    on second not..

    on debug mode the .selrow is equal to -1?
  33. Replies
    6
    Views
    4,604

    Re: Flexgrid get Selected Value

    I'm very very very confused I didn't make any alteration, but it works sometime but very seldom .. :confused:
  34. Replies
    6
    Views
    4,604

    Re: Flexgrid get Selected Value

    sometime it works, sometime not :confused:141199
    it works after many tries then it will not work again and encounters error
  35. Replies
    6
    Views
    4,604

    Flexgrid get Selected Value

    141197
    i have a grid what i want is ,every time i clicked the cell in column 1 in any row the value will show in textbox.

    I already try it and here is my existing code (not working):

    Private...
  36. Thread: Statusbar

    by Carmell
    Replies
    12
    Views
    2,025

    Re: Statusbar

    it disapper when I click anything in menu..
  37. Replies
    4
    Views
    945

    Re: File Transfer Application

    Me, myself confused also :confused:
    I need someone who can guide me or correct me.
    It can be FTP as long as it can transfer files.
    But I don't know how to do it, or where to start.
    The thing that...
  38. Replies
    4
    Views
    945

    File Transfer Application

    Hi, I'm wondering how can I create a simple file transfer application (online based). For example : I will send a .txt file and can receive also? Is that possible? I still dont have idea :cry:
    ...
  39. Thread: Statusbar

    by Carmell
    Replies
    12
    Views
    2,025

    Re: Statusbar

    help .......... :(
  40. Replies
    5
    Views
    1,492

    Re: Flexgrid and Recordcount

    Thanks Westconn1 and Arnoutdv :wave:
Results 1 to 40 of 106
Page 1 of 3 1 2 3



Click Here to Expand Forum to Full Width