Lost control sources of special controls

[nagyf]

I have suffered for the second time from lost control sources of non-standard controls:
1) Calendar,
2) Rich Text.
I have Access 97.
In both cases I have a designed a form bound to a query.
I have placed such control to the form
1) to edit date filelds
2) display text with upper and lower index.

One day I had put the field name of the underlying query in the design view into the ControlSource property of the the control.
Next day I have corrected something else, or I have just saved the form.

On the the third day I printed out the form, and it did not contain the formatted text of the rich text box.
The dates entered in the calendar control are lost.

Rich text boxes on reports behave the same way.

When I have checked the ControlSource it was EMPTY!


Oh Hewlett-Packard's good old RELIABLE TuboImage and HiLi!

Why does allow $&*^#ed Access special controls of it does not handle them propertly? [tt]
Ferenc Nagy
|\ /~ ~~|~~~ nagyf@alpha0.iki.kfki.hu Fax: (36-1)-392-2529 New!
| \ | | Institute of Isotope and Surface Chemistry
| \ | -+- 1525 Bp. POB 77. Tel. 36-1)-392-2550
| \| |

http://alpha0.iki.kfki.hu/~nagyf

`-' ' `-' "The goal of the life is the struggle itself"
[/tt]

 

[BillPower]

Compact you DB, zip it up and send it to me. billpower@cwcom.net I'll have a look at it tonight and post any results here as soon as I can. There's a myriad of things it could be.

Regards

Bill

 

[nagyf]

Hi Bill,
I send you this letter to you to your private e-mail, too.
The attachment is not a complete database and it is too big for such a forum.

In the newest tables " ... gazdag ..." you can find a list of the RichText
controls and their control sources. My solution to the problem: I defined
the property "Eredeti neve" (="Its original name&quot for reports and forms,
so you can deliberately rename them. The subroutine restore_rtf_sources is
intended to restore the last ControlSource settings using the
"...gazdag..." tables and the "Gazdag ..." union query.

I must not send you the complete database.
I have not time to translate the comments and variable names.
Regards
Frank [tt]
Ferenc Nagy
|\ /~ ~~|~~~ nagyf@alpha0.iki.kfki.hu Fax: (36-1)-392-2529 New!
| \ | | Institute of Isotope and Surface Chemistry
| \ | -+- 1525 Bp. POB 77. Tel. 36-1)-392-2550
| \| |

http://alpha0.iki.kfki.hu/~nagyf

`-' ' `-' "The goal of the life is the struggle itself"
[/tt]

 

[nagyf]

Biil, I have tried to send to you the text with attachments twice. NF [tt]
Ferenc Nagy
|\ /~ ~~|~~~ nagyf@alpha0.iki.kfki.hu Fax: (36-1)-392-2529 New!
| \ | | Institute of Isotope and Surface Chemistry
| \ | -+- 1525 Bp. POB 77. Tel. 36-1)-392-2550
| \| |

http://alpha0.iki.kfki.hu/~nagyf

`-' ' `-' "The goal of the life is the struggle itself"
[/tt]