update query to memo field from text box

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
 
J

John Vinson

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

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]
 
G

Guest

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
 
J

John Vinson

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;

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top