dcsimg

Search:

Type: Posts; User: sacramento

Page 1 of 13 1 2 3 4

Search: Search took 1.39 seconds.

  1. Replies
    12
    Views
    372

    Re: Query and date

    Fantastic si_the_geek....work perfectlly.

    From today I will use parameters in my querys.

    Thanks a lot for the help
  2. Replies
    12
    Views
    372

    Re: Query and date

    Thanks for your help...

    I had replace the line for your code, and i have this error:

    168211
  3. Replies
    12
    Views
    372

    Re: Query and date

    Hi,

    Sory but i'm still lost:(

    I had change my query to incorporate paramaters ("?"), but I still without know where i can declare/put the rest of the code

    The all code that i have...sory the...
  4. Replies
    12
    Views
    372

    Re: Query and date

    Hi,

    Thanks for your help si_the_geek, but, after read the post about parameters i remaing a little bit confused once i don't know where i declare the "?" used in querys...

    You had send me this...
  5. Replies
    12
    Views
    372

    Re: Query and date

    Hi,

    I don't know wich information you want with DBMS, but i use DB Access and VB2008, with this kind of code to read DB:

    con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = "...
  6. Replies
    12
    Views
    372

    Re: Query and date

    Hi,

    I don't know wich information you want with DBMS, but i use DB Access and VB2008, with this kind of code to read DB:

    con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = "...
  7. Replies
    12
    Views
    372

    [RESOLVED] Query and date

    Hi to all,

    Hi have this query, and objectif of this query is to extract dates that are >= to the date of today, but the query don't work well once for example i had try today and i have sort of...
  8. Replies
    9
    Views
    783

    Re: Query and dates

    Hi,

    You have right, i had replace OR by AND and work perfecttly

    Thanks for the help
  9. Replies
    9
    Views
    783

    Re: Query and dates

    Hi,

    You have right, i had replace OR by AND and work perfecttly

    Thanks for the help
  10. Replies
    9
    Views
    783

    Re: Query and dates

    Thanks for the link gibra
  11. Replies
    9
    Views
    783

    Re: Query and dates

    Hi FunkyDexter,

    The first Screenshot is the report that sort Throught the query i hade made. The records marked as black is the records that are wrong's. Are Wrong because they should not be there...
  12. Replies
    9
    Views
    783

    Re: Query and dates

    Hi,

    Thanks for your reply...Ok I start to change the string for parameters.
    Yes the AND and OR work well and in the right order.

    Thanks
  13. Replies
    9
    Views
    783

    [RESOLVED] Query and dates

    Hi to all,

    I would to know in the query that i had made why they sort dates that are previous to the actual date...something wrong with the query?


    sql = _
    "select * " & _
    ...
  14. Replies
    5
    Views
    408

    VS 2008 Re: Exit Private Sub event

    Sory...
    Annother question conserning the same subject.

    When code detect the:


    If TextBox21.Text = "" Then
    MsgBox("Não selecionou nenhum registo")
    Exit Sub
    ...
  15. Replies
    5
    Views
    408

    VS 2008 Re: Exit Private Sub event

    OK...it's a way.

    Thanks for the help
  16. Replies
    5
    Views
    408

    VS 2008 Re: Exit Private Sub event

    OK...it's a way.

    Thanks for the help
  17. Replies
    5
    Views
    408

    VS 2008 Exit Private Sub event

    Hi to all:

    When i load a Form, from my app, the form load an event that i show in code, and the first message when form loaded is the Msgbox that i have in that event.
    Any way to not load this...
  18. Re: Inserting dynamic image in crystal report

    Hi,

    Fantastic sapator...the problem as resolved

    Best regards and many thanks
  19. Re: Inserting dynamic image in crystal report

    Hi,

    I Appreciate your help....Your example, in fact, is to add an image to the database, and it's not my problem.
    My problem is just put an image into CR
  20. [RESOLVED] Inserting dynamic image in crystal report

    Hi to all,

    I use Vb.net 2008 version and crystal Reports 2008 V12

    I had create a OLE.Object in my report and i need to put, dynamicattly, a picture into this OLE.Object...the OLE.Obect name is...
  21. Replies
    14
    Views
    914

    VS 2008 Re: Problem with nunbers

    OK...thanks for all help
  22. Replies
    14
    Views
    914

    VS 2008 Re: Problem with nunbers

    Hi to all:

    Si_the_geek, your suggestion work for my purposes, however look the result of a record:

    159797

    should be 20....

    I had put this code in the final of all calculations:
  23. Replies
    14
    Views
    914

    VS 2008 Re: Problem with nunbers

    Hi Passel,

    The objectif of the code is sum the values after the point (decimals), but if i have a value like 100.20 in my DB, and after query it show 100.2 return different values....for me the...
  24. Replies
    14
    Views
    914

    VS 2008 Re: Problem with nunbers

    Hi,

    Maybe the example is not good....sory!!

    Let's reformulated again:
    Example sum the decimals:100.15 + 100.15 + 100.15 = .45
    Example sum the decimals:100.15 + 100.15 + 100.2 = .32
    Example...
  25. Replies
    14
    Views
    914

    VS 2008 [RESOLVED] Problem with nunbers

    Hi to all,

    I have a problem with numbers when I make a query to sort some numbers.

    My database (access) are format to save numbers in double with 2 decimal digits, that's mean all the numbers...
  26. Replies
    2
    Views
    1,841

    Re: Problem Sorting Report

    Hi,

    The problem as been resolved...
    The problem it was with the configurations of the country...i had change to English language and the report sort like desired.

    Thanks
  27. Replies
    10
    Views
    965

    Re: Database Access

    Hi,

    Yes the screenshots are taken directly from access, and like i had say in the first post, this is the problem...in one PC the database present the values correctly, and in other PC the values...
  28. Replies
    10
    Views
    965

    Re: Database Access

    Hi,

    Sory the delay of the answear.



    The code:
  29. Replies
    10
    Views
    965

    Re: Database Access

    Hi,

    Also, how exactly ware you viewing this data?
    Answear - i see it like i had describe


    Is it through Access itself or another application?
    Answear - through App vb.net
  30. Replies
    10
    Views
    965

    Database Access

    Hi to all,

    I have here a strange problem with the same Database Access in diferent computers.


    The problem is:
    In one computer i have a field, that are defined to String and the values in...
  31. Replies
    2
    Views
    1,841

    [RESOLVED] Problem Sorting Report

    Hi to all:

    I had made a report for my app that works like desired.

    This is the report:

    158747


    I had install the same APP in anotther computer and the report sort like this:
  32. Thread: Order By

    by sacramento
    Replies
    6
    Views
    580

    Re: Order By

    Hi jmcilhinney,

    In fact i need to make others steps to sort that i want.

    Thanks for your help
  33. Thread: Order By

    by sacramento
    Replies
    6
    Views
    580

    Re: Order By

    Hi,

    Yes guys you are right...the sort are correct!
    I need to chance the query

    Thanks
  34. Thread: Order By

    by sacramento
    Replies
    6
    Views
    580

    Order By

    Hi to all,

    I have this query:


    sql = _
    "select primeira_prova_pontos, segunda_prova_pontos " & _
    " from tabela_resultados_geral " & _
    " order by primeira_prova_pontos...
  35. Replies
    4
    Views
    285

    VS 2008 Re: Problem with Double

    OK...thanks
  36. Replies
    4
    Views
    285

    VS 2008 Re: Problem with Double

    Hi,


    This is the code that i have to save on DB...the display are made via Crystal reports




    sSQL = "INSERT INTO " & eventos & " (ID, nome_piloto, carro_piloto, classe, pontos,...
  37. Replies
    4
    Views
    285

    VS 2008 Problem with Double

    Hi to all:

    I have this code:


    Dim laranja_melhor_volta_var as double
    laranja_melhor_volta_var = r.Item("laranja_Melhor_tempo_volta")


    the field "laranja_Melhor_tempo_volta" return this...
  38. Replies
    3
    Views
    450

    Re: Problem with sort on query

    OK...thanks Guys
  39. Replies
    3
    Views
    450

    Problem with sort on query

    Hi to all,

    I have this query to sort the minimum value in my DB


    sql = _
    "select melhor_volta_azul " & _
    " from tabela_resultados" & _
    " order by...
  40. Replies
    2
    Views
    597

    Re: Query in mysql

    Yes...thats it

    Many thanks
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width