Search results

hello all, For some reason my duplicate button now doesn't work, instead it pastes the values in an error table. I noticed that it seems to be copying the time fields and a text box that aren't in the table, but it never did this before. Any ideas? Thanks ________ AVANDIA LAW

any more help? mos ________ Paxil Death

your correct, but sickness is a leave type, reason why I want it like this is I am running a report where an employee has booked a holiday but then goes sick on the same day. What should happen is once the user enters a "sick" booking on the same day it removes the hours from the holiday booking...

that would mean an employee cant be sick on a day he has booked holiday. Only if the leave_type is holiday then stop the booking. Just to reiterate; user selects employee via combo box, then leave type etc. then once the date is selected it should see whether the employee has booked a holiday...

Update; Private Sub date_booked_BeforeUpdate(Cancel As Integer) Dim SID As String Dim var As Date Dim stLinkCriteria As String Dim rsc As DAO.Recordset Set rsc = Me.RecordsetClone SID = Me.strpayroll_number.Value var = Me.date_booked.Value stLinkCriteria = "[strpayroll_number]&[date_booked]="...

This is what i've adjusted so far, but I cannot work out how to check two fields (date and the payroll number), the parts in bold is where theres needs to be another field? Thanks Private Sub date_booked_BeforeUpdate(Cancel As Integer) Dim SID As String Dim var As Date Dim stLinkCriteria As...

Thanks, its slightly more complicated as it's reqired in two fields that needs to be checked for duplicated (payroll number & date booked). I'll have a go at adjusting the code for this. Any help is appreciated. Thanks once again. ________ Cheap glass pipes

Hello All, I've recently created a holiday booking form for employees. The only problem I have noticed is the user can double book someone even though the employee has the requested day already booked. Is there a way where to refuse booking if the employee has already booked the day already...

Hello All, I've recently created a holiday booking form for employees. The only problem I have noticed is the user can double book someone even though the employee has the requested day already booked. Is there a way where to refuse booking if the employee has already booked the day already...

Hello All, I currently have a combo box that selects the employee to create a new holiday record. Once the user has finished adding the record I don't want to enable the field during the scrolling of the records. How can I do this? Thanks. m ________ Live sex

I have a main form with 4 subforms. They all work off specific fields from the mainform. One of my subforms basically looks at holidays booked for the day the employee wants to book. The only problem is It picks up days book for employees across all departments. The subform is based on a...

the Main form and subforms are based on queries. When I add a record on the form I wanted a refresh function but obviously could not do it as the forms are query based. A record is added and the subform contains a query that looks at which employees are off on that day thus update in that query...

Would it be better to have it under AfterUpdate on the form? mos ________ Avandia settlements

Thanks for the reply; so basically in the mainform: YourMainFormNameHere.YourSubFormCONTAINERNameHere.Form.Requery Forms!YourMainFormNameHere.Requery Subform: Me.Requery Are these placed in the AfterUpdate option of the forms? Regards ________ Web shows

ok, so Can i use the following to requery each form? Private Sub Form_Current() Dim rst As Recordset Set rst = Me.RecordsetClone Forms![AIA].Requery End Sub Thanks Mos ________ Paxil Lawsuit Information

So Requery refreshes the data on the form? thanks ________ Laguna Bay Condominium

Hello All, I currently have a form that has 4 subforms but I require a Refresh function that refreshes every single form. I have tried creating individual refresh buttons for each form but doesn't seem to work. Any help appreciated. Thanks Mos ________ Susanalady

thank you. mos ________ How To Roll Blunts

Hello All, I have a subform with a field that counts the number of agents off per team. I want to create a peice of vb code where If the department contains the letters "one" And the count is more than 1 to highlight the text box. I have the following written; Private Sub...

still finding it difficult to create it. For the first requirement I have the below, but does not work. =DCOUNT(IIF([Leave_Type]="Sickness" AND [date_booked]<Format(Date(), "yyyy" -1),1,0)) ________ Park Royal Condos Pattaya