text fields to memo field
Is there a way to combine text fields into one memo field?
This is an existing database. Some people in the database may have several
"contact" entries where they have a "note" in a text field. I would like to
figure a way to combine all the "note" fields for each person into one memo
"RR" <email@example.com> wrote in message news:<S6HRb.firstname.lastname@example.org>...
> Is there a way to combine text fields into one memo field?
> This is an existing database. Some people in the database may have seve...Moving text from alpha fields to memo/formatted memo field
I have a small app where I have a few alpha fields for text comments. Now I
would like to change these fields to one memo or formatted memo field. How?
I have tried and managed to move texts in ascii-format with delimiters and
separators useing TextStream. I have also managed to import, by
importAsciiVar, it back to paradox table but not in memo or f-memo fields,
only in alpha field. The problem is that the length of alpha field is only
255 chars and I would need more, not moch but a little.
You have some tricks, I'm sure, so would you tell me too.
Thanks and greetings ...Forcing a New Line in a Text Field in MS Access using VB
I feel I'm beating an old horse to death with this question but I
can't get around the problem.
I want to update a text field on a form with a string from a VB
module. I need enter/linefeeds in the string.
Chr(10) & Chr(13)
Chr(13) & Chr(10
none of which seem to work.
I've set the properties for the text box to [Enter Key Behavior] =
'New Line In Field' and [Can Grow] = 'yes'.
At the moment, my code looks like this:
celsql = celsql _
& "Program: " & encname _
& vbCrLf _
& vbCrLf _
& "Start Time: " & sttim _
& vbCrLf _
& "Participants: " & numpart _
& vbCrLf _
& "Confirmed by Curator: " & cbc _
& vbCrLf _
& "Client: " & clntnm _
& vbCrLf _
& "Contact: " & cntct _
& vbCrLf _
Forms(frm)(bts) = celsql
If I toss this string into a [MsgBox], it comes out fine. It's just
something about the text field...
I'm working in MSAccess 2007, but need it backwards compatible to
I'd really appreciate any advice.
I've seen this type of problem before, but I typically just use a
separate text box for each data field. Is there a par...MS Qry and text field to date field
I am using MS Query to pull files (from IBM AS400) and put them in
Excel. However, when I do this the dates are now text fields. The text/
Date field looks like this: 20070331 (YYYYMMDD)
I would like the change this text to a date field so Excel will see
it as a date.
Can someone please help me? I have looked all over the place for a
solution and I have found nothing.
Also, if you know of a good place to get information on MS query
please let me know.
> I am using MS Query to pull files (from IBM AS400) and put them in
> Excel. However, when I do this the dates are now text fields. The text/
> Date field looks like this: 20070331 (YYYYMMDD)
> I would like the change this text to a date field so Excel will see
> it as a date.
> Can someone please help me? I have looked all over the place for a
> solution and I have found nothing.
> Also, if you know of a good place to get information on MS query
> please let me know.
In Access you could use DateSerial. Ex:
...MS Access Memo Fields
I am a novice at Access (2002) and I need some help. I want to use a
query to interrogate a memo field which contains the body of an email
but despite help with the syntax etc. I can not get it to return any
Can anyone tell me if there are limitations using queries on Memo
fields? For example, do they just look at the first 255 characters,
all the field contents or just not work at all
The query I am running is:
WHERE ucase(Emails.MessageTxt) Like '%BUY%' Or
ucase(Emails.MessageTxt) Like '%SELL%'
ORDER BY Emails.[Message#];
I was also unsure whether the Like function is case sensitive
<email@example.com> wrote in message
> I am a novice at Access (2002) and I need some help. I want to use a
> query to interrogate a memo field which contains the body of an email
> but despite help with the syntax etc. I can not get it to return any
> Can anyone tell me if there are limitations using queries on Memo
> fields? For example, do they just look at the first 255 characters,
> all the field contents or just not work at all
> The query I am running is:
> SELECT Emails.*
> FROM Emails
> WHERE ucase(Emails.MessageTxt) Like '%BUY%' Or
> ucase(Emails.MessageTxt) Like '%SELL%'
> ORDER BY Emails.[Message#];
> I was also unsure whether the Lik...Accessing text form fields name=field[label]
and changing those examples to suit my needs. That said ....
..... I have some select fields in a form I created for a database search
that I am unable to figure out how to access. (The search is
implemented in Php/MySQL.)
The user enters search values for: name, address1, city, .... etc.,
..... and for each of these they also select whether the search should
look for the field to be equal to, not equal to, Like, or Not Like the
value in the database.
So in the form I have:
<input type=text name=city>
in combination with
<option value='!='NOT LIKE>NOT LIKE</option>
For an example, this search could be to find an entry "WHERE city
$func[city]] $city. (Php - e.g., WHERE city = 'Denver'). This works
fine - in Php. I use similar combinations for name, address, etc., ...
selected indexes for the "func" fields (func[name], func[city],
func[state], ...) using a loop that goes through the associative array,
"func." I cannot find the right syntax to address them as an array and
I am beg...MS Access Memo field question?
Hi I was wondering is it possible to read write to a memo field in ms
access, the same way you would read write to a text field? I have my
database set up and reading writeing to the databse ok using text field
but I have to now store strings which will contain 316 characters e.g
I need to do it beacuse Im encrypting ever thing in the database,
Thank if you can help
...access97, sql2005 memo field in a linked table shows as a text field
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 table today, it is linked as a text(255) field,
ditto for the first table if I link it today
if I link the 2nd table using access2003 (and the same odbc data
source) it is linked as a memo field
I don't think anything was changed on sql2005 or access97 since
linkage of the first table produce the correct field type
does anyone know what is required to get access97 to link a memo
On Aug 21, 12:59 pm, Roger <lesperan...@natpro.com> wrote:
> 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 table today, it is linked as a text(255) field,
> ditto for the first table if I link it today
> if I link the 2nd table using access2003 (and the same odbc data
> source) it is linked as a memo field
> I don't think anything was changed on sql2005 or access97 since
> linkage of the first table produce the correct field type
> does anyone know what is required to get access97 to link a memo
> field ?
If I change the sql table field from 'ntext' to 'text' and relink, the
access field is now 'memo', but when I display the...SQL Server View integer field shows as text field in Access
I have an SQL Server View where my field in the view is an integer
field and works well. When I link to it from Access, the field is
defined as a text field in Access.
Does anyone have any idea why this is happening or how to fix it?
Thanks in advance!
On Sun, 3 Aug 2008 20:31:43 -0700 (PDT), kevinfbutt
That's quite unusual. Can you post the SQL for that field in that
What version of Access and SQL Server? Fully patched?
Can you replicate the problem with a view in one of the SQL Server
Microsoft Access MVP
>I have an SQL Server View where my field in the view is an integer
>field and works well. When I link to it from Access, the field is
>defined as a text field in Access.
>Does anyone have any idea why this is happening or how to fix it?
>Thanks in advance!
Is the column in the view the result of a calculation? If so, try applying
the CAST or CONVERT function to coerce the result back into an integer.
"kevinfbutt" <firstname.lastname@example.org> wrote in message
> Hi All!
> I have an SQL Server View where my field in the view is an integer
> field and works well. When I link to it from Access, the field is
> defined as a text field in Access.
> Does anyone have any idea why this is happening or how to fix it?
>...Access treating Memo like a Text field
I have an web app and I am using access 2002 and VB.net. I am using a
data adapter to fill a dataset.
I am retrieving product descriptions, some are long and i have used a
field of memo datatype to save them in.
The problem is sometimes I can only retrieve the first 255 characters
in a memo field and other times I can retrieve the full product
descriptions which can be over 640 charaters.
The problem is consistent, the same fields are always truncated to 255
characters and the others are always displayed in full.
Has anyone heard of this before? Any ideas on where I can look?
Thanks ...multiple conditions in a join, access doesn't like on (table1.field=table2.field and table1.field=table3.field)
Hi I have written the following query and am having problems with the
last outer join in ms access... it doesn't like the multiple
conditions that I have in there, if I have just one or the other its
OK but not both... and I have tried putting the second condition in a
where clause but then i don't get an outer join
i'm pulling my hair out on this one... i would be extremely greatful
for some ideas...
SELECT ro.thickness,ro.width,ro.grade,sum(ro.pcs) as pieces,
FROM(((NewOrders as RO
LEFT OUTER JOIN Grades as GR on GR.gradename=ro.grade)
LEFT OUTER JOIN thicknesses as t on t.imperialdecimal=ro.thickness)
LEFT OUTER JOIN GradeThicknessGroups as GT on
LEFT OUTER JOIN GradeThicknessGroupDetail as GTD on
GROUP BY ro.thickness,ro.width,ro.grade,
Order By ro.thickness,ro.width
my tables looks like this
ThicknessID (FK: [Thickness])
GradeID (FK: [Grade])
oops i left the where statement in.. r...How to link fields in MS word document to Access database
Anyone have experience in linking fields in an MS Word document to an
What I am considering doing is taking an existing fill-in-the fields
word document, for which I cannot now save the data, and allow it to be
opened with no data, have the fields filled in and then save the data in
an Access database. I also want to later select the document (from a
file in the database), open the word document and populate the fields
from the database. Of course if there are then any updates I want to
put them back into the database.
Anyone with sample code?
On Jun 10, 6:21=A0pm, Bob Alston <bobalst...@yahoo.com> wrote:
> Anyone have experience in linking fields in an MS Word document to an
> access database?
Instead of Word documents I use RTF-documents. RTF-documents act just
like Word documents in Word. The difference is that RFT-documents are
plain text-files, and can easily be processed in Access to find - with
the appropriate placeholders - the filled in information.
> What I am considering doing is taking an existing fill-in-the fields
> word document, for which I cannot now save the data, and allow it to be
> opened with no data, have the fields filled in and then save the data in
> an Access database. =A0I also want to later select the document (from a
> file in the database), open the word document and populate the fields
> from the database. =A0Of course if there are then ...Copying and pasting into a memo field
I have a pretty straightforward database that is designed to record
free-form information about products (date, source and a memo field).
This is searched and updated via a form. For new records, the memo
field is usually filled by cutting and pasting from e-mails, web
content and spreadsheets.
The only problem is that some of the memos can be just a few words,
and some can be tens or hundreds of lines, and I've realised that
zooming matching fields one by one is very tedious!
Ideally I'd like to make the form detect multiple line memo fields,
and break them up so that it enters in...Strip data in clipboard to text only so that it may be pasted into memo field
I have a form with a large memo field that is designed to hold lengthy
comments. There are times when my users need to paste in e-mails
directly into the comment box. This works fine unless their e-mail
contains attachments, pictures, etc. In the event that their copy
action captured something other than text than nothing happens when
they try and paste into the comment field.
I considered handling this with an imbedded OLE object, but the
application already houses 10,000 comments, and will eventually house
around 30-40k in the near future. My thoughts are that this would be
way too big.
I'm wondering if there would be a method to 'clean' the object in the
clipboard so that it contained only text. I'm guessing this would
require some sort of API call, but I'm not sure how to go about making
something like that. I was wondering if anybody had seen some existing
code that did something similar.
I am currently using A97 with Win2k. In about a month we are scheduled
to all have Win XP with Office 2003, and already half of the users
using this have the upgraded version. I am not sure if this newer
version of Access will provide additional tools to make this easier.
Thanks in advance
On 31 Oct 2006 15:37:28 -0800, Andy_Khosravi@bcbsmn.com wrote:
>I have a form with a large memo field that is designed to hold lengthy
>comments. There are times when my users need to paste in e-mails
>directly into the comment box. This works fine unless the...HELP! Retriving field names and properties from MS Access database using ASP
I have a really frustrating error and need help.
I’m trying to do a function that gets the properties and names
of the fields in a MS Access database using ASP. I haven’t
programmed in a while so I’m quite lost.
Once I have the my database structure I will insert the corresponding
fields from a web form but the database is huge and I want to be able
to change the database and form without changing the ASP code all the
This is my function that is not working yet. I cant seem to connect
properly to the database...
...Get the real type of columns from MS Access databases(OLEObject, text, memo, numeric)
I made one application that opens MS Access databases.And I have one
problem.How can I find the real data type of columns(text, memo,
OLEObject, numeric) like it is into Access.I tried with
resultSetMetaData.getColumnType(columnIndex) but I receive
java.sql.Types.I have two columns that contains OLEObjects(images).But
I receive two different types for columns : VARCHAR once, and for
second column SMALLINT.I only want to see the types like in
Access(OLEObjects, Text, Numeric, Memo...).Thanks in advance!
...Changing Text Field to ported field
I did a search, and maybe I'm looking things up using the wrong
criteria. I apologize if this has been discussed before, and if it
has, please let me know where to find it. Thanks.
Our users are currently entering in all SW code associated with a
problem into a text field, using paragraph returns or comma's as
To make metric gathering more useful, I created a child database to
collect the SW mods individually (with all the details that go with
them), and have created portal on my main database to this child
database so that they can enter in the ..."Record Deleted" error when appending to a memo field from a memo field
I found what is causing the error by removing various fields from the
Append Query. I also get the error when doing an INSERT INTO.
I do not get the error if I do not list the memo field in the Insert
or have it in the Append Query.
This is not happening with the same field in another query (but I need
to check that again).
Any ideas why I am getting the "Record Deleted" error? No records end
up getting written to the destination table.
I know it used to work.
On Tuesday, October 13, 2015 at 1:46:58 PM UTC-4, PW wrote:
> I found what is causing the error by removing various fields from the
> Append Query. I also get the error when doing an INSERT INTO.
> I do not get the error if I do not list the memo field in the Insert
> or have it in the Append Query.
> This is not happening with the same field in another query (but I need
> to check that again).
> Any ideas why I am getting the "Record Deleted" error? No records end
> up getting written to the destination table.
> I know it used to work.
Are you sure the fields in both tables are the same?
What happens if you update record by record?
Dim r as recordset
Dim r1 as recordset
set r = currentdb.openrecordset("Table1",dbopensnapshot)
set r1 = currentdb.openrecordset("Table1",dbopenDynaset)
Do while not r.eof
r1!Field1 = r!Field1
...Changing drop-down field to text field.
I am working on creating an editable grid (for use in adding,
deleting, and editing rows back to an Oracle database). I have a JSP
that posts back to a servlet, which in turns posts to a WebLogic SFSB
and, from there, to the database.
On the front end, all cells appear as text fields. However, for
certain cells, when the user clicks on the cell, the text field turns
into a drop-down field (i.e. Select object), defaulting to the value
in the text field (unless the field is blank, in which case the
drop-down defaults to the first entry in the drop-down). Once the
user has selected a new en...How to convert Number Field to Text Field
I'm newbie in Filemaker, currently I'm using Filemaker pro v 6.01 on
Windows XP. I have a small problem. I'm trying to make a solution for
Hotel Rate. I want to change the USD. 0.00 to "Included" for breakfast
rate which already included in the room rate.
Anybody can help, will be much appreciated.
"Adhie" <email@example.com> wrote in message
> I'm newbie in Filemaker, currently I'm using Filemaker pro v 6.01 on
> Windows XP. I have a small problem. I'm trying to make a ...Linking A Text Field With A Number Field
Is there any way to link a field I'll call StudentId in Table1 with
StudentId in Table2? In Table1, StudentId is a number and in Table2
it's a text field. The values match up fine so other than one being a
number and the other a text field, everything else would be okay. I
know I can create an append query to copy, say, Table2 to e.g. Table3
and make StudentId a number field in Student3 but wondered if there's
a more "elegant" solution.
On Mar 6, 11:42=A0am, Sheldon <SHPsalm...@aol.com> wrote:
> Is there any way to link a field I'll call StudentId in Table1 with
> StudentId in Table2? =A0In Table1, StudentId is a number and in Table2
> it's a text field. =A0The values match up fine so other than one being a
> number and the other a text field, everything else would be okay. =A0I
> know I can create an append query to copy, say, Table2 to e.g. Table3
> and make StudentId a number field in Student3 but wondered if there's
> a more "elegant" solution.
> Sheldon Potolsky
You could use Cstr() or Clng() functions - depending on which side
you're doing the connection. If you are going from a number to text
convert it to Text with a Cstr() or vice versa.
> Is there any way to link a field I'll call StudentId in Table1 with
> StudentId in Table2? In Table1, StudentId is a number and in Table2
> it's a text field. ...concatenating 2nd field if 1st field is same #2
I have a file:
I am using awk with input field separator as ":"
I want to concatenate field 2 of every record that has the same field
The final contents of the processed file should look like:
Any guidance is highly appreciated.
In article <firstname.lastname@example.org>,
<email@example.com...Create date field from substring of text field
I am trying to populate a field in a SQL table based on the values
returned from using substring on a text field.
Field Name = RecNum
Field Value = 024071023
The 7th and 8th character of this number is the year. I am able to
get those digits by saying substring(recnum,7,2) and I get '02'. Now
what I need to do is determine if this is >= 50 then concatenate a
'19' to the front of it or if it is less that '50' concatenate a '20'.
This particular example should return '2002'. Then I want to take the
result of this and populate a field called TaxYear.
Any help would be greatly apprecaietd.
Assuming both RecNum and TaxYear fields are in the same table, you can use
this script to populate TaxYear:
set TaxYear = case
when SubString(RecNum,7,2) >= '50' then '19' +
else '20' + SubString(RecNum,7,2)
"Mark" <markcash@Hotmail.com> wrote in message
> I am trying to populate a field in a SQL table based on the values
> returned from using substring on a text field.
> Field Name = RecNum
> Field Value = 024071023
> The 7th and 8th character of this number is the year. I am able to
> get those digits by saying substring(recnum,7,2) and I get '02'. Now
> what...update text field based on selection field
ok, this is gonna seem stupid, but it has been stumping me all
I have two fields on a HTML page. HTML looks like this...
<title>New Page 3</title>
<form method="POST" action="index.asp">
<option selected>SELECT ONE</option>
<option value="3">GROUND (3 DAY)</option>
<option value="2">2ND DAY AIR (2 DAY)</option>