Search results for query: *

my update command is not working. can anyone see what the problem is? I am not getting an error... Dim cnTag1 As New OleDb.OleDbConnection cnTag1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Password=;User ID=Admin;data source=c:\BlownAway.db.mdb" Dim...

I need to insert into sql either a string or a null value based on an if statement before the insert statement. here is my code. If AcctNo(intC) = "18410" Then TrExpCode = "VMISC" Else TrExpCode = DBNull.value (here is the problem) End If...

I have a crystal report in my vb.net program that has a subreport. the subreport doesn't need the parameter only the main report. it askes me twice for the same parameter when it is run. Is it because of the subreport and if so what can i do to stop that. thanks Michelle

Does anyone know how to change the title bar color from windows blue to another color? Michelle

I have created an excel sheet using vb.net and I am able to set the row size and column size etc but I need to be able to set a page break when a variable changes. Any ideas?? here is a snipit of the code I am using... Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook...

I am creating a DTS that takes data from one table(tblA) and inserts it into another(tblB) but tblB has an incrementing PK and I am getting an error "cannot insert a null value" or something of that sort. Any ideas? Thanks Michelle

I have a combo box that gets filled from a dataset with account numbers. The problem I am having is that the first account in the dataset is being used by accident by the user. (they are forgetting to choose the account) I would like to have the first thing on the list be "Choose your account"...

here is the error Error string: Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed...

my code to have an enter key work as a tab key worked at first but now it will not work. has anyone any ideas? here is the code. Protected Overrides Sub OnKeyDown(ByVal e As System.Windows.Forms.KeyEventArgs) Dim ctl As Control = Me.ActiveControl If TypeOf ctl Is TextBox And...

Right now I am using a datareader and a do while loop to gather records and then using a dataset I am inserting the data into another table. I have 60000 records to go through and it is taking hours. Is there a faster way? Thank you in advance, Michelle

I am connecting to progress and I will have a dataadapter run fine, and then the next time I run it I will get an error "column not specified" This is driving me nuts! Has anyone else had this problem?? Michelle

I really need help. I cannot figure out why my code is hanging on the fill. It never used to. Here is my code. any help will be extremely appreciated. Me.daNet.Fill(Me.DsNet) 'here is where it is hanging t = Me.DsNet.Tables("Nettrack") Dim myrow As DataRow...

I am using the dataadapter and dataset to insert rows into my sql table but it is extremely slow on the da.fill and the da.update what am i doing wrong. here is the code Me.daNet.Fill(Me.DsNet) Dim t As DataTable t = Me.DsNet.Tables("Nettrack")...

why would an insert duplicate itself on occasion?

I have a timesheet program that sends daily entries into a table for payroll. when a day, has been sent, the form exits and sends the user back to the entry page. I have validation that goes in to see if the day being entered, has already been sent and if it has, sends a message and exits the...

How can I close the open connection when the try/catch catches an error? I have tried cnName.close() but it doesn't recognize the cnName because it is out of the area it was created in. Once the error is caught and the program is tried again, I get the connections already open message... thank...

I would like to highlight a group of rows and change all the values of one column to a value. another words, when the user sees the datagrid, they may only want to select say 4 rows. while these 4 rows are selected, they will change all of the data in column "Status" to "S" without goint to...

MONTH({EMPDETL.BDAY}) ={?Month} OR MONTH({EMPDETL.ANNIVERSARY}) ={?Month} OR MONTH({EMPDETL.HDATE}) ={?Month} and {EMPDETL.STATUS} = "A" what could be wrong with this? I still see status items that are not "A" thank you.

I design my projects while using 1280 x 1024 but my users have their settings at 800 x 600. This causes a problem with the usability of the program. They are having to scroll everywhere. Is there a way to avoid this? Michelle

I have a program that has been working fine but just started to give me an error at the point of showing a form... here is the code. If answer = pass Then Dim frmPC As New frmPayRollCorrect() frmPC.MdiParent = Me.MdiParent Me.Hide()...