B
Biggles
I am trying to copy data from a field type OLE Object to the same field in a
master version of the database. I don't think I should have to do any
converting, but I am stuck. Here is the full story.
In Project, the notes field for an assignment is an image field, an RTF
notes field. Since I am using a Project database as my backend, I am able to
see the field type is OLE Object. I am using VBA to bring a distributed copy
of my project database file back into the master. I need to copy these
notes. If I perform a select query that includes the field in question
(RS_ASSIGN_OLD!ASSN_RTF_NOTES), and then try to write that into a ssql Update
query:
ssql = "UPDATE MSP_ASSIGNMENTS SET ASSN_RTF_NOTES = " &
RS_ASSIGN_OLD!ASSN_RTF_NOTES
That would make sense to me. However, I get errors and my ssql looks like
(some other fields have been deleted):
?SSQL(14)
UPDATE MSP_ASSIGNMENTS SET ASSN_RTF_NOTES =
??????????????????????????????????????‰????????????????????????????????????????????????????? ????? ??????? ? ? ??? ???????? ? ?? ??? ??????? ? ??
Do I need to do something to the field to make this work?
master version of the database. I don't think I should have to do any
converting, but I am stuck. Here is the full story.
In Project, the notes field for an assignment is an image field, an RTF
notes field. Since I am using a Project database as my backend, I am able to
see the field type is OLE Object. I am using VBA to bring a distributed copy
of my project database file back into the master. I need to copy these
notes. If I perform a select query that includes the field in question
(RS_ASSIGN_OLD!ASSN_RTF_NOTES), and then try to write that into a ssql Update
query:
ssql = "UPDATE MSP_ASSIGNMENTS SET ASSN_RTF_NOTES = " &
RS_ASSIGN_OLD!ASSN_RTF_NOTES
That would make sense to me. However, I get errors and my ssql looks like
(some other fields have been deleted):
?SSQL(14)
UPDATE MSP_ASSIGNMENTS SET ASSN_RTF_NOTES =
??????????????????????????????????????‰????????????????????????????????????????????????????? ????? ??????? ? ? ??? ???????? ? ?? ??? ??????? ? ??
Do I need to do something to the field to make this work?