Recent content by MM-UK

This is interesting. I have a module which defines public holidays from a holiday table. So in a query, how would I use this module. This query needs to calculate hrs available for this current month less weekends and public holidays. A help with the syntax would be greatly appreciated

One important thing you've all forgot. You must set the warnings back to true, else this will affect the rest of the database. DoCmd.SetWarnings False If MsgBox( "Are you sure you want to delete this athlete?", vbYesNo )=vbNO Then Cancel = True MsgBox " This athlete has not been deleted"...

Me.txtMyDateField = Null or If Not Isnull (Me!txtMyDateField) then Me.txtMyDateField = Null Else Me.txtMyDateField = Me.NameOfMyCalendar.Value End If You should use these on the On_Click event of the Calendar control. The second version will only set the date to Null if the field you have...

Right click the desktop Goto display properties If on XP goto advanced Change the "Application Background" This will do the trick

You can create a query and base your subform on that. in the query, you can do calculations.

In the field in question, I am getting #Name? I've checked the field names are correct in the table, here's what should happen. =(DSum("TG","tblLabourBooking","AssessmentNo=" & [AssessmentNo] & " And Operation='Fit'")) The expression looks for TG which is a numerical value assigned earlier...

Perhaps I should have mentioned, this is a text on a form as opposed to a criteria in a query.

Sorry, that didn't work. Does any body else have any idea's ?

You can do this by creating an unbound control, ie text box and settin thru properties its size to Width=0 & Height=0. Set this unbound's tab stop to yes. Set your other text's tab stop to No. When your form has focus, you won't know where the focus is because the unbound cannot be seen.

I need the following to handle Nulls but not sure which option to use. =(DSum("TG","tblLabourBooking","AssessmentNo=" & [AssessmentNo] & " And Operation='Fit'")) Thanks in advance MM