Search results

Hi everyone, Can anyone help with a trick to calculate the number of days btw two dates excluding weekends and holidays in ms access? Thanks

Hi, Is there anyone can help with some advice in building a search (Like) in a field and filter records between two dates in a same form or query? Thnaks

Thank you guys for your advice, it really helps, finally, I got what I am looking for, it is To Select all use this code builder: CurrentDb.Execute "UPDATE [Table Name] SET [Name of the Yes/No Field]=True", dbFailOnError Me.Requery To Unselect all use a code builder: CurrentDb.Execute...

I understand once a check box bound to a table what you do on the form also done in a table, But what I really meant is that in a datasheet form or a continuous form with check boxes at each field, is there a way to build (code builder) a button can select all or unselect all yes/no fields at...

Do you mean updating the query criteria or the table?

Anyone know how to build a button that can uncheck all selected record (yes/no) field in a form? Thanks

Thanks Gina, Yes I have set up tables i.e employeetbl, leavetbl and leavetypetbl employeetbl contains StaffName, Home Island and Annual Leave Earning (Earning) leavetbl contains Balance brought forward (Bal_BF), Annual Leave Earning (Earning), Eligibility (Total Bal_BF+Earning), Date Leave...

Can anyone help with some advice on how will I start? I attached a sample template if you can determine how to create a leave system to get this report.

thank you...

Hi everyone, I'm new to this group..... and I needed some help or advice creating a leave record management system for my workplace using ms access. Thanks