ACCESS FEED: Re: [MS_AccessPros] Using UPDATE to change data in a table via combobox and command button

Kamis, 29 November 2012

Re: [MS_AccessPros] Using UPDATE to change data in a table via combobox and command button

Tony-

Your quotes are all messed up. Try this:

strSQL = "UPDATE tableWarehouseData " & _
"SET Status = '" & V & "' " & _
"WHERE ticket = '" & Me.comboVoidTicket & "'"

That assumes that ticket is a text field. If not, then do:

strSQL = "UPDATE tableWarehouseData " & _
"SET Status = '" & V & "' " & _
"WHERE ticket = " & Me.comboVoidTicket

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: Gkillah36 <GKillah36@aol.com>
Reply-To: <MS_Access_Professionals@yahoogroups.com>
Date: Friday, November 30, 2012 6:17 AM
To: <MS_Access_Professionals@yahoogroups.com>
Subject: Re: [MS_AccessPros] Using UPDATE to change data in a table via
combobox and command button

V just comes from me. I just want to have all of the Status field values
change to V for the ticket that the user selects. The Status field is
text.

Thanks,
Tony

-----Original Message-----
From: Duane Hookom <duanehookom@hotmail.com>
To: Access Professionals Yahoo Group
<ms_access_professionals@yahoogroups.com>
Sent: Fri, Nov 30, 2012 12:15 am
Subject: RE: [MS_AccessPros] Using UPDATE to change data in a table via
combobox and command button

Where does V come from? Is the Status field text or numeric?

Learn how to implement
Debug.Print strSQL
So you can troubleshoot on your own.

Duane Hookom MVP
MS Access

> From: GKillah36@aol.com
>
> Hi all,
>
> Please see my VB below:
>
> Private Sub commandVoid_Click()
>
> Dim strSQL As String
>
> If MsgBox("Are you sure you want to void this ticket?", vbYesNo) = vbYes
>Then
> strSQL = "UPDATE tableWarehouseData " & _
> "SET Status = " & V & " " & _
> "WHERE ticket = " & Me.comboVoidTicket & ""
> CurrentDb.Execute strSQL, dbFailOnError
> End If
> End Sub
>
>
> ----------------------------------------
>
> This should change the Status field of all tickets in the table
>tableWarehouseData to V when clicked based on the selected ticket number
>in the comboVoidTicket combobox. However, I'm getting an error of
>"Run-time error '3144': Syntax error in UPDATE statement." What am I
>missing here?
>
> Thank you,
> Tony
>
> FYI, I'm using Access 2010.

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links