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...

Has anyone got any ideas how to jump to a record on another form without filtering?

It definately filters on mines, and Subform is not an option for cosmetic reasons. Going to do it alternatively with public defined vars now.

Thanks guys for the hints. Unfortunately, the scope of th e project does not allow for SQL Server etc. I have to be able to use existing infrastructure (i.e. a WAN Share) I got it running fast though. What I done was use the replacement "t" lookup functions, calculated fields which depended on...

I'd rather not do that as I would like both forms to be able to be on the screen (some users would prefer to have both on the screen)

Ok managed to fix it using RS; If Len(Nz(Me.OpenArgs, "")) > 0 Then Set rs = Me.Recordset.Clone rs.FindFirst "[ID] = " & Me.OpenArgs Me.Bookmark = rs.Bookmark End If However, this only works if the form is not open. If the form is already open, the OpenArgs value is held constant as the...

Works but still filters the form. Adding Me.Filter = "" still does not help. Any ideas?

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"...

Yup, it's a WAN :( Might have to consider using a MSSQL server. Is it relatively easy to port the database over and use my existing front end?

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...

Thanks. I ended up doing this a "wierd" way. I added another column to the currency table named Notes. In this, I put * for USD and ** for Euros. In the field for the cost, I then appended this note to the end of the value (eg field looks like ="£" & Round([Costs]/[ExchangeRate],2) & [Note]...

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...

Managed to do it, using some SQL statements :) Thanks anyway

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...

Excellent thanks. In reality, I have 6 tables that need to be linked centrally, so I will be using the same principle (having a central one I call "assign" so it can link all 6 easily)

Okay, how I have done it is have 3 tables: People, Jobs and AssignPeople. AssignPeople is the "intermediary"; it gets a Person's ID and a Job ID, and can assign a rate. Thus I can have multiple people per job, and people having more than one job. Good way?

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...