Search results

Hello I have an beforeupdate event on a date field (tenderclosingdate) to check some criteria. If the date entered does not meet that criteria then it should give error msg and cancel the update. The probelm is with one of the conditions. It is a currency field. I want to give a message...

Thanks Simon MT for your reply. I think I was too committed to the path I was on with my original code to try this. After update worked okay for me when I made a few adjustments to my onload control settings. cheers

good idea, never thought of that, i will give it a shot:) Thanks Addyman

Hello there I have a report that functions as a letter to suppliers. I have fields in the letter that maybe be 0 or zero due to data entry rules (filling all fields/ locking records after all fields entered/creating totals.) I dont want these to be displayed and have code in the onload event if...

Thanks Bob. Requery in the afterupdate of subform1 was what i need. However it leads me onto another problem in subform2. The layout of subform2 is dependent on the data entered in subform1. I had code in the onload event of subform2 that hides "headings" if they are blank and move the next...

Hello there I have a form in ms access 2007, with multiple tabs. Some of these tabs have subforms. I want to update one subform from another but am having no joy. I cannot requery the second subform. ive read alot of threads about requery, referencing the main form and then subform2, the...

thank you very much. combo boxes worked. :) i think i have the same problem with reports now if data entry is incomplete, but thats for a different forum, for another day

thank you for your reply. i dont think it solves my problem though. When the user is entereing data they would select that from a combo box which refers to tbltype. this displays the typedesc for the user but writes the typeID to tbltender. if i base my enquiry form just on tbltender i will...

Hi This is probably a really fundamental basic but I just am not seeing the wood for the trees at the moment. I am using access2007 with SQL backend to record tender details. I have a main table called tbltenders, pk in this table is tenderid. I have another table called tbltype, with typeid...