subform question

[vassilis]

hello there
im looking for a way to improve the appearance of a subform. for exaple to
change the datasheet view,and make it with a tab control...control wizard
always gives the same datasheet view. is it possible?
thanks

 

[Vincent Johns]

hello there
im looking for a way to improve the appearance of a subform. for exaple to
change the datasheet view,and make it with a tab control...control wizard
always gives the same datasheet view. is it possible?
thanks

Lots of things are possible. What do you want to do? You can use the
wizard to create the controls you need, them modify them to suit your
needs (wishes, desires). In Form Design View, open the Property sheet
of the control you want to modify, and set new property values.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[John Spencer]

Yes it is possible.
Find the sub-report that the wizard created. Open it and modify its
properties and design to your needs.

The other option is to create the subreport (as a report) and then have the
wizard use the sub-report.

 

[vassilis]

one more question pls ...i want a toggle button getting red when it is pussed
and green when its up, i guess that needs some code and i have no idea....

Ο χÏήστης "John Spencer" έγγÏαψε:

 

[John Spencer]

You can't change the color of the button, but you can change the color of
the text.

Private Sub Toggle2_AfterUpdate()
If Toggle2 = True Then
Me.Toggle2.ForeColor = vbRed
Else
Me.Toggle2.ForeColor = vbGreen
End If
End Sub

Another choice would be to have two controls on the screen and use code to
change the appearance to emulate the appearance of a toggle button.
You could also use two pictures and change the visible properties of the
controls as appropriate.

 

[vassilis]

thanks for your time!!!

You can't change the color of the button, but you can change the color of
the text.

Private Sub Toggle2_AfterUpdate()
If Toggle2 = True Then
Me.Toggle2.ForeColor = vbRed
Else
Me.Toggle2.ForeColor = vbGreen
End If
End Sub

Another choice would be to have two controls on the screen and use code to
change the appearance to emulate the appearance of a toggle button.
You could also use two pictures and change the visible properties of the
controls as appropriate.

 

[benson]

yes you must use some code to make it ,but the code is so easy ,
you can use the vb code to make it .if you want to make it and do not know
how to write the code ,please email to me : [email protected] ,
it is me pleasure to help you ,

 

[benson]

the same view ,yes ,
it i s allway the same
here ,i advise to use other tool to hold thedata , the list is a good choice.
if you can write some code ,you can use it and hole code and double click or
click to open other form and so on .
if you need ,i can give you a example to you ,
my experience :
firstly
wo use the sub form to hold the fitlering data , and put some command tool
to deal with some request
but ,i find when you want to use data from different table ,you will use
more sub form on the form .it is so difficult control
then ,
i read more book about access and use a system building by access with a
lot of code .finally, i find the system use few sub form but list tool .for
the list sourse can be supplied by code and hold data from different table
..so easy so happly