Search:

Type: Posts; User: newbie2

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    5
    Views
    267

    Re: unloading Active reports

    I'm so sorry
    I was just mistaken
    The codes are:

    Unload Activereport1
    Set ActiveReport1 = nothing
    these codes are not unloading the Activereport
  2. Replies
    5
    Views
    267

    unloading Active reports

    Hello
    I'm having big trouble to unload my active report from another form.

    Unload Activereport1
    Set ActiveReport1 = nothing
    these codes are not unloading the Activereport.
    Any suggestion?...
  3. Replies
    20
    Views
    790

    Re: Loop through text fields in Active reports

    I want to care about the quality of printing. The quality of printing differs a lot between the two methods.

    The controls on the form can be resized and formatted by the user at runtime

    It...
  4. Replies
    20
    Views
    790

    Re: Loop through text fields in Active reports

    sorry no success
  5. Replies
    20
    Views
    790

    Re: Loop through text fields in Active reports

    incorporated into the project

    in ActiveReport_Initialize event

    no other code in the report other than the one you have quoted.
    thank you
  6. Replies
    20
    Views
    790

    Re: Loop through text fields in Active reports

    yes that's it
  7. Replies
    20
    Views
    790

    Re: Loop through text fields in Active reports

    any idea please?
  8. Re: [RESOLVED] Howto add watermark to ActiveReport ?

    sorry it was badly positionned at the top corner so it was invisible
    thank you very much Olaf
  9. Replies
    20
    Views
    790

    Re: Loop through text fields in Active reports

    the fonts and position of the form textoxes are set at runtime.
  10. Re: Howto add watermark to ActiveReport ?

    Now I figured out that I have the possibility to add a watermark from the ActiveReport property..
    But it is still invisible.
  11. Re: Howto add watermark to ActiveReport ?

    Olaf
    thank you a lot
    Private Sub ActiveReport_ReportStart()

    Set ActiveReport1.Watermark = LoadPicture(App.Path & _
    "\WaterMark.jpg")
    End sub
    but when I preview the report the watermark is...
  12. Replies
    20
    Views
    790

    Re: Loop through text fields in Active reports

    wqweto
    thank you again
    your code is working
    but my problem is :


    With Field1
    .Top = Form1.Text1(1).Top
    .Left = Form1.Text1(1).Left
    .Width = Form1.Text1(1).Width
  13. Replies
    20
    Views
    790

    Re: Loop through text fields in Active reports

    this is the only method that isworking up to now.
    but it's a long process for 12 fields.

    I'm trying to set the position, size, fonts... of the report fields the same as the ones on the form...
  14. Replies
    20
    Views
    790

    Re: Loop through text fields in Active reports

    wqweto
    thank you very much
    unfortunately your code didn't work.
    Besides, I don't want to loop through all the textfields but 12 only.
    thank you
  15. Replies
    20
    Views
    790

    Loop through text fields in Active reports

    Hello everyone
    I'm sorry to poste here as "Reporting Forum" seemed abondoned.
    I need to loop through some text fields in the Activereport but I can't find a way.

    Dim t As Integer
    For t = 1 To...
  16. [RESOLVED] Howto add watermark to ActiveReport ?

    Hello all
    I am using activereports standard 2.0 and want to add watermark to my report.
    I can't find the control in the Toolbox.
    So please can anyone tell me how to do that?
    thanks
  17. Replies
    5
    Views
    378

    Re: Sqlite3 and crystal report

    Thank you Olaf
    I have been googling for 3 days looking for a working example but no luck.
    I tested the codes you suggested but I'm having this error:
    object variable or with block variable not...
  18. Replies
    5
    Views
    378

    Re: Sqlite3 and crystal report

    Thank you Olaf for your interest
    I tried

    Set CrystalReport1.DataSource = Rs.GetADORsFromContent
    I get error
    property not supported
    I'm testing with CrystalReport 8.5
    thank you
  19. Replies
    5
    Views
    378

    Sqlite3 and crystal report

    Hello everyone
    I'm using Vb 6 and Sqlite3 as database with VbRichclient 5 framework.
    So far I have been using DataReport succesfully for my reports.
    Now for one reason I want to use crystal report...
  20. Re: SQLite: delete all records from table that do not exist in another table

    Thank you very much
    solved
  21. Re: SQLite: delete all records from table that do not exist in another table

    yes sir
  22. [RESOLVED] SQLite: delete all records from table that do not exist in another table

    Hello VbForums
    With SQLite and RC5 how can I delete records from table1 that do not exist in table2?
    181696
    So the rows which are concered with deleetion are in yellow.
    This is what I'm trying to...
  23. Replies
    5
    Views
    621

    Re: Is it possible to do this sum?

    Thank you Vbforums
    thank you all of you for your interest
    Tons of thanks Olaf
    It worked
  24. Replies
    5
    Views
    621

    [RESOLVED] Is it possible to do this sum?

    Hello vbforums
    I have been trying to sum the values in yellow color but without succes.
    30 + 10 + 60


    select Sum(Remained) As Sumtotal from tbl1 group by item_id

    select Distinct item_id,...
  25. Replies
    7
    Views
    782

    Re: Need help with flexgrid

    Sam
    I'm so grateful to you
    Million thanks
    solved
  26. Replies
    7
    Views
    782

    Re: Need help with flexgrid

    No
    each item is appearing in its own row
  27. Replies
    7
    Views
    782

    Re: Need help with flexgrid

    thanks
    I have corrected my mistake
    I need to get the two items (aaa and bbb) in one sigle row instead of two seperate rows.
  28. Replies
    7
    Views
    782

    [RESOLVED] Need help with flexgrid

    Hello vbforums
    I have a table like this
    ID---------- Item
    1 ---------- aaa
    1-----------bbb

    Select* from Tbl where ID=1 group BY ID, Item"
    Do While Not Rs.EOF
    Text1.Text = Text1.Text & " " &...
  29. Replies
    35
    Views
    2,553

    Re: [RESOLVED] Need help with a querry

    I have modified Sam's updating codes.
    My updating is based on the auto increment field not on the item_id.

    Everything is allright now

    thank you all of you
  30. Replies
    35
    Views
    2,553

    Re: [RESOLVED] Need help with a querry

    of course I'm quite aware of all that.
    Thank you
  31. Replies
    35
    Views
    2,553

    Re: [RESOLVED] Need help with a querry

    SamOscarBrown
    You are a great gentelmen
    I was making a slight mistake in my update codes that's why it did not work properly.
    Million thanks sir.
    solved
  32. Replies
    35
    Views
    2,553

    Re: [RESOLVED] Need help with a querry

    SamOscarBrown
    Thank you again
    Unfortunately I'm having big trouble to convert your codes to SQlite
    I failed to update the appropriate rows.
    I think it has to do with the cursor location.
    ...
  33. Replies
    35
    Views
    2,553

    Re: Need help with a querry

    SamOscarBrown
    All the words of thanks do not fulfill what you really deserve.
    Million thanks
    that's exactly what I was looking for .
    May God Bless you
  34. Replies
    35
    Views
    2,553

    Re: Need help with a querry

    This is what I have been trying to do for a week but no success.


    StrSql = "Select max(Aut), remain, payment, Total_payment from Trans where paid= 0 And id = 1 Group by Item_Id"
    Set Rs =...
  35. Replies
    35
    Views
    2,553

    Re: Need help with a querry

    the new payment is distributed on the 1st item, 2nd item, 3rd item, 4 th item ..... until the new payment runs out.
    The new payment may expire with the 1st item if the debt related to the first item...
  36. Replies
    35
    Views
    2,553

    Re: Need help with a querry

    SamOscarBrown
    I put your message into google translate and if I understand you well, what you think is not applicable as real scenario, I can assure you that it is very possible and very common...
  37. Replies
    35
    Views
    2,553

    Re: Need help with a querry

    ChrisE
    thank you again and again
    I examined your sample and I figured out that it is dealing with each item seperately.
    What I'mlooking for is making a payment that deals with the three items in...
  38. Replies
    35
    Views
    2,553

    Re: Need help with a querry

    Good News.

    In fact my current program is dealing with each item separately. It looks like the screenshot submitted by Mr SamOscarBrown.
    ...
  39. Replies
    35
    Views
    2,553

    Re: Need help with a querry

    SamOscarBrown
    thank you for the screenshot

    what if the customer (Sam Brown) made a payment of of 100 without specifying the item.
    Is it possible for the program to distribute this sum on the...
  40. Replies
    35
    Views
    2,553

    Re: Need help with a querry

    ChrisE
    I thank you very much
    I 've just come home and it's very late now.
    Tomorrow I'll test your codes and let you know
    thanks a lot
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width