Search results

Hi FoFa and Raskew Thanks for responding to my cry for help! FoFa - the values are representative of what is in the column but to be completely accurate its for a quotes database. Therefore it will read as: SSQ 1234 SSQ 1235 verbal4 SSQ 1236 verbal5 (Please note that there is a space between...

Thank you very much! Saved me a lot of grief:)

Hi I have been asked if it's possible to modify or set parameters when using Find i.e. when you hit CTRL + F in Access 2003 The question is can I use VBA code to modify things like the "Match" to be 'Any Part of Field' instead of defaulting to 'Whole Field' etc? Many thanks for your help!

Hi Thanks for the tip but unfortunately that didn't work either. I don't know if this is a problem but the format of the information is either: ABC 1234 ABC 1235 different4 ABC 1236 different5 the original code meant MyValue = "different5" but I need "ABC 1236" or higher when a higher value...

Hi I hope someone can help with this as I can't seem to get this query to work. I am trying to use a query to search for the highest value in a column but based upon a specific criteria. i.e. in the column will be ABC1234, ABC1235, ABC1236 and BBC1234 and I want to get the highes 'ABC' value...

Hi SammyJ Thanks for replying. This is basically a quotation system so we can enter VERBAL for a verbal quote but if a 'proper' quote is made a code is given to it eg ABC 0123 Therefore, we can have many 'VERBAL' quotes but we don't want to duplicate the codes. Unfortunately it's not possible...

Hi! I have a table where I need to check for specific duplicates when the user enters in some information. I looked at just using 'DISTINCT' with 'No Duplicates' but this won't work as I cannot get away from having some duplication i.e. the column in my table has this (and this represent...

Thanks Peter! Never done this before and was starting to hit my head against the wall! This works a treat! Mark :)

Thanks all!! All works great! This is the first real project I have done in Access so really appreaciate all the help! Mark

Yes getting back what expected Sales.Chase between #16/08/2004# And #02/11/2004# but after first run i then get dates from June???

Hi I am using the following vba / SQL to create a query which looks between two dates in a table. It seems to work first time but thereafter my query pulls back dates which are not in the criteria (dates are selected from Combo boxes - search_chasestartdate and search_chaseenddate): If...

Can't unlock Word after opening with Access Hi I am trying to close Word (i.e. closing Word manually) opened using Access but keep getting 'normal.dot' is locked and being used by another application (basically Access). How can I 'unlock' Word to allow users to close it? The code I am using...