Search results for query: *

  • Users: Hoogie
  • Content: Threads
  • Order by date
  1. H

    Issues deleting a newly created record in the datatable/database

    When I create a new record and try deleting it right after, I get an "Concurrency violation: the DeleteCommand affected 0 of the expected 1 records." I've been messing around with it for some time now and cannot figure out why. If I add a new record, close my program, re-open and try and delete...
  2. H

    SendKeys and Sleeping

    When using the below code to send keystrokes to another application, all the waits seem to happen at once, and then all the SendKeys happen right after another without any waiting, is there a way to prevent that from happening? Dim intMouseX As Integer Dim intMouseY As Integer...
  3. H

    Convert entire Excel column from Text to Number

    I'm writing a program that needs to convert numeric values in a Excel file to display as numbers and not text. The below code works, however is slow (very slow for large files) because it must check every single cell to see if it is a number, and than convert it to a number format. raXL =...
  4. H

    Date.Now causing increasing memory usage?

    I'm curious, why would a timer checking the exact date/time every second cause an increase in memory according to task manager every time it ticks? Private Sub Timer1_Tick(sender As Object, e As EventArgs) Handles Timer1.Tick Label1.Text = Date.Now End Sub That increases memory...
  5. H

    Unlink data from Excel sheet

    I'm designing a program that runs a Excel query file (.dqy), edits the information by adding mathematical columns, and saves the Excel file. That all works, however I would like to unlink the data connection to the saved file, and I am unsure on how to do that without using sendkey commands...
  6. H

    Accidently converting to 4.0

    I accidently converted my 4.5 .NET framework applciation to 4.0 and then back again without manually editing any code. I now have an error when trying to load up a database using a Oledb connection. Import and declarations: Imports System.Data.OleDb Public Class frmAutoReport Dim conn...
Back
Top