Search results

Hi I have structured a query to come up with a network address/file path, which relates to information previously populated by the user. What I would like to do is include this query result to a command button so when the user flicks to the specific record, they can hit the button and the...

Thats solved it, thanks spikepl!:D

Okay, now I'm getting it. However, the second part isn't working for me. CF2: Iif([AorB]=0 or [AorB]=1], Cstr[CF1],"Error") I've tried removing the extra ] thus: CF2: Iif([AorB]=0 or [AorB]=1, Cstr[CF1],"Error") but it keeps coming back to invalid syntax error??? Thanks for the help so far!

Hi all I have a problem with a query/module which I’m stumbling around a bit with, looking for some assistance if possible!! I have the following module (wWhere AorB is a numeric field): Public Function MPF(AorB As Single) As String If AorB = 0 Then MPF = "[MPStart] + [Fr]" ElseIf...

You've answered a question I was just about to ask, thanks again!!:D

missinglinq, sorry for the delay in replying, I've been trying to get the basics down first in the database before I even attempted this. As you've noted it seems to be quite complicated and I think its a bit beyond what I can do (and what the database needs) at present. Definitely an...

missinglinq, its the tab itself I'm looking to colour - to give a user a quick status 'snapshot' of the information on the form. Sorry, I should have been more clear at the start, thanks Swift

Following on from bob fitz's advice http://www.access-programmers.co.uk/forums/showthread.php?p=1110200&posted=1#post1110200, I was wondering if its possible to do the following: scenario is 2 checkboxes on a sub-form which sits on a tab control. If both boxes are unchecked, the tab control is...

Spot on Bob Fitz, thanks for the help! :) Swift

Hi, I'm looking for some help with my latest project, hope someone can help!! Basically I have a form that contains two check boxes, StartedAgrBr and CompletedAgrBr. I want to make sure that when a user selects StartedAgrBr (for example), they cannot unselect it. So I need some code to either...

Yes thats brilliant, thanks everyone for your help - I knew someone would come along with a better suggestion than my cobbled together effort!!! One thing would be good though, how would I return the month as 'October' instead of '10'? Any ideas? Cheers muchly:cool: swifty

OK, thanks for that. I've tried the Format([DFDateRaised],"dd/mm/yyyy") in the criteria box in the query grid, under the DFDateRaised field, and it is returning zero results. I think perhaps I've phrased my original question incorrectly. I'll try to explain further. At this stage I just need...

I need to separate a date/time field held in my database into a date field and a time field. I want to do this so I can query the number of records by date. I’ve looked at the various options mentioned on the forum, including the LEN, DateValue, Format functions etc but with no success so far...

Brilliant, Dcrake, thanks! One thing though, I was looking at the last field on the query in that DB. I could use something similar in my query to tell me which category (LPV3m, LPV10m or LPV30m) has the maximum (highest) value. In the downloaded DB, it returns the question(s) answered with the...

The one issue I have here is that the data is loaded up from excel in a standard format, so this (I think) is not possible unless I can devise a way around? cheers

Thanks JANR, with a little bit of modification to your code I got Texture: Nz((Round([TEX],1)),1.5) which works a treat! Thanks

I’m trying to use both the Round and Nz functions in the same expression in a query, having problems though. This is what I’ve got so far: Texture: (Round([TEX]),Nz([TEX],1.5),1) Basically I want to round up the TEX value to 1 decimal place, BUT if there is no value in the field then I want...

Sorry, but you've completely lost me there! could you elaborate? cheers

Hi again, This time I’m looking for a way for my query to tell me which is the maximum value out of three fields in the query, in this instance its [LPV3mScore], [LPV10mScore] and [LPV30mScore]. For example. If [LPV3mScore] = 0 [LPV10mScore] = 19 [LPV30mScore] = 0 Then I would like to return...

Ok, so I've changed the module as suggested by boblarson and MSAccessRookie. Still no joy, I thought I would perhaps go back to the start and make sure that TypeAndScopeOfWorksDescription is a text field. It is indeed a text field, I can't see how to change the properties in the query or the...