TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
ZULFAHMI AIDI
NA
8
0
No value given for one or more required parameter for update query
Mar 30 2010 10:36 AM
Hi there, i got problem here when i try to run the update query. the msg box the error is "No value given for one or more required parameter for update query".
the query is
Dim strSQL As String = ("UPDATE [DailyReport] SET [Status] ='" & txtRepSta.Text & "' WHERE DailyID ='" & txtDailyRep.Text & "' ")
Dim cmd As OleDbCommand = New OleDbCommand(strSQL, OleDbConnection)
Dim objread As OleDbDataReader
objread = cmd.ExecuteReader
MsgBox("Update Success")
i have try to add more paremeter but the result still the same, "No value given for one or more required parameter for update query". There new query i try
Dim strSQL As String = ("UPDATE [DailyReport] SET [Status] ='" & txtRepSta.Text & "', [TimeRes] = '" & timeToday.Text & "' WHERE DailyID ='" & txtDailyRep.Text & "' AND PatientHp = '" & txtRecNo.Text & "' ")
Dim cmd As OleDbCommand = New OleDbCommand(strSQL, OleDbConnection)
Dim objread As OleDbDataReader
objread = cmd.ExecuteReader
MsgBox("Update Success")
Can anyone kindly advise me with this
Reply
Answers (
1
)
convert vb8 textboxes to excel 2007 adding always in the same sheet but in next lines
Excel to 2 Access Databases, then notification E-Mail