Board index » Visual Basic&database
All times are UTC
The following code is generating the error message 3075 (Syntax error in query expression):
SQL_Stat = "UPDATE Mailings SET [Mailing_Fields] = '" & Sats & "' WHERE [Mailing_Name] = '" & Text2.Text & "'" Dbase.Execute SQL_Stat
The field Mailing_Fields is defined as a memo field.
Any suggestions would be grateful
Axel Bendix
1. 2nd SQL Server update after update text field corrupts row - using RDO
2. ADO/SQL - Updating large memo field
3. Updating Memo Fields in MS Access using ADO Parameter / Stored Procedures
4. Using VB 3.0 to Update DBase III Memo Field
5. Updating Memo Fields in MS Access using ADO Parameter / Stored Procedures
6. ADO Update (using VB) of Memo fields in Access 97 DB
7. Populating memo field using update query from VB5
8. Update Oracle data using Data control and SQL?
9. Using--After Update-- to update field in table.
10. How to update datetime field with NULL using ADO update
11. Using Update to update an Access field
12. Problem updating memo field
Updating data to a memo field using SQL UPDATE