dde ?

[kari]

i've set up a dde link to excel which works well except when it comes to null
values. if someone using the access form deletes the value in a linked
control, this deletion is not reflected in excel. i think it's just not
recognizing a value to transfer. how can i give value to null controls?

kari

 

[Tim Ferguson]

i've set up a dde link to excel which works well except when it comes
to null values. if someone using the access form deletes the value in
a linked control, this deletion is not reflected in excel. i think
it's just not recognizing a value to transfer. how can i give value
to null controls?

Although I don't know the details of what you are doing, I'd be tempted to
rethink the Excel end of things. What about using excel vba to link
directly to the Jet database? That way any changes to the data will be
visible as soon as the access form is saved, and vice versa.

Must confess that I haven't used DDE for about ten years... <g>

HTH


Tim F