Procedure Attributes

[ken]

Hi,
How can I get to the Procedure Attributes window? According to
documentation its in the tools menu of the MS Access VB editor. I can't
find it...its not there...

I'm using Access 2000.

If anyone knows how I can get to it I will really appreciate an answer.

Thank you.

[ken]

anyone? I'm trying to bind an axtivex control to a memo field. I found
directions on how to do this, but they involve going into the procedure
attributes window....

Thanks.

[Randy Harris]

"ken" <ge****@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

anyone? I'm trying to bind an axtivex control to a memo field. I found
directions on how to do this, but they involve going into the procedure
attributes window....

Thanks.

I think you should check that documentation again. AFAIK there's no such
thing as a "Procedure Attributes" window.

[DFS]

ken wrote:

anyone? I'm trying to bind an axtivex control to a memo field. I found
directions on how to do this, but they involve going into the
procedure attributes window....

Thanks.

You're probably thinking of the Object Browser window.

[ken]

No I mean the Procedure Attributes, maybe not window, but menu. I found
it in this post:
http://groups.google.com/group/comp....d767b3555c4da1

check it out...its the 5th message by S. Lebans.

[DFS]

ken wrote:

No I mean the Procedure Attributes, maybe not window, but menu. I
found it in this post:
http://groups.google.com/group/comp....d767b3555c4da1
check it out...its the 5th message by S. Lebans.

Duh... I should have remembered that - it's a Visual Basic feature - not
part of Access.

[Randy Harris]

"ken" <ge****@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...

No I mean the Procedure Attributes, maybe not window, but menu. I found
it in this post:
http://groups.google.com/group/comp....d767b3555c4da1
check it out...its the 5th message by S. Lebans.

He was referring to a Procedure Attributes window in VB, not in Access.

[ken]

So...how would I open this up in VB...? Do I have to open the activex
control and configure it for my access database?

[Randy Harris]

"ken" <ge****@gmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...

So...how would I open this up in VB...? Do I have to open the activex
control and configure it for my access database?

I'm not entirely certain. I take it you didn't get instructions with the
control?

If the control is already developed, perhaps it's a simple matter of copying
a file into place, then going into Tools->References and setting a reference
for it.

[ken]

The control is DHTML edit control for IE 5.0. It comes with access. I'm
trying to bind it to a memo field. I found out by trial/error that the
property DocumentHTML contains the html code of what you type into the
control. Unfortunately on form close when I want to do:
MyMemoField=ActivexCtl0.DocumentHTML
I get an error saying that "object doesn't support this property or
meathod". However if I put the above code into a push button, then it
works?

Anyhow, it would be nice if I could bind this to the memo field so this
happens automatically.

If I can't get this to work, I guess I'll have to use the rich text
control.

I tell you though, there is not a lot of documentation on this guy...

Thanks for replying.

[Stephen Lebans]

Did you not download the sample VB project? I thought it came within the
control's archive but it's been a long time since I looked at this control.

To understand how to access the proper interface of the control see a
similiar sample project here:
http://www.lebans.com/htmleditor.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"ken" <ge****@gmail.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

The control is DHTML edit control for IE 5.0. It comes with access. I'm
trying to bind it to a memo field. I found out by trial/error that the
property DocumentHTML contains the html code of what you type into the
control. Unfortunately on form close when I want to do:
MyMemoField=ActivexCtl0.DocumentHTML
I get an error saying that "object doesn't support this property or
meathod". However if I put the above code into a push button, then it
works?

Anyhow, it would be nice if I could bind this to the memo field so this
happens automatically.

If I can't get this to work, I guess I'll have to use the rich text
control.

I tell you though, there is not a lot of documentation on this guy...

Thanks for replying.

[ken]

You use the HTML control as a viewer which is not bound to anything...
I need help on binding the control to a memo field.

[Stephen Lebans]

Access, as a host ActiveX container, only supports simple databinding. Very
few controls can be successfully bound to a field unless the control was
designed from the beginning with Access in mind.

You will have to simulate databinding yourself as in the sample project I
pointed you to.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"ken" <ge****@gmail.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

You use the HTML control as a viewer which is not bound to anything...
I need help on binding the control to a memo field.

[David W. Fenton]

"Stephen Lebans"
<[e-mail]> wrote in
news:_2**********************@ursa-nb00s0.nbnet.nb.ca:

Access, as a host ActiveX container, only supports simple
databinding. Very few controls can be successfully bound to a
field unless the control was designed from the beginning with
Access in mind.

You will have to simulate databinding yourself as in the sample
project I pointed you to.

It's generally best practice to not bind controls to memo fields,
anyway, as a way of avoiding lots of potential corruption issues, as
the memo pointers are the most fragile aspect of Jet storage.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc