dcsimg

Search:

Type: Posts; User: sacramento

Page 1 of 13 1 2 3 4

Search: Search took 0.25 seconds.

  1. Replies
    12
    Views
    984

    Re: Strange problem in Query

    Hi Guys,

    Yes jmcilhinney you had right...I can't Change a value that i use to identify a record.

    Thanks
  2. Replies
    12
    Views
    984

    Re: Strange problem in Query

    Hi,

    OK...i had add more 4 parameters and the code are now like this:


    sSQL = "UPDATE encomendas SET Projecto_N = @numero_Projecto_fornecedor_antiga, "
    sSQL = sSQL &...
  3. Replies
    12
    Views
    984

    Re: Strange problem in Query

    Hi,

    Yes the database is access...I think i had acomplish the rule...i have 15 fields in my database and 15 parameter in the SQL
  4. Replies
    12
    Views
    984

    Re: Strange problem in Query

    Hi,

    Thanks for your reply...
    I think, that is that i do, in the where clause...I save the original values.
  5. Replies
    12
    Views
    984

    Strange problem in Query

    Hi to all:

    I had write this query for Update records in database. Query work well, But if a Change somehting in field "Projecto_N" or "Encomenda_N" the records not chance...for all the rest of...
  6. VS 2008 Re: Listview and Selected records

    Ok guys problem resolved

    Code:


    'Make the focus for the record that as been add
    ListView2.Focus()
    ListView2.Items(point_linha_var_listview2 -1).Selected = True
    ...
  7. VS 2008 Re: Listview and Selected records

    Hi,

    This is the code to count the next record:


    Dim con As New OleDb.OleDbConnection(String.Format("PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = " & My.Application.Info.DirectoryPath &...
  8. VS 2008 [RESOLVED] Listview and Selected records

    Hi to all,

    I have a little problem that is:
    When i add a new record, in my DB, i would like this new record could selected on my Listview, and i had right this code:

    Information:...
  9. Replies
    3
    Views
    381

    Re: Query and Array

    Thanks Jmcilhinney

    In fact is a good idea... In that way all the values are in
  10. Replies
    3
    Views
    381

    [RESOLVED] Query and Array

    Hi to all,

    I had write this little query, that work, but i don't know if this is the best way to do.
    The query call a Variable that is an array, with dimension with 11 numbers.

    Any other way...
  11. Replies
    2
    Views
    312

    VS 2008 Re: Error Loading Project

    Hi,

    Thanks for the tip...i had open with text editor and i had delete the line that cause the error.

    The project as open now

    Thanks
  12. Replies
    2
    Views
    312

    VS 2008 [RESOLVED] Error Loading Project

    Hi to all,

    I have this error when loading a project

    170361

    Any help concercing this subject please?

    Thanks
  13. Replies
    6
    Views
    447

    VS 2008 Re: Autonumber Increment

    Hi,

    Like topshot as said, the Max give the next number in autonumber field, but if you said that is not a good way to do, then i think i use the opinion of si_the_geek

    Thanks Guys
  14. Replies
    6
    Views
    447

    VS 2008 Autonumber Increment

    Hi to all,

    My database is access and i Work with vb.net 2008.

    I would like, via code, see the next number of autonumber field and i had create this code:


    Dim olecommand As New...
  15. Replies
    12
    Views
    522

    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
  16. Replies
    12
    Views
    522

    Re: Query and date

    Thanks for your help...

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

    168211
  17. Replies
    12
    Views
    522

    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...
  18. Replies
    12
    Views
    522

    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...
  19. Replies
    12
    Views
    522

    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 = "...
  20. Replies
    12
    Views
    522

    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 = "...
  21. Replies
    12
    Views
    522

    [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...
  22. Replies
    9
    Views
    892

    Re: Query and dates

    Hi,

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

    Thanks for the help
  23. Replies
    9
    Views
    892

    Re: Query and dates

    Hi,

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

    Thanks for the help
  24. Replies
    9
    Views
    892

    Re: Query and dates

    Thanks for the link gibra
  25. Replies
    9
    Views
    892

    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...
  26. Replies
    9
    Views
    892

    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
  27. Replies
    9
    Views
    892

    [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 * " & _
    ...
  28. Replies
    5
    Views
    465

    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
    ...
  29. Replies
    5
    Views
    465

    VS 2008 Re: Exit Private Sub event

    OK...it's a way.

    Thanks for the help
  30. Replies
    5
    Views
    465

    VS 2008 Re: Exit Private Sub event

    OK...it's a way.

    Thanks for the help
  31. Replies
    5
    Views
    465

    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...
  32. Re: Inserting dynamic image in crystal report

    Hi,

    Fantastic sapator...the problem as resolved

    Best regards and many thanks
  33. 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
  34. [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...
  35. Replies
    14
    Views
    1,010

    VS 2008 Re: Problem with nunbers

    OK...thanks for all help
  36. Replies
    14
    Views
    1,010

    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:
  37. Replies
    14
    Views
    1,010

    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...
  38. Replies
    14
    Views
    1,010

    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...
  39. Replies
    14
    Views
    1,010

    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...
  40. Replies
    2
    Views
    1,931

    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
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width