Blazer Saga
Registered User.
- Local time
- Yesterday, 21:21
- Joined
- Jan 22, 2007
- Messages
- 12
Ok. I had an earlier post, http://www.access-programmers.co.uk/forums/showthread.php?t=121599, asking how to get a delete query to run in a form. At that time the field being used to look up the records was a number field. Recently I relised I will need to let them put letters into the field and so I switched the field to text all tables where it was referanced, and now the same query doesnt work. Instead I get an Error 3464. I have tested changing them back to numbers, and it will work again if I do so. Is there somthing in the folowing Query As String code that I need to change?
"DELETE [Numbers Catagory].[Order ID], [Numbers Catagory].* FROM [Art Sheets] INNER JOIN [Numbers Catagory] ON [Art Sheets].[Order ID] = [Numbers Catagory].[Order ID] WHERE ((([Numbers Catagory].[Order ID])=" & [Forms]![Art Sheet]![Txt Order ID] & "));
Where:
Art Sheet is the table the main form is based off of
Numbers Catagory is the table the sub form is based off of
Order ID is a field in Numbers Catagory not diplayed but selected in the sub form
Txt Order ID is a field displayed on Art Sheet and has the control source of Order ID from the Art Sheet table
Both Order IDs are type text with lengths of 8 and are linked in the relationships view, enforced, both cascades, and one to one.
The folloing seems to be a similar problem, but I am unable to figure out how to aply that to what I am doing.
http://www.access-programmers.co.uk/forums/showthread.php?t=46294&highlight=Error+3464+text+field
"DELETE [Numbers Catagory].[Order ID], [Numbers Catagory].* FROM [Art Sheets] INNER JOIN [Numbers Catagory] ON [Art Sheets].[Order ID] = [Numbers Catagory].[Order ID] WHERE ((([Numbers Catagory].[Order ID])=" & [Forms]![Art Sheet]![Txt Order ID] & "));
Where:
Art Sheet is the table the main form is based off of
Numbers Catagory is the table the sub form is based off of
Order ID is a field in Numbers Catagory not diplayed but selected in the sub form
Txt Order ID is a field displayed on Art Sheet and has the control source of Order ID from the Art Sheet table
Both Order IDs are type text with lengths of 8 and are linked in the relationships view, enforced, both cascades, and one to one.
The folloing seems to be a similar problem, but I am unable to figure out how to aply that to what I am doing.
http://www.access-programmers.co.uk/forums/showthread.php?t=46294&highlight=Error+3464+text+field