Search results

  1. H

    CTRL + F Mods

    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!
  2. H

    Finding ABC

    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...
  3. H

    Problem with duplicates

    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...
  4. H

    Between dates works once then goes wrong

    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...
  5. H

    closing Word Document

    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...
Back
Top Bottom