Search results

Hi there We have a list of resources in a table. Each resource has a group (for illustration, let's say 1-10). Each resource is attached to a job which has a start date and end date (in another table) What we need to do is send out the lists in each group to a group lead. Now this is probably...

Hi there, There is a list of records I have (based ona query). User double clicks a list item to go to that record on another form. Code invoked is: Dim stDocName As String Dim stLinkCriteria As String stLinkCritera = "[ID] = " & Forms!frmNAME!lstNAME.Column(4) stDocName = "frmNAME"...

Hi there, I am having huge performance issues with a FE/BE split. As a background, I have the following Table layout. In basic terms, the contract table has basic contract info, resources can be assigned to a contract (via the Assign table) and we feed in exchange rate info also from another...

Hi there, I have a report which shows certain costs if they meet a certain criteria. So I have the following layour (for simplicity I will omit the other headers as they have no impact whatsoever on my question) Ref - Total Costs Blah - £100 BlahBlah - $200* In the query Total...

Hi there, I have a listbox which gets a list of resources based on the role they are viewing. So, for illustration sake, it will get all Resources assigned to RoleID = 1 then display them all. Each resource has a daily rate. So in this example, I have 3 tables, 1 for the roles, 1 for the...

Hi there, The aim of this (as part of a bigger solution) is to create an entry system where users can enter jobs in, assign a resource to the job and give the resource a cost. The conditions are that resources can be on more than 1 job, more than 1 resource can be on a job. Obviously entering...

Remove Filter on Form Search Results Hi there, On the main form (which displays all the records), there is a search form. On this form, one searches then clicks on the desired record. This closes the search form and reopens the main form. The problem is, the main form displays the search...