Search results

*/1976 doesn't work, the rest do though so Thank you! Before I go with that - Rather than tell every user if they want to search for a date or year to miss out the 19 bit say of 1976 is there a way in code for to delete the parts So if 4 numbers appear after a / then delete the two numbers?

Hi, I was thinking of a user entering /1976 or even 09/1976, then a code spotting a / followed by 4 numbers and re writing it to a /76 . Don't think that is possible though? I'll have a play with matching the string and see if I can get that to play. Thank you for your helps so far

Another thought then, is there a way of changing /nnnn Where nnnn are numbers only to /nn in the text box before the query is opened? i.e. if somebody puts in the searchbox 18/01/1976 it is automatically reformatted to 18/01/76

Hi, if someone can help it would be greatly appreciated. I have a query which pulls up results based on the value of a text box. All works well except one field has a DOB (date) and if I search say for " /1976" I get no results, however search /76 and all the people with that year of birth...

Hi, I', trying to create a duplicate of a certain record in a table so that the user can then edit the new record - or old record even as it doesnt matter - as long as one of them is original. The idea is that any revisions / changes are stored the user may of made. Any thoughts or other work...