update query to memo field from text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello-

I am trying to update a memo field from a text box. I seem to be only update
up to 127 characters and after 127 I get 'Invalid Argument'. Any ideas? This
query contains no distincts or group bys... very simple

Thanks, ajridle
 
Hello-

I am trying to update a memo field from a text box. I seem to be only update
up to 127 characters and after 127 I get 'Invalid Argument'. Any ideas? This
query contains no distincts or group bys... very simple

Thanks, ajridle
Click to expand...

If there is any Format clause either on the table field, the query
field, or the form control, remove it; formatting also truncates memo
fields.

John W. Vinson[MVP]
 
I don't have any formating clauses and through testing, I've found the date
and time functions are not affecting the query as well. here is the query...

INSERT INTO Prospect ( [Next Action Date], [Latest Update], [Next Steps],
[SDT Contact], SMR )
SELECT Date() & " " & Time() AS Expr1, [Forms]![UpdateReport]![nxt] AS
Expr2, [Forms]![UpdateReport]![nxt] AS Expr3,
[Forms]![UpdateReport]![ContactLast] AS Expr4,
[Forms]![UpdateReport]![Projects_SMR] AS Expr5;

i also have an append query with the same problem.

INSERT INTO Prospect ( [Next Action Date], [Latest Update], [Next Steps],
[SDT Contact], SMR )
SELECT Date() & " " & Time() AS Expr1, [Forms]![UpdateReport]![nxt] AS
Expr2, [Forms]![UpdateReport]![nxt] AS Expr3,
[Forms]![UpdateReport]![ContactLast] AS Expr4,
[Forms]![UpdateReport]![Projects_SMR] AS Expr5;


thanks for your help,ajridle
 
I don't have any formating clauses and through testing, I've found the date
and time functions are not affecting the query as well. here is the query...

INSERT INTO Prospect ( [Next Action Date], [Latest Update], [Next Steps],
[SDT Contact], SMR )
SELECT Date() & " " & Time() AS Expr1, [Forms]![UpdateReport]![nxt] AS
Expr2, [Forms]![UpdateReport]![nxt] AS Expr3,
[Forms]![UpdateReport]![ContactLast] AS Expr4,
[Forms]![UpdateReport]![Projects_SMR] AS Expr5;

i also have an append query with the same problem.

INSERT INTO Prospect ( [Next Action Date], [Latest Update], [Next Steps],
[SDT Contact], SMR )
SELECT Date() & " " & Time() AS Expr1, [Forms]![UpdateReport]![nxt] AS
Expr2, [Forms]![UpdateReport]![nxt] AS Expr3,
[Forms]![UpdateReport]![ContactLast] AS Expr4,
[Forms]![UpdateReport]![Projects_SMR] AS Expr5;
Click to expand...

A SELECT query should select from a table, not from a Form!

Is there some reason you're doing this as an Append Query rather than
using a bound form?

If you want to do so try using the Values() syntax:

INSERT INTO Prospect ( [Next Action Date], [Latest Update],
[Next Steps], [SDT Contact], SMR )
VALUES
("#" & Format(Now(), "mm/dd/yyyy hh:nn:ss") & "#",
[Forms]![UpdateReport]![nxt],
[Forms]![UpdateReport]![nxt],
[Forms]![UpdateReport]![ContactLast],
[Forms]![UpdateReport]![Projects_SMR])



John W. Vinson[MVP]
 
Back
Top