Few Questions - Help !!!

[Branagan]

Is there a posibilty where i can add a find button to my form, so i can search my fields ?

I know you can use ctrl + F or click the binoculars but my form is pretty big and so i had to remove the Form View toolbar. Also it makes my form abit more professional ..

Last question is, i know this is a n00b question but how do u remove the buttons at the bottom of the form, i forgot.

Thanks in advance
Chris Branagan

 

[namliam]

Is there a posibilty where i can add a find button to my form, so i can search my fields ?

I know you can use ctrl + F or click the binoculars but my form is pretty big and so i had to remove the Form View toolbar. Also it makes my form abit more professional ..

Simply use the button builder wizard, it has a find button...

Last question is, i know this is a n00b question but how do u remove the buttons at the bottom of the form, i forgot.

Thanks in advance
Chris Branagan

Properties of the form, Navigation buttons (in the format tab) set to No.

Regards

 

[Branagan]

thank you very much

 

[Branagan]

i just went to implement what you just said and in the form properties and the navigation buttons property isn't there ???

I'm currently using MS Access 2000

In my property list for format, it has the following properties.

Force New Page
New Row Or Col
Keep Together
Visable
Display When
Can Grow
Can Shrink
Height
Back Colour
Special Effect


and as for the find button, using the wizard, its doesn't seem to be there

do you think its because MS Access doesn't have everything installed ? or is it my version ?

 

[namliam]

In my property list for format, it has the following properties.

Your looking at the properties of the section NOT the form left click just under the title bar, utmost left ( or just open the form and do nothing) you should then be able to find it...

and as for the find button, using the wizard, its doesn't seem to be there

Its there allright!!! In record navigation, just in case this is the code:

Private Sub Command5_Click()
On Error GoTo Err_Command5_Click


    Screen.PreviousControl.SetFocus
    DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70

Exit_Command5_Click:
    Exit Sub

Err_Command5_Click:
    MsgBox Err.Description
    Resume Exit_Command5_Click
    
End Sub

and this is the "Find next" button code:

Private Sub Command4_Click()
On Error GoTo Err_Command4_Click


    Screen.PreviousControl.SetFocus
    DoCmd.FindNext

Exit_Command4_Click:
    Exit Sub

Err_Command4_Click:
    MsgBox Err.Description
    Resume Exit_Command4_Click
    
End Sub

Regards

 

[Branagan]

lol cheers, i must have taken my stupid pills this morning

i sorted it now hehe

 

[Branagan]

got a new question

I want to be able select a value from a combo box on my form. But when i select a certain value i want it to show some fields

ie/ when i select lanlord from the combo box, it would make my landlord field appear on my form. but if it aint selected, the lanlord field stays hidden

thanks in advance

 

[namliam]

Why would you want to?

ANyway After update of the combobox you can retrieve its value and do stuff accoordingly.... hide/make visible, close forms what ever...

Regards

 

[Branagan]

I want to make it look more professional and plus, not every customer has a rented house, so its a waste of form and space for the people that own there own house..

any ideas

 

[namliam]

Idea allready in previous post, tho if you are hiding and showing the textboxes you still need to reserve space for them.

If you want/need to conserve space, try fiddling around with tabs and the same idea of hiding and showing them as needed...

Regards