473,231 Members | 1,340 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,231 software developers and data experts.

Access 2007 Memo Field append only?

ARC
This is taken from the "What's New in Access 2007" page. However, I've
looked through all the properties of a text field memo box, and cannot find
the append only option. Does anyone know how to use this feature?

------------------

"Memo fields are useful for storing large amounts of information. With
Office Access 2007, you can set the Append Only property to retain a history
of all changes to a Memo field. You can then view a history of those
changes. This feature also supports the tracking feature in Windows
SharePoint Services so that you can also use Access to view your SharePoint
list content history."
Aug 4 '07 #1
7 8826
"ARC" <an**@andyc.comwrote:
>This is taken from the "What's New in Access 2007" page. However, I've
looked through all the properties of a text field memo box, and cannot find
the append only option. Does anyone know how to use this feature?
I haven't used that feature myself but is the MDB file in A2007 format?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Aug 4 '07 #2
ARC wrote:
This is taken from the "What's New in Access 2007" page. However, I've
looked through all the properties of a text field memo box, and cannot find
the append only option. Does anyone know how to use this feature?
- In table design, properties of the memo field at the very bottom:
"Append Only" = Yes
- Save / open the table
- Modify the memo field a couple of times.
- Right-click the memo field, last point of the context menu:
"Show column history"

As Tony mentioned, you must be in a new format accdb.

--
Peter Doering [MVP Access]
Aug 4 '07 #3
ARC
Yes it is in the 2007 format, in fact it is in the .accdb format.
"Tony Toews [MVP]" <tt****@telusplanet.netwrote in message
news:en********************************@4ax.com...
"ARC" <an**@andyc.comwrote:
>>This is taken from the "What's New in Access 2007" page. However, I've
looked through all the properties of a text field memo box, and cannot
find
the append only option. Does anyone know how to use this feature?

I haven't used that feature myself but is the MDB file in A2007 format?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Aug 5 '07 #4
ARC
I'm not seeing this option in the table design props. It is in accdb format.
It is a memo field, format is rich text.
"Peter Doering" <no****@doering.orgwrote in message
news:5h*************@mid.individual.net...
ARC wrote:
>This is taken from the "What's New in Access 2007" page. However, I've
looked through all the properties of a text field memo box, and cannot
find
the append only option. Does anyone know how to use this feature?

- In table design, properties of the memo field at the very bottom:
"Append Only" = Yes
- Save / open the table
- Modify the memo field a couple of times.
- Right-click the memo field, last point of the context menu:
"Show column history"

As Tony mentioned, you must be in a new format accdb.

--
Peter Doering [MVP Access]

Aug 5 '07 #5
ARC
Ok, scratch that!

No wonder no-one ever finds this feature!! In table design on the field, the
very last property only is NOT visisible. You have to scroll down one line
to see it. Talk about well-hidden!

"Peter Doering" <no****@doering.orgwrote in message
news:5h*************@mid.individual.net...
ARC wrote:
>This is taken from the "What's New in Access 2007" page. However, I've
looked through all the properties of a text field memo box, and cannot
find
the append only option. Does anyone know how to use this feature?

- In table design, properties of the memo field at the very bottom:
"Append Only" = Yes
- Save / open the table
- Modify the memo field a couple of times.
- Right-click the memo field, last point of the context menu:
"Show column history"

As Tony mentioned, you must be in a new format accdb.

--
Peter Doering [MVP Access]

Aug 5 '07 #6
ARC
Ok, I have it set now. However, when I go to the text box on the bound form,
I can't get it to function. If I type in new stuff, save, then right-click
and show column history, I get a message "Could not find field".
"ARC" <an**@andyc.comwrote in message
news:9f****************@nlpi070.nbdc.sbc.com...
Ok, scratch that!

No wonder no-one ever finds this feature!! In table design on the field,
the very last property only is NOT visisible. You have to scroll down one
line to see it. Talk about well-hidden!

"Peter Doering" <no****@doering.orgwrote in message
news:5h*************@mid.individual.net...
>ARC wrote:
>>This is taken from the "What's New in Access 2007" page. However, I've
looked through all the properties of a text field memo box, and cannot
find
the append only option. Does anyone know how to use this feature?

- In table design, properties of the memo field at the very bottom:
"Append Only" = Yes
- Save / open the table
- Modify the memo field a couple of times.
- Right-click the memo field, last point of the context menu:
"Show column history"

As Tony mentioned, you must be in a new format accdb.

--
Peter Doering [MVP Access]


Aug 5 '07 #7
ARC wrote:
Ok, I have it set now. However, when I go to the text box on the bound
form, I can't get it to function. If I type in new stuff, save, then
right-click and show column history, I get a message "Could not find
field".
I have not seen this message before. Make sure you are in form view (vs.
layout view), or try directly in the table. If that doesn't work either,
try again in a new DB.

--
Peter Doering [MVP Access]
Aug 5 '07 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

28
by: Lee Rouse | last post by:
Hello all, This is going to be a rather lengthy "question". I have an Access 2k database, separated front end/back end. Front end copies are on about 30 workstations and used frequently during...
10
by: mbev | last post by:
I would like to have in a field a big amount of text with a size more than 64K. This field will have text and HTML tags. Is there a way to do this in access? Ok, I may be I need to explain myself...
8
by: doomx | last post by:
I'm using SQL scripts to create and alter tables in my DB I want to know if it's possible to fill the description(like in the Create table UI) using these scripts. EX: CREATE TABLE(...
49
by: Allen Browne | last post by:
If you are looking for opinon on what's useful in Access 2007, there's a new article at: http://allenbrowne.com/Access2007.html Covers what's good (useful features), what's mixed (good and bad),...
13
by: Owen Jenkins | last post by:
Following on from an earlier post... I can reliably corrupt a record by doing the following ... Open two separate but identical front ends on one PC each linking to the same back end. Edit a...
2
by: ACF | last post by:
Hello, Iím trying to format only selected text in an RTF Memo field in Access 2007 Iím able to copy selected text in a Memo field to the Windows clipboard with following code: ...
0
by: Kassimu | last post by:
Hi guys out there, There is this database Iam creating, I have a table with 40 fields among which there are Date/time, Text, Number, Memo and Yes/No fields and I have created the form bound to that...
0
by: Max | last post by:
Hi I am trying to export an Access table to a fixed-width text file. The table contains 2 memo fields of approx. 1000 characters each. I am using the 'Export text wizard' to export. In this...
8
by: pteare | last post by:
Hello, I was wondering if someone might be able to help me. Iím a little stuck as to how to put the results of a query into a memo field. I run a ski chalet company and I have a bookings...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
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: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

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.