Recent content by brucey54

Hi folks, I have created a function to check for future dates, but how do I make it generic. I am assigning the function 'Before Update' on the textbox property. I do not want to type each textbox name, any help much appreciated. code below Public Function CheckDate() Dim myDate myDate =...

Hi folks, is it possible to close a form using vba from a command button, then reopen the form at the same record that you closed from?

Great thanks

Hi folks, I need to add 4 textboxes, I was think of adding within the Control Source of another textbox like so textbox= ([textbox1]) + ([textbox2]) + ([textbox3]) + ([textbox4]) But if any of the textboxes are null, the formula does not work!!

Thanks arnelgp, just one wee issue, the subform does not display the cake names until I close the subform then reopen the form!

Yes, I have 2 tables, 1 for student details and one for cakes details

See link http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=62988&stc=1&d=1465908937

Hi JHB, I was kind of hoping I could set multiple default values within a datasheet view. I don't think a combo work would work! I need the students to complete each record i.e. enter each Ingredients they used for each cake...

Hi folks, how do I set multiple default values within a datasheet lay out. I would like the datasheet to display 3 default values i.e. Column Name - CakeName Default value 1 Chocolate Cake Default value 2 Strawberry Cake Default value 3 Toffee Cake

Thanks CJ_London, your help was much appreciated :)

lol sorry, TblDietPlan.MealDate is a date field, trying to display a list of clientsID's and what was their last meal. i.e. Client 1234 MealDate 13/04/2015 TblDietPlan.MorningSnack - Bread & water TblDietPlan.AfternoonSnack - Bread & water TblDietPlan.EveningSnack - T-bone steak & Peroni...

Hi folks, need some help with displaying the max date sql code below; SELECT TblDietPlan.DietPlanID, TblDietPlan.ClientID, TblDietPlan.MealDate, TblDietPlan.MorningSnack, TblDietPlan.AfternoonSnack, TblDietPlan.EveningSnack FROM TblDietPlan WHERE (((TblDietPlan.ClientID) Is Not Null) AND...

Thank you, interesting reading

Thank Plog, I need to play devil’s advocate here, if your table had let’s say over 2 million records and you could achieve 40% of the records to another table. This would optimise your database/main table i.e. the query would not need to run through 100% of the records to check if it is flag or...

Why would you want to leave old data within your main table and not achieve to another table. My line of thought is keeping old data mixed in with current data would slow the database down. Why would you not want to append it to another table then delete it from the main table???