Recent content by Mascotte

Can u show me an example of "columnhidden" please? thanks

Hi missinglinq, I have a table with more than 100 fields. I have a form and a subform is linked to it. Not all the fields have records in them. so i would like to hide those fields which have no value. Do u think i can be able to do it?

Hi I have a form and a subform is linked to it. The subform is in datasheet view. Does anyone know how to hide fields which have null value in the subform? Thanks

Hi Marianne, I cant seem to get it to work.. there is a compile error message.. i think it has something to do with my field name which is a number. Any idea?

What i want is hiding all the fields which have no value and show only fields that have values on them. If i put on the criteria fields the "Is Not Null" condition and the first field is ever null for every record. How do u set visibility propertyof the empty field on on current event?

Hi Marianne, Do you think i can hide the fields which has no value? Yours just hide the records. Pls advise..

Hi Marianne, Can you show me how its done? I am new to Access. Thanks.

Hi I have a form and a subform is linked to it. The subform is in datasheet view. Does anyone know how to not show null value on my subform? Thanks.

Attached is my table on ms excel. Please have a look and advise. Thanks.

Hi I have a table with over 100 fields that has the following fields: OrderNo, DateCompleted, DrawingNo, 1, 2, 3, 4, 5.......50, 111111,111112,111113,111114......111200. 1 to 50 being the inspectors' stamp number. For every completed job, there is 1 point rewarded to the job which is divided...

Hi all, I have a form that requires text boxes to fill up based on a selection of results from a combo box. My problem now is everytime i choose a result from my combo box, the text boxes got filled up all right but the rest of the text boxes got filled up also with the same result i selected...

Hi, I have a table, a query and a form but everytime i update my form. Only my table is updated but not my query. Why is this? Can i update both the table and the query when i update my form? Please advise. Thanks.

Hi John, I got it. Thanks so much for your help.

Hi John, I have tried everything but cant seem to get the main form to change after i have entered text. Do you know whats my problem? Please advise. Thanks.

Hi John, Thanks a lot for the post. frmSupplier1 is what i was looking for. Do you think you could show me how its done? Hope you could help. Thanks.:o