Search results for query: *

Sorry confusing myself at this stage. Disregard above. It should read that my tblmarkingscheme has 1-10 categories. I may not use all 10 for some projects but want all fields updated and the record locked once populated. If a category is not used I want it to have a max mark of 0 and a...

note also on my subbmission data entry forms if a category is passfail only, i hide maxmarks and passmarks. i then update these hidden fields to 0 so that all fields in a record are populated. users cannot move on to next record until all fields are populated. therefore there are no null...

dhookom - I tried the code in the on format event in the detail of the subreport but with the same results. ie the show/hide of certain fields only worked if i clicked on the subreport in report view and did not show/hide at all in print preview is the were you mean for the code to go? thanks...

the system is designed to record different projects details. each project has a marking scheme.applicants are invited to make submission for a project and they are then scored based on the specified marking scheme. this data is entered to tblproject, tblsubmission and tblmarkingscheme...

I am using access2007 and want to generate letters. I have designed a report with a subreport.. I am happy that the master/child links are in place. I want to make some fields within the subreport visible/not visible based on certain conditions when the main report is opened. At present I...