Search results for query: *

I have Browse button code, that when I browse to an Excel file, I then want to be able to select a particular worksheet for that file manually so I can then import that particular sheet into a Datagridview. I am trying to use either a combobox or a listbox. My plans are to use the Browse button...

I have an issue with a view that worked and now suddenly it does not. SELECT c2.name, c2.cust_num from custaddr as c2 INNER JOIN co as c1 ON (c2.cust_num = c1.cust_num) INNER JOIN shipper_sii as s1 on (c1.co_num = s1.co_num) WHERE c2.cust_seq = 0 AND lot = '" & Carton1 & "' It should display...

Ok, My code was work all fine and dandy when we used customer number that were numerical in value. We moved some customers from another office into our database, and the customer number are alpha characters... Now every time I run this code I get "The conversion of the nvarchar value '...

Update SQL from DataGridView - IndexOutOfRangeException "Cannot find table (0)' error I am trying to save changes (UPDATE) from a DataGridView to the SQL Table it was pulled from. It pulls the data fine, I can make my adjustments, but when I click my button to update I get a...

I am trying to add a column to a DataGridView that is populated by a DateTimePicker on the form. No errors in my code, but the column is blank at runtime. Imports System.Data.SqlClient Imports System.Windows.Forms Imports System.Windows.Forms.DataGridView Imports System.Windows.Forms.CheckBox...

I am trying to delete all records from a table in one database, and repopulate it with a select statement retrieving data from another database. This is what I have so far... DELETE * FROM Database2.Table3; INSERT INTO Database2.Table3 SELECT * from Table1 join Database2.Table2 on ColumnX...

I am trying to do an SQL Select Query by using the dates supplied by two DateTimePickers to export data from a SQL Server to an Excel Spreadsheet. When I run the app, I get "Line1: Incorrect syntax near 'Tuesday, November 12, 2013 AND Wednesday, November 13, 2013'. " The query is being run on...

I am having an issue with Environment.GetFolderPath(Environment.SpecialFolder.Desktop) Declarations from Earlier in the sub Dim oExcel As Excel.Application Dim oBook As Excel.Workbook Dim oSheet As Excel.Worksheet oExcel = CreateObject("Excel.Application") oBook =...

Trying to create a SQLCommand in VB.NET to do a SELECT from 3 different tables. Table1 - Shipper Contains - LotNum, CustOrderNum Table2 - CustOrder Contains - CustOrderNum, CustNum Table3 - Customer Contains - CustNum, CustName The tables contain more, but these are the columns I am working...

Having an issue passing some information between forms. On a login form, I passed and Employee ID number to a hidden label on the next form (form1). And it shows up if I remove the hide label. I am trying to using the employee id number I passed to that hidden label, to pull First and Last name...