Access 2003, sql error 3144. Please help

Add a field to the order table, call it OrderID. Its data type should be Number, size Long Integer. In your master/child links, that's the field in the subform that should be linked on.
 
MSAccessRookie said:
No one has talked about the meaning of the error.
Error #3144 = Syntax error in UPDATE
​
Evaluation of this version of the code (when Total1 = 25, Cost1 = $35.00 and ID = 2345) shows the following:

sql = "UPDATE [master contract] SET total1 = 25, cost1 = 35.00, WHERE ID = 2345"

It looks like there may be an extra comma here. I know that this is a sample version, but removing the comma might make it work. If it does, there there might be a similar error in the complete formula.

Another thing for you to consider is that you may be exceeding the character limit for an SQL Query.
Click to expand...

Thank you for the info, but where I was having this problem had to do with having a table with a 'memo' type, when it should have been set to text.
 
So here's a question for you....I have a text box that is populated with info based on a combo box selection. Is there a way to make the populated text box editable?
 
How is it populated? If it has a control source of:

=ComboName.Column(x)

then it would not be editable. If you place the value there in code, and the control source is either a field name or unbound, then it should be editable.
 
I tried using this:
Private Sub itemOrder_AfterUpdate()
Me.desOrder = Me![itemOrder].Column(1)
End Sub

- Where desOrder = text box being filled & itemOrder = querey populating combo box
but that didn't work. Is there something else I should be doing?
 
What do you mean by it not working? The textbox didn't fill with the value, or it did but you couldn't edit it? The code looks fine for populating the textbox.
 
What is the control source of the textbox? If it's a field, and the source of the form is a query, is the field editable in the query itself? If so, check the enabled and locked properties of the textbox, and the allow edits property of the form.
 
I'm running into a small issue here, and am not sure as to why. I have a combo box which is populated from a 3 column table(Item, Description & Price). The combo selection is supposed to fill 2 text boxes(Description & Price), but only the description text box gets filled. I've set the bound column of description to 1 and the price to 2, but price isn't working. Any thoughts?
 
Make sure the column count property of the combo is 3.
 
Well that was too easy, and i feel a bit on the 'slow' side right now. But thank you. Also, I'm trying to create a daily 'todo' list, that will essentially display all records on a given date. I have a query set up for this, but as of now, it's displaying all records for all dates. Thoughts on this?
 
The column count thing is sort of a hidden "gotcha". A lot of people have had that problem, me included. As to the query, it sounds like you need a criteria on the query to restrict it to a given date, or open a form with this technique:

http://www.baldyweb.com/wherecondition.htm
 
Next Questions:
My subform which has many records, also has a footer, which includes various txt boxes that are linked to a table. When I scroll through the multiple records in the subform, the data in the footer disappears. Now it doesn't disappear all together. From what I have figured out in order for the footer data not to disappear, I would have to enter the information into the footer for each record. Is there a way to apply the footer data to all records in the subform?
 
Could you please create a new thread for this question as it doesn't relate to the subject of the thread. Your question isn't clear too.:)
 
You must log in or register to reply here.

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom