Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Sacramento, California, USA
    Posts
    491
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access Window Minimizes (WINXP - ACC 97)

    I'm not sure if this is an Access 97 issue, or WIN XP
    issue, so I'll start here !

    Ever since we've converted to WINXP from WIN2000, the
    following behavior started:
    After running this code, the Access Window minimizes by
    itself! I cannot see anywhere in my code that would do
    this. It only happens in XP.
    Any idea why? Is there a setting I a need to adjust in XP?

    Here is the code behind a button on a form:

    Private Sub cmdImportFiles_Click()
    DoCmd.TransferText acImportFixed, "CAP 2004", "POS-CAP", _
    "R:ABC HMOS 2004MyCompany 2004MAR 2004Text
    FilesABC132.DAT", False, ""

    Beep

    MsgBox "FILES HAVE BEEN IMPORTED", , "IMPORT COMPLETE"

    DoCmd.Close

    End Sub

    Thanks for any advice!!
    Michael
    .

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

    Re: Access Window Minimizes (WINXP - ACC 97)

    I haven't seen this, but I remember that Access 97 often lost focus when importing files or database objects (this was on Windows NT4)

Posting Permissions

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