Entering data from a database

[DavidC]

Looking for some help with using an access form to write
notes against tasks, then having those notes able to be
read in MS Project. Reason for this is to provide an
interface for people to add information to custom fields
and the notes field without accessing the project file
directly and potentially adversely affecting the network.

I have been trying to convert the notes back to binary
data by first adding all the formating data before and
after the notes as found when the notes are converted from
binary, then using rtf = StrConv(rtfnotes, vbFromUnicode)
and updating the MSP_TASKS field TASKS_RTF_NOTES with the
resultant binary data, and the field TASK_HAS_NOTES field
to -1, but when MS project is opened the notes do not
show.

Any help would be appreciated.

Regards

DavidC

 

[JackD]

Did you read the entire projdb.htm document? It describes the flags you need
to set for project to accept a change made in the database. If you have not
read it you are working blind. You can find it on your project cd or a
machine with project installed.

-Jack

 

[DavidC]

I had read that part of the file, but somehow at the time
it did not register.

Thanks for the tip it worked.

I had been looking for differences between notes added in
MS Project and notes added through access, and could not
find the differences. Thanks to your help I now see why.

If you were handy I would shout you a drink or two.

Many thanks again

Regards

DavidC