473,322 Members | 1,610 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

notes need to be saved to a table using memo field

Hi,

I have a form with a text box called notes(using memo field type, since it'll be more than 255 field size), so users can enter whatever notes or complaints for a specific products. The problem now is when I clicked the save button for the form, it'll give me an error message saying "the parameter values are too large, parameter can't exceed 1024 characters" the save button cmd that I used is

DoCmd.runSQL "INSERT INTO tblcomplaint (JobID,notes) VALUES(Forms!compaint!txtJObID,Forms!complaint!txt notes)"

Is it because I used insert query to save notes? any other idea on how to save more than 1024 character notes to a table? please help. As you can see, I'm very new to access. Thank you
May 3 '07 #1
4 2078
ADezii
8,834 Expert 8TB
Hi,

I have a form with a text box called notes(using memo field type, since it'll be more than 255 field size), so users can enter whatever notes or complaints for a specific products. The problem now is when I clicked the save button for the form, it'll give me an error message saying "the parameter values are too large, parameter can't exceed 1024 characters" the save button cmd that I used is

DoCmd.runSQL "INSERT INTO tblcomplaint (JobID,notes) VALUES(Forms!compaint!txtJObID,Forms!complaint!txt notes)"

Is it because I used insert query to save notes? any other idea on how to save more than 1024 character notes to a table? please help. As you can see, I'm very new to access. Thank you
Why not simply Bind the Form to tblComplaint and set the Control Source of txtNotes to the [Notes] Field and txtJobID to the [JobID] Field?
May 3 '07 #2
MMcCarthy
14,534 Expert Mod 8TB
Using memo fields is problematic at best. Particularly when trying to use them in queries. Even if you weren't getting this error the chances are your data would be truncated to 255 characters.

General rule with memos:
  • Don't use them at all unless you have to
  • Don't use them in queries
May 4 '07 #3
Using memo fields is problematic at best. Particularly when trying to use them in queries. Even if you weren't getting this error the chances are your data would be truncated to 255 characters.

General rule with memos:
  • Don't use them at all unless you have to
  • Don't use them in queries
Thank you for the response. What's the best field type that I should use for the notes? since the notes will be more than 255 characters and I need to save this on to a table? Please help.
May 4 '07 #4
MMcCarthy
14,534 Expert Mod 8TB
Thank you for the response. What's the best field type that I should use for the notes? since the notes will be more than 255 characters and I need to save this on to a table? Please help.
Memo is the only field that will allow more than 255 characters. The only other option is to use an attached text document and link it to the database using an OLE object field.
May 4 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Bob Weisenburger | last post by:
I have a table of "memos". each record in that table has a primary key "memo ID" that is autonumber. I have another table that is "memo receipts" with each record having a "receipt id" field that...
1
by: Nicole | last post by:
Hello! I hope there is someone out there who can shed some light on this for me. I have a module that is supposed to look at an access table, pull out each bid record, link to another table to...
0
by: Rod Snyder | last post by:
I am trying to extract Notes data from a Project into either a text-delimited file or Access database. When creating the map in project to do this, the data type that is assigned to the Notes...
2
by: Miguel | last post by:
I have a problem in appending notes from a new notes memo field to one that is read-only, i.e., field enabled, but locked. I have seen many messages touching on this subject but cannot find the...
3
by: corear | last post by:
I have a new case tracking system. The cases table has these fields: CaseID (Primary Key) StatusID (looked up in another table - Open, Pending, or Closed) Status Comment (memo field) Date&Time...
1
by: Joe | last post by:
HI Has anyone been able to work with lotus notes automation classes??? Can you post sample code of how to use these classes. I have setup in VB but I am not able to port to C# This is what I...
2
by: Roger | last post by:
I've got two tables in sql2005 which have an 'ntext' field when I linked the first table in access97 last week using an odbc data source the access-field type was 'memo' when I link the 2nd...
10
by: ARC | last post by:
This is mainly a speed question. In this example: I have a QuotesHdr table that has a few memo fields. If these memo fields are used extensively by some users, and if their are a large number of...
2
by: Bob Alston | last post by:
I have a form that is longer than the screen size, so there is a scroll bar to the right of the form. Inside the form there is a memo field that is longer than the height of the screen. It...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.