Search results

I think it's solved :) http://www.access-programmers.co.uk/forums/showthread.php?t=185438

Hi I've got tblServices, tblEmployees and because it is many-to-many I use tblAllocations to assign employees to services (in tblAllocations I've only got EmployeeNo and ClientNo) I used primary key for EmployeeNo and ClientNo so it works now... I didn't know that it possible to have one...

Basically I'm trying to delete double allocations. for example employee A cannot be allocated twice to the same job. Hence, I don't know how to prevent double allocations I'm trying to run the query to delete them when the occur... Cheers!

Basically I'm trying to delete double allocations. for example employee A cannot be allocated twice to the same job. Hence, I don't know how to prevent double allocations I'm trying to run the query to delete them when the occur... Cheers!

Hi, Why is this delete query not working? DELETE tblAllocations.*, ([tblAllocations_1].[EmployeeNo]=[tblAllocations].[EmployeeNo]) FROM tblAllocations, tblAllocations AS tblAllocations_1 WHERE (((([tblAllocations_1].[EmployeeNo]=[tblAllocations].[EmployeeNo]))=True)); Thanks guys!

Thank you John, I added your code and it works as it should :o Cheers!

hello, As in the title, I've created unbounded form to add new record (job). How do I make the ClientID field required? Thanks!

Thanks guys, it works now. One more question, why is my delete query not working if I use the SQL below? DELETE tblAllocations.*, ([tblAllocations_1].[EmployeeNo]=[tblAllocations].[EmployeeNo]) FROM tblAllocations, tblAllocations AS tblAllocations_1 WHERE...

Hi, Thanks for the reply, but I'm still getting an error "wrong number of arguments". Cheers

Janr... it is a loooong story, all I want to do is to finish this database by tomorrow. :) I've tried to use & but not , (yes, I know this is dummy) Thank you anyway!

Hi, How do I change the code below to include one more field in the second combo box i.e. ServiceNo. I want both ServiceTitle and ServiceNo to appear (there are both in the same table). Private Sub ClientNo_AfterUpdate() Me.ServiceNo.RowSource = "SELECT ServiceTitle FROM" & _...

I get an error when I try to input this expression. Error: "The expression you entered contains invalid syntax". Thanks!

Hi, Could someone please add to the IF Statement below one more field: BusinessName. Besically, if the Forename and Surname are NULL the BusinessName show appear and vice versa. Client Name: IIf(IsNull([Surname]),IIf(IsNull([Forename]),[Forename]),IIf(IsNull([Forename]),[Surname],[Forename] &...

Anyone... Please... I really need some idea...:confused:

Hi, yes it works for me too :) However, I figured out that it will be better to use it as a code: Private Sub lstEmployees_AfterUpdate() Me.txtCount = Me.lstEmployees.ItemsSelected.Count End Sub This way I get instant update whenever I select/unselect a record in the box :) Cheers!

Hi John, Thanks for that. How do I change it so that it shows not the number of all employees in the list box but only the number of selected employees? (This is multiselection listbox). Cheers

Hi, How do I make a field on a form that shows (counts) the number of records selected on a list box? Thank You!:o

Hi, I have this problem and if I don't figure out how to do it, the database I'm creating is very much pointless. I have 3 tables: tblEmployees, tblServices and because this is many to many relationship I created 3rd table tblAllocations (only two fields: EmployeeID, ServiceID but I'm using...

Hi, Thanks for reply, The code of query that shows unallocated employees is as follows: SELECT tblEmployees.EmployeeNo, tblEmployees.Forename, tblEmployees.Surname, tblAllocations.ServiceNo FROM tblEmployees LEFT JOIN tblAllocations ON tblEmployees.EmployeeNo = tblAllocations.EmployeeNo WHERE...

Hi Curtis, Is there a way, to do it by using a query. For example, user specifies the time frame and only those employees available in this time appear?