Additional information or notes

Resolved · Medium Priority · Version 2007

Risha has attended:
Access Introduction course

by - delegate Risha [1 post] (2008 Jul 29 Tue, 10:41) Reply

What is your advice on the best way to add meeting and information notes to a record - just to add a large text field? Would you be able to search on that?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Additional information or notes

by - trainer Richard platinum contributer [818 posts] (2008 Jul 29 Tue, 11:03) Reply

Hi Risha

Thank you for your question regarding adding a notes field.
Yes, I would recommend what you have suggested as a viable way of recording meeting and information notes on a record. You have over 16,000 characters in a MEMO field, and you can search on it.

Remember to set the field data type to MEMO, other wise you will be limited to 255 Characters in a text field.

Let me know it goes, and if this suits your requirements.

Kind regards

Richard
Microsoft Office Specialist Trainer

· Quick Microsoft Access Course: Creating an Inventory Control Database in 8 Simple Steps
· How To Find Good Access Database Courses In London
· How Reorganising Your Data Can Take Your Business to the Next Level
· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database

Please browse our web site to find out more about
microsoft access training and other Microsoft training courses.

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips