Search:

Type: Posts; User: Mike Storm

Page 1 of 11 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    31
    Views
    9,702

    Re: [RESOLVED] No data transfer in one column

    Can you post the code you used, i m not understanding something.
  2. Replies
    31
    Views
    9,702

    Re: [RESOLVED] No data transfer in one column

    Hi, i dont know what you mean by doing it like Mike sugested but keep in mind that in your case will be better to use post #20 JMC sample code.
    As i mention before i set DBNulls to default values...
  3. Replies
    31
    Views
    9,702

    Re: No data transfer in one column

    I dont work in Access for a long time, in a quick research it seems it does not has null(seems) but it does has required, that will be about the same thing.
  4. Replies
    31
    Views
    9,702

    Re: No data transfer in one column

    You got a point there, i had already edited the post and typed undeneit it



    I use does couse i have the habit of set default values when is a dbnull or set it as empty string, in the case of...
  5. Replies
    31
    Views
    9,702

    Re: No data transfer in one column

    And also if in your dataset you have the property Allow null as true but in your database its set to do not allow dbnull, it will still trow you a exception.
  6. Replies
    31
    Views
    9,702

    Re: No data transfer in one column

    You cant pass DBNull as string/Integer or what ever, couse DBNl its like the field does not exists, its a "Vacuum" spot.



    So in order to handle a DBNull field you will need to validate if it is...
  7. Replies
    31
    Views
    9,702

    Re: No data transfer in one column

    Have a look:
    152681
    This is SQL, but Acces wont be that diferent i belive.
    152683

    Now, if your issue is that the field does not allow DBNUll, you need to make sure you set bouth cases(in the...
  8. Replies
    31
    Views
    9,702

    Re: No data transfer in one column

    Either on the dataset, or in the database itself, or in bouth.
  9. Replies
    31
    Views
    9,702

    Re: No data transfer in one column

    Have a look on this:

    https://msdn.microsoft.com/en-us/library/system.dbnull.value(v=vs.110).aspx

    See it as vacuum field.
  10. Replies
    31
    Views
    9,702

    Re: No data transfer in one column

    You need to see if it is supoused to return a DBNull value on that field, and if not why it is doing it.

    Now here are 2 ways to handle DBNull values:




    'Option one
    ...
  11. Replies
    31
    Views
    9,702

    Re: No data transfer in one column

    I belive your issue is that you trying to pass a DBNull Value, meaning the source field is empty and never had a value, right?
  12. Replies
    30
    Views
    13,378

    Re: [RESOLVED] DGV Column issue

    Lol...
  13. Replies
    30
    Views
    13,378

    Re: DGV Column issue

    I was thinking there where a a problem with the fill.
  14. Replies
    30
    Views
    13,378

    Re: DGV Column issue

    I dont understand very well what 4 fields do you refear to?
  15. Replies
    30
    Views
    13,378

    Re: DGV Column issue

    I have no idea what may be actualy cousing that, first i would do would be set visible all datagridview columns and see its values.
  16. Replies
    30
    Views
    13,378

    Re: DGV Column issue

    I have no ideia about that one, but if you add a databound datagridview to a form and leave the autoincrement primary key visible, while you dont save the data you will see that the auto increment...
  17. Replies
    30
    Views
    13,378

    Re: DGV Column issue

    If the -1 value is the return of the Indexkey/Primary Key then you hgetting the index of a new row that has not been yet saved.
    Means your table has no rows, either couse you not filling it, or the...
  18. Replies
    30
    Views
    13,378

    Re: DGV Column issue

    I dont understand why you in you first post you fill TblChangeApproveTableAdapter, i guess that code will be under some other event like form load, and then you fill TblChangeApproveTableAdapter ...
  19. Replies
    30
    Views
    13,378

    Re: DGV Column issue

    I m not understanding, and i dont have VS here now, can you post the exception message?
  20. Replies
    30
    Views
    13,378

    Re: DGV Column issue

    Explain:
    Is the exception trown under the doubleclick event or under RemoveApprover?
  21. Replies
    30
    Views
    13,378

    Re: DGV Column issue

    Inside of the try catch or out of it should trow you the exception anyway
  22. Replies
    30
    Views
    13,378

    Re: DGV Column issue

    Replace column index by column name


    glbintIDNum = CInt(Me.dgvSignList.Rows(e.RowIndex).Cells("ColumnName here").Value)

    also you should check if the value is not dbnull
  23. Replies
    30
    Views
    13,378

    Re: DGV Column issue

    What does happen, does it gives you a exception?
  24. Replies
    30
    Views
    13,378

    Re: DGV Column issue

    First you wanna make sure you clicking a valid row and not the column headers:




    Private Sub dgvSignList_CellDoubleClick(sender As Object, e As DataGridViewCellEventArgs) Handles...
  25. Replies
    30
    Views
    13,378

    Re: DGV Column issue

    Can you post the rest of the code you use to remove the aprovern including the event and the methode?
  26. Replies
    30
    Views
    13,378

    Re: DGV Column issue

    CStr and then .Value.ToString, no need!!
    I would use just CStr, .ToString provides you with a exception if the value is dbnull.

    glbstrName = CStr(Me.dgvSignList.Rows(e.RowIndex).Cells(5).Value)
  27. Re: VB in VS2017 Blue Screen of Errors problem/question

    Hi,
    I have seen this happening in VS 2017 Community working with inherited controls like TabControl, or also if using usercontrols, but its more frequent when you add a databound control by drag and...
  28. Replies
    7
    Views
    1,231

    VS 2013 Re: Convert from string to date

    lets see what he explains about his problem, the way i initialy interpretate it was that the column in the excel file had format "MM / dd / yyyy" and on the DB "dd / MM / yyyy". but as i mation...
  29. Replies
    7
    Views
    1,231

    VS 2013 Re: Convert from string to date

    I belive his issue is that he gets the Date with a US format, but he needs to store it in a database that has a diferent regional setting.
    He can use something like this to get the date converted to...
  30. Replies
    7
    Views
    1,231

    VS 2013 Re: Convert from string to date

    Have a look on this:




    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

    Dim DATE_ As Date = Now.ToShortDateString
    Dim C_US As New...
  31. VS 2015 Re: is it possible to open a chm file in a mdichild window

    Yeap, thats another option... i wasn't making a critic, i was just alerting him that the window did open in the mdi container, he just didnt see it couse of its location.
  32. VS 2015 Re: is it possible to open a chm file in a mdichild window

    Hi, i had a look on to pclement code and it works with Option Explicit OFF and with Option Explicit On you will have to change for this:




    Process.Start("F:\dv_aspnetmmc.chm")
    ...
  33. Replies
    28
    Views
    2,294

    VS 2017 Re: Get rid of Highlights

    You right, but only when you set its value, once it loses focus by default will become white again.
    Another option to prevent it of ever be highlighted is to set DropDownStyle = DropDownList,...
  34. Replies
    28
    Views
    2,294

    VS 2017 Re: Get rid of Highlights

    a way to check that is to add a new combo, bind it to the same value as the "Where used" for exemple, and do not add any other code, ans see what it does.

    As for the fact that you like to style...
  35. Replies
    28
    Views
    2,294

    VS 2017 Re: Get rid of Highlights

    Keypreview will not solve that issue, was just to give u a exemple that its not TABStop that is doing that.
    Is there any code seting the value of does combos?
  36. Replies
    28
    Views
    2,294

    VS 2017 Re: Get rid of Highlights

    Another way to test that, and as a wild guess what i think is happening there is that somewhere in you code you are setting the value of does combos using...
  37. Replies
    28
    Views
    2,294

    VS 2017 Re: Get rid of Highlights

    It will be related to your code or propertyes set in the property window, i use tabstop on mine, actualy my forms normaly have KeyPreview set to true, and i supress Enter key and use send key {TAB},...
  38. Replies
    28
    Views
    2,294

    VS 2017 Re: Get rid of Highlights

    Hi, this is a weird one....
    I wonder if HideSelection in the textboxes proprety window its set to false?
  39. VS 2010 Re: [RESOLVED] Include values returned from a function in SQL string

    Have a look on this:




    Public Sub TestThis_Show_QSOs_In_Selected_Country(sBand As String, sCountry As String)


    Dim dt As New DataTable
  40. Replies
    60
    Views
    21,659

    VS 2017 Re: [RESOLVED] System.InvalidCastException

    And the link i posted https://imgur.com/a/upImb , you have to uncheck that to be able to change the datatypes.
    And im off for today, just finish what i was doing, enjoy your reading
Results 1 to 40 of 425
Page 1 of 11 1 2 3 4



Click Here to Expand Forum to Full Width