Recent content by salamander

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)