Search results for query: *

ok, I solved it by looking back at some old questions. I put the values right in the statement instead of using parameters and it worked.

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...

chip, I guess I am a little slow, could you explain that in code? I tried setting the string to empty but still couldnt set it to dbnull. i am lost.

...= "18410" Then TrExpCode = "VMISC" Else TrExpCode = DBNull.value (here is the problem) End If ***cut to the insert statement***** sqlchk = "Insert Into PRTran (TRExpCode) values('" & TrExpCode & "')" please any help would be much appreciated...

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

Thanks chrissie1, you have been very helpful.

just my app, sorry if I didn't make that clear...

is there no way to control it in the code of the program? Or am I not understanding??

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

Thank you! I have it working now with your help. The error was coming from a mistake on my part not the code.

now I am getting this error Exception from HRESULT:0x800A03EC

do I need to declare "ActiveCell"? I am getting an error

...= True xlSheet.Cells(1, 1) = "Truck No" xlSheet.Cells(1, 2) = "SO Number" Dim sqlC As String = "Select * from DelTracking order by TruckNo, SONumber" Dim cmC As New SqlClient.SqlCommand(sqlC, SqlConnection3) SqlConnection3.Open() Dim rdrC As...

wait, I am still not sure that makes sense. I may not be explaining myself correctly. I would want to append rows I just want to igore the identity column but that is not working.

I am using the wizard to create the DTS. do I need to delete the row that is the identity column in column mappings and transformations?

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

Thank you for your response Frederico, and all of you who tried to help me. We did restart the server after installed the oracle client software but still have no luck in scheduling the dts. for right now, until I can figure out why it will not work, I am executing the dts every morning...

how??

i was just trying that. i was binding it in the property box but know i am trying it in code to see if that will do it

ok, got pass that error but now it says "Cannot modify the items collection when the DataSource property is set." michelle