Search results for query: *

I am a very low level programmer at best. I have finally wrote a program that my company can actually use! I am very excited about this, but I have no idea how to package and deploy a program using VB.Net. This would be the first program I have wrote that actually would be used. Can anyone tell...

Basically I have a Access DB... I try and pull a record from 1 table and Insert into another. When I try and Insert I get a Data Type Mismatch Error. I believe because one field is System.DBNULL. So the Question I have is how do I check the field to see if its a DBNULL then Change the Value to...

THANKS to everyone... The Problem turned out to be I had varible defined as text when it should have been number in my database.

I believe I had several things wrong with my SQL Statement and I really appreciate all of you guys taking the time to help me. In the end the problem was checknumber defined as a text field in the DB and once I switched this number field... all of your examples worked. I especially appreciate...

This is everything below... Sorry to keep pestering you. Maybe this is just out of my league... I can write VBA all day but this sux... Public Class Form1 'Below is my attempt to handle Reversal in Mas90 'Should connect to DB then find Reversal flags.... 'then find matching check...

I pasted this in and nothing happened... did I miss something? Nothing changed in my table... Dim strSQL As New String("Update Mas90Data Set Result = 'REVRSL' Where CheckNumber = ") strSQL += Mas90CheckNumber

("Update Mas90Data Set Result = 'REVRSL' Where CheckNumber = '" & Mas90CheckNumber, dbconnection) I hate SQL... Thanks for Helping feed my family.

I am very very low skilled programmer... I dont understand the suggestion about building as a string varible. I mean I understand the concept... but not exactly ready to try it. however I did try ("Update Mas90Data Set Result = 'REVRSL' Where CheckNumber = '" & Mas90CheckNumber, dbconnection)...

Sorry for my very lack of understanding.... and Thanks for yours. When I try and run the following SQL Statement I get the error message "Data Type mismatch" ("Update Mas90Data Set Result = 'REVRSL' Where CheckNumber = '" & Mas90CheckNumber & "'", dbconnection) If I remove the "Where portion...