help with VB controls in word doc

[sai]

Iam an amatuer programmer in need of some help and advice.
This concerns VB Controls on a word document.
I added a text box and button to a word document.
On click of the button iam saving the data entered in the
text box in a network database.
There is no problem with this. I ciruclated this amongst a
set of friends to capture their inputs
and save all their inputs to the central data base. Before
circualting it i switched off the design mode.
How ever when i sent it out, my friends were able to open
it and switch it back to the design mode and change the
code.

So the first question is, how would i able to disbale the
design mode when circulating the document?

One more question, assuming i have some other content like
tables in this document along with the VB Controls,
would it be possible to ensure in some way that, when i
print this document, all content other than
the VB controls get printed.This is because as of today,
iam not able to prevent the VB controls
from getting printed along with the rest of the content.

It would be great if some one could throw some light on
this and orient me in the right direction

Thanks in advance and Regards
sai

 

[Word Heretic]

G'day "sai" <[email protected]>,

in the vbe, right-click the project and select properties to give it a
password. To rpint you need to cycle through the controls and hide
them first. You can intercept the print command several ways, best way
is to provide your own Print me button.

Iam an amatuer programmer in need of some help and advice.
This concerns VB Controls on a word document.
I added a text box and button to a word document.
On click of the button iam saving the data entered in the
text box in a network database.
There is no problem with this. I ciruclated this amongst a
set of friends to capture their inputs
and save all their inputs to the central data base. Before
circualting it i switched off the design mode.
How ever when i sent it out, my friends were able to open
it and switch it back to the design mode and change the
code.

So the first question is, how would i able to disbale the
design mode when circulating the document?

One more question, assuming i have some other content like
tables in this document along with the VB Controls,
would it be possible to ensure in some way that, when i
print this document, all content other than
the VB controls get printed.This is because as of today,
iam not able to prevent the VB controls
from getting printed along with the rest of the content.

It would be great if some one could throw some light on
this and orient me in the right direction

Thanks in advance and Regards
sai

Steve Hudson

Word Heretic, Sydney, Australia
Tricky stuff with Word or words for you.
wordheretic.com

Replies offlist may require payment.