dcsimg

Search:

Type: Posts; User: AngelSpeaks

Search: Search took 0.01 seconds.

  1. Re: VB.NET 2019 Import Excel Worksheet to DataGridView for Inserting to Access Table

    :) I FIXED IT! I finally got it to work!

    Successful code is:

    If dgvHoursInput.Item(7, i).Value Is DBNull.Value OrElse String.IsNullOrWhiteSpace(CStr(dgvHoursInput.Item(7, i).Value)) Then
    ...
  2. Re: VB.NET 2019 Import Excel Worksheet to DataGridView for Inserting to Access Table

    Thanks. Good to know.
  3. Re: VB.NET 2019 Import Excel Worksheet to DataGridView for Inserting to Access Table

    Here's an update:


    If dgvHoursInput.Item(8, i).Value Is DBNull.Value OrElse CStr(dgvHoursInput.Item(8, i).Value) = String.Empty Then
    dgvHoursInput.Item(8, i).Value = 0
    ...
  4. Re: VB.NET 2019 Import Excel Worksheet to DataGridView for Inserting to Access Table

    Thank you for responding John. I was following the procedure to import Excel spreadsheets into Access from this It was at the top of my Google. I will look for the reverse.

    Same thing with my...
  5. [RESOLVED] VB.NET 2019 Import Excel Worksheet to DataGridView for Inserting to Access Table

    Hi Folks,

    I'm currently trying to import an Excel spreadsheet into a DataGridView. That part works great. Then I'm checking each column to make sure that if the column is null that it's set to...
  6. Re: VB2019 Access Database Trying to Use DataTable.Copy Method

    Thanks John, that's probably a better idea.
  7. Re: VB2019 Access Database Trying to Use DataTable.Copy Method

    Thanks for responding si_the_geek. Question? Does the INSERT INTO table2 (Field1, field2).............. also create the columns and their definitions or do I have to do the following (which does...
  8. Re: VB2019 Access Database Trying to Use DataTable.Copy Method

    Thanks, I knew it was something stupid. I've used your suggestion on another table, I thought there would be an easier way when a table was being created by basically copying it.
  9. Re: VB2019 Access Database Trying to Use DataTable.Copy Method

    And I've confirmed that there are 684 rows returned in adoBenefits.
  10. [RESOLVED] VB2019 Access Database Trying to Use DataTable.Copy Method

    Hi guys! I know it's something stupid that I missed. Here's what I'm doing. My application uses Access Database. I have a table, tblPWBenefits, which has the current year transactions. At year...
  11. Re: VB.NET to C# Conversion Issues With Files

    Thanks so much peterst and si_the_geek!
  12. [RESOLVED] VB.NET to C# Conversion Issues With Files

    I'm trying to convert a VB.NET project to C#.

    My VB code:


    Dim infoReader As System.IO.FileInfo
    infoReader = My.Computer.FileSystem.GetFileInfo(Me.ofdOpenFiles.FileName)
    ...
  13. VS 2012 Re: VB.NET 2012 Proper Way to Reference Controls on StartUp Form

    John, I used the first example in part 3.

    In my second form (frmAdjectives), I added:



    'This code passed lblNewWord back to frmBackground
    Public ReadOnly Property NewAdjective As...
  14. VS 2012 Re: VB.NET 2012 Proper Way to Reference Controls on StartUp Form

    Update. Thanks to John's response, I have followed his tutorial and used option 3.
  15. VS 2012 Re: VB.NET 2012 Proper Way to Reference Controls on StartUp Form

    Thank you jmcilhinney for the very detailed response. I have definitely found out the hard way that VB is more forgiving. I've been making many changes to follow the better coding techniques. ...
  16. VS 2012 [RESOLVED] VB.NET 2012 Proper Way to Reference Controls on StartUp Form

    I know that generally to access a control on a form, say a label named lblSentence on a form named frmBackground, from another form, you would do the following:



    Code in frmJ (second form):
    ...
  17. VS 2012 Re: Images causing Out of Memory Condition

    Update, my out of memory condition seems to be resolved, the larger images are taking a long time to load. I am not surprised about this, I have a lot of very large images on my computer (I'm an...
  18. VS 2012 Re: Images causing Out of Memory Condition

    Thanks for the suggestion boops boops.

    I did comment it out, but noticed no improvement. It was worth a try!
  19. VS 2012 Re: Images causing Out of Memory Condition

    Thanks again Passel. The line in question was copied from an example that I found. I thought it was a bit weird too.

    Made the change you suggested, it's still on the slow side, but the whole...
  20. VS 2012 Re: Images causing Out of Memory Condition

    Thanks for replying. There is a lot of code after the call to ResizeImage, but I could rework it. Thanks for the tips.
  21. VS 2012 Re: Images causing Out of Memory Condition

    Thank you for your reply. I'm confused on this dispose. You (and si_the_geek also) commented on the Image.FromFile(gstrPicture(intIndex)).Dispose() not making any sense. This code is after calling...
  22. VS 2012 [RESOLVED] Images causing Out of Memory Condition

    Hi Everyone,

    A little background. I have an application that creates picture communication boards. The boards may contain up to 40 images. The pictures and images that I include have all been...
  23. Re: VB.Net 2012 Want to Display Windows Account Login Image on Windows Form

    It worked! I made it a separate module. Thanks so much.
  24. Re: VB.Net 2012 Want to Display Windows Account Login Image on Windows Form

    Thanks. I didn't find that with my search. I'll give it a try.
  25. VB.Net 2012 Want to Display Windows Account Login Image on Windows Form

    Hi Gang,

    I sure hope that I am wording this properly. What I want to do is on a form (say frmAboutMe), where I allow the user to enter info about himself/herself, I want to also display the...
Results 1 to 25 of 28



Featured


Click Here to Expand Forum to Full Width