Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find Record (2002)

    I have the following code connected to a command button on my form
    DoCmd.RunCommand acCmdFind
    Is there a way so that when the find dialog box opens that the default for match is set to any part of the field? or is there a way to provide a text box for a user to enter data and then code to find the record containing the contents of that text box?
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Find Record (2002)

    For the first question, see for example ACC2000: How to Set Defaults for the Find and Replace Dialog Box (works for Access 2002 too, and can be adapted for use in VBA)

    For the second question, see for example <post#=243436>post 243436</post#>.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find Record (2002)

    Thanks. I was able to add the send keys command to my code and the default find option changed as I requested.

    Is there a way through my code to move the location of the find dialog box so that it opens up at the top of the screen so that it isn't covering the result that it finds?
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Find Record (2002)

    AFAIK, there is no built-in way to position the Find dialog. You would need to use Windows API calls, but I don't know how to do that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •