Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
other
informationbridge
office.intranets
office.misc
office.setup
office.xml
officeupdate
onenote
photodraw.discussion
powerpoint
producer
proj.standard&server
project
project.developer
project.pro_and_serve
project.server
project.vba
project2000
publisher
publisher.prepress
publisher.programming
publisher.webdesign
visio
visio.createshapes
visio.database.modeling
visio.dev.diagrams
visio.dev.shapesheet
visio.dev.vba
visio.dev.vc
visio.developer
visio.general
visio.installation
visio.printing
visio.software.modeling
visio.troubleshoot
  
 
date: Fri, 19 Sep 2008 06:39:01 -0700,    group: microsoft.public.project        back       


Notes field in Access   
Hello,

I have saved my project in MS Access.  Which table  contains the actual 
notes attched to a task.  I have found a field that refers to the notes but I 
do not see the content itself.  How can I extract this data?

Thanks
date: Fri, 19 Sep 2008 06:39:01 -0700   author:   sK

Re: Notes field in Access   
Hi sk,

See the PJDB.HTM file on your computer which describes the Project 
data schema.  Search the file for Notes and you'll find some VB code 
to extract the information from the Rich Text Notes field.  I 
suggest posting any follow up questions to the Project developer 
newsgroup as needed.  You may also try a google group search on the 
developer newsgroup to see if someone has posted some code.

I hope this helps.  Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional 
information about Microsoft Project

"sK"  wrote in message 
news:C56B89A8-D64F-4158-BF55-71B05C36942C@microsoft.com...
> Hello,
>
> I have saved my project in MS Access.  Which table  contains the 
> actual
> notes attched to a task.  I have found a field that refers to the 
> notes but I
> do not see the content itself.  How can I extract this data?
>
> Thanks
date: Fri, 19 Sep 2008 17:52:18 -0400   author:   JulieS

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us