Search results

I have two linked tables one with formulations on the other with stock quantities of the raw materials on. I have numerous queries incorporating the formulation of one product and mulitplying it by the batch size (which will change from week to week). What I now need to do is put all the...

Sorry :o naughty me, slapped wrist lol

I have a subform which idealy I would like to stay in datasheet view and I want it to resize to accomadate the differing numbers of lines in the subform. Is this possible (and what is the code) or do I need to change the view to a continous form? Thanks. Ruth

resizing suborms If I change the subform view from datasheet to normal form view what is the code I need to use to resize it?

I have a subform set up in datasheet view and want the subform to automatically change height depending on the amount of lines used in the subform. I have set the can shrink and can grow properties to yes but they don't seem to make any difference (is there something else I need to do to make...

Hiding more than one subform To hide a subform I'm using the following code on the main form Private Sub Form_Current() With Me![stage B].Form .Visible = (.RecordsetClone.RecordCount > 0) End With End Sub It works but how do I make it work on more than one subform. Thanks Ruth

Please can someone help!!! I have a subform and text box within a form and I want the subform and text box to be hidden unless there is data in it. Please can someone explain it to me in easy terms as I am new to the database creating game. Thanks Ruth