WIN XP and ACC 97

  • Thread starter Thread starter Michael A
  • Start date Start date
M

Michael A

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 form 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 seting 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 2004\MyCompany 2004\MAR 2004\Text
Files\ABC132.DAT", False, ""

Beep

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

DoCmd.Close

End Sub

Thanks for any advice!!
Michael
 
Thank you Mr. Steele -
I tried the import with a .txt file and the same behvaior.
The files (dat) import fine, it's just that when the code
finishes running, the Access window minimizes on its own.
Have you ever seen this behavior?

Regards,
Michael
 
Nope, I've never seen that behaviour before. Hopefully someone else will
chime in. If not, you might try reposting your question in a day or two.
 
Back
Top