G
Guest
I have a project that I am working on that will (ultimately) write to 2 Excel Spreadsheets, 3 Access databases, and communicates with 3 other programs (torque monitoring software, a laser rangefinder, and a specialized industrial inkjet printer). I had much of it working in VB6, but then upgraded (for reasons that I can no longer remember) to .NET. I am now having problems communicating to Access. The main form has 35 text boxes on it fo an operator interface, and using a series of datagrids for the interface is not an option, as this would truely confuse the end users
It seems that most of the material in MSDN assumes that you are using SQL server. Very little is written for Access. This has made life miserable for the last 2 weeks. I should also mention that I am primarily a Network Administrator, but have done some VB programming on the side
I have tried the following
Updating the database from a datasest object (Q301248). (This is where I am at, at present) When the program is run, no errors are found, data column references are accepted, but the database is not updated. Section of code folllows
(in Declarations
Dim drCurrent As DataRo
Dim tblQAData As DataTabl
(during Form load)
tblQAData = PipeData1.Tables("QAData"
(process for writing to 1 database
' Write QA Data for pipe to databas
drCurrent = tblQAData.NewRo
drCurrent("ID") = "
drCurrent("WorkOrder") = Text3.Tex
If Text25.Text <> "" The
drCurrent("Tube#") = Text25.Tex
End I
If Text5.Text <> "" The
drCurrent("Heat#") = Text5.Tex
End I
If Text9.Text <> "" The
drCurrent("Connector#") = Text9.Tex
End I
drCurrent("Weight") = Val(Text7.Text
drCurrent("Length") = Val(Text9.Text
drCurrent("ShoulderTorque") = "0.0
drCurrent("DeltaTorque") = "0.0
drCurrent("MaxTorque") = "0.0
drCurrent("ProductionDate") = Toda
drCurrent("ProductionTime") = TimeOfDa
drCurrent("OperatorName") = Text27.Tex
drCurrent("TrailerID") = Text16.Tex
drCurrent("TrailerLoad#") = Val(TextBox1.Text
tblQAData.Rows.Add(drCurrent
Previous attempt was to create 5 datagrids with visible set to "false", each one of which would have updated an appropriate table, but could not find a way to write the data in the text boxes to a datagrid
I forget what else I have tried. Very open to suggestions, very frustrated by the extreme granulation of the help files, in that they show too small of a segment to really understand the overall process
Thanks in advance
Leon
It seems that most of the material in MSDN assumes that you are using SQL server. Very little is written for Access. This has made life miserable for the last 2 weeks. I should also mention that I am primarily a Network Administrator, but have done some VB programming on the side
I have tried the following
Updating the database from a datasest object (Q301248). (This is where I am at, at present) When the program is run, no errors are found, data column references are accepted, but the database is not updated. Section of code folllows
(in Declarations
Dim drCurrent As DataRo
Dim tblQAData As DataTabl
(during Form load)
tblQAData = PipeData1.Tables("QAData"
(process for writing to 1 database
' Write QA Data for pipe to databas
drCurrent = tblQAData.NewRo
drCurrent("ID") = "
drCurrent("WorkOrder") = Text3.Tex
If Text25.Text <> "" The
drCurrent("Tube#") = Text25.Tex
End I
If Text5.Text <> "" The
drCurrent("Heat#") = Text5.Tex
End I
If Text9.Text <> "" The
drCurrent("Connector#") = Text9.Tex
End I
drCurrent("Weight") = Val(Text7.Text
drCurrent("Length") = Val(Text9.Text
drCurrent("ShoulderTorque") = "0.0
drCurrent("DeltaTorque") = "0.0
drCurrent("MaxTorque") = "0.0
drCurrent("ProductionDate") = Toda
drCurrent("ProductionTime") = TimeOfDa
drCurrent("OperatorName") = Text27.Tex
drCurrent("TrailerID") = Text16.Tex
drCurrent("TrailerLoad#") = Val(TextBox1.Text
tblQAData.Rows.Add(drCurrent
Previous attempt was to create 5 datagrids with visible set to "false", each one of which would have updated an appropriate table, but could not find a way to write the data in the text boxes to a datagrid
I forget what else I have tried. Very open to suggestions, very frustrated by the extreme granulation of the help files, in that they show too small of a segment to really understand the overall process
Thanks in advance
Leon