Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / February 2006

Tip: Looking for answers? Try searching our database.

In Access Memo Cells How format single line entries ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Art at Vanliner - 24 Feb 2006 20:39 GMT
I need to set properties on a Memo Cell to enter data that is a list, Ex
"date, notes"
"date, notes"
"date, notes"
"etc."
Just like I was just able to do in this "message" box, one item under the
other?
Rick B - 24 Feb 2006 21:34 GMT
Well, Access does not have "cells" - that is an Excel term.

But, what you are trying to do is not the "best" way to do this in Access.
You are trying to enter a "new" not in an existing field.  That violates
Access normalization rules.  If you want to track notes and include a time
or date, you need a new table.  Access is a *relational database* which
means that data should be stored in separate tables that are *related* to
each other using keys in the various tables.

If these notes apply to a particular client, for example, your tables might
look like this...

TblClientData
ClientNumber
ClientName
ClientAddress1
ClientAddress2
ClientCity
ClientState
ClientZip
etc.

You'd have a seperate table for "notes" or "calls" or "contact" with the
client....

TblClientCalls
ClientNumber
CallDate
CallTime
CallDuration
CallDetails

In this scenario, a client would have one record in the TblClientData.  If
they had been called ten times, they'd have ten records in the
TblClientCalls.

In your forms and reports, you'd create a main section with the client
details.  You'd have a subform or subreport with the call details.

Now, all that being said, Access has many template databases available on
their website for free.  I think there is one called "contact management"
that I have used many times as a starting point for my databases.

I'd recommend you take a look at the samples and use those as your starting
structure.

Signature

Rick B

>I need to set properties on a Memo Cell to enter data that is a list, Ex
> "date, notes"
[quoted text clipped - 3 lines]
> Just like I was just able to do in this "message" box, one item under the
> other?
Art at Vanliner - 24 Feb 2006 23:37 GMT
Rick B;

Thanks for the response.  Your reply puts me on the right track thanks for
answering....

> Well, Access does not have "cells" - that is an Excel term.
>
[quoted text clipped - 49 lines]
> > Just like I was just able to do in this "message" box, one item under the
> > other?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.