By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,842 Members | 2,198 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,842 IT Pros & Developers. It's quick & easy.

Procedure Attributes

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
13 Replies


P: n/a
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.

Nov 13 '05 #2

P: n/a

"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.
Nov 13 '05 #3

P: n/a
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.

Nov 13 '05 #4

P: n/a
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.

Nov 13 '05 #5

P: n/a
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.
Nov 13 '05 #6

P: n/a

"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.
Nov 13 '05 #7

P: n/a
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?

Nov 13 '05 #8

P: n/a

"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.

Nov 13 '05 #9

P: n/a
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.

Nov 13 '05 #10

P: n/a
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.

Nov 13 '05 #11

P: n/a
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.

Nov 13 '05 #12

P: n/a
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.

Nov 13 '05 #13

P: n/a
"Stephen Lebans"
<ForEmailGotoMy.WebSite.-WWWdotlebansdot...@linvalid.com> 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
Nov 13 '05 #14

This discussion thread is closed

Replies have been disabled for this discussion.