Search results

I have a report that shows a calculated date field (a future expiry date), either 'x' years from a specific date or from a defined date. I'm trying to highlight the calculated date where it is 12 months before today, using the following Conditional Formatting rule: Condition 1: Field Value Is...

Wow! You certainly know your stuff :eek: :eek: This has resolved all the issues I had. Thanks a lot, arnelgp. You're a star :D :D

Hi, This definitely does most of what I want it to do, thank you, but I don't think it's providing me with the highest Application Number (the 'nnnn' part of 'yy/nnnn'). The fnSplit stuff you've done is really quite good, thank you, but I guess this would be better in a query and as the data...

Here it is... Thanks.

I've just cottoned on to something... fnSplit2 works, but fnSplit1 doesn't - and I think that might be because fnSplit1 is being used with references that could begin with a character or a number. And I also realise these do work independantly of each other. It would be possible to 'nest'...

I didn't copy and paste it - just amended the line in red. However, I missed the 'v=Split(s,"/")' line from the original. Silly me! Having done what you suggested properly, I now get a different error! This time it's: Run-time error '9': Subscript out of range Also, am I correct in...

Hello again, Still a (small?) problem with this, sadly. This time, I get a "Run-time error '13': Type mismatch error". The field I'm trying to use this function with is Text. Thanks, Pete

Hi arnelgp, I had a quick look at it this morning, but got a compile error... Function call on left-hand side of assignment must return Variant or Object. I was using it in a simple Query with 2 fields. The original reference and the 'amended' one, like this: Stripped: fnSplit1([Initial...

Blimey, thanks arnelgp. I'll give that a go and see how I get on! Am I correct in thinking this would be called from Event code using fnSplit1(fieldname)? Thanks.

Hi all, Could this Function be configured to include '/' and '-' characters, please? I would like to return: '13/1546' from 'S/PRIORC/13/1546' and '13/0999' from 'S/SP/13/0999' and '13/0081' from 'S/LBC/13/0081' and '13/0244' from E/2013/0244/FUL' for example. The '-' is used in another...

OK, so my solution is this: Use the [ID] data to find the records, not the [Name]. Simples!

OK, so I've looked at this a bit more and realised why it's happening (although not what to do about it!) The field in the main table is a lookup to tblPlanningAuthority, which looks like this: SELECT tblPlanningAuthority.ID, tblPlanningAuthority.Authority FROM tblPlanningAuthority ORDER...

OK, I think I've got to the bottom of this, but I'm not sure the best way to resolve it... The code you provided, Cronk, works with all the fields except one - and I've written a new 'test' query using the same criteria with the table and I get the same error: "Data type mismatch in criteria...

Oops. Although this works, it's brought up a "Data type mismatch in criteria expression" error, so I'll have to see what's caused that! Tomorrow - it's too late now! Good night.

Thanks, Cronk :) It didn't work to start with, but then I realised you left a deliberate mistake in the SELECT statement, just to make sure I earned your help :D:D All the best, Pete

Thanks, guys. Would I do this from the criteria form that opens the results form? It's not based on a query, just a series of text boxes with the values formulated in to a filter string (DoCmd.OpenForm "frmApplicationSearchResult", , , strFilter) Thanks

I have a database where a form with user-defined search criteria and the clicking of a Command Button opens another form with the results. What I would like to do is not open the form if there are no matching results and use a MsgBox instead. I asked this forum for guidance on writing the...

Well, I have to say (whilst stuffing my face with Humble Pie), that ignoring the complicated and persevering with the easy doesn't always work - and it didn't this time. Thanks to everyone for their help and suggestions, but Ranman256 had it - right off the bat! I have no idea why the simple...

Hi JHB, I did that, too, and it still doesn't work. Adding a shortcut on my desktop with that link works. Pasting the link in to a browser works Using the link in a On Click Event Procedure of a command button doesn't work, even if I do as you suggest. I'll try and On Click event for another...

Hi Minty, No, it doesn't. When I paste the resulting string in to IE address bar, it opens fine. This is definitely a weird one! Pete