Problem with running processes in the background when a dialog form opens

  • Thread starter spargoje via AccessMonster.com
  • Start date
S

spargoje via AccessMonster.com

I have created a frm_Please_Wait form that is called when an import button is
clicked on another form.

CODE:
Private Sub cmd_Import_Click()
DoCmd.OpenForm "frm_TWP_SYSTEM_ IMPORT_ PROCESSING", , , , , acDialog
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97,
"Project_Doc_and_Review_1_1"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97,
"Testing_and_QA_Sign_Off_1_2"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97,
"tblTraining_Signoff_1_3",
END CODE

The problem is when the frm_Please_Wait appears it STOPS the processing of
the imports until I click the close button (x) of the frm_Please_Wait form.
When the frm_Please_Wait form disappears, the import process beginsd. How
can I keep the frm_Please_Wait open and still have the import processing in
the background to continue?

I have tried the me.repaint method but i think i do not have the correct
syntax to make it work. are there any other suggestions. Could someone please
help me. I would really appreciate it. Thnaks so much. My email address is
spargoje[AT]washpost[DOT]com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 versus Access 2007 Excel Import 0
import and update file in my form 1
Importing Spreadsheets dropping five rows 1
Start a process after form opens and displays? 3
Import button issue in the form 4
Error Handling on using Common Dialog... 2
Synchronization problems while moving folders to new email 1
import excel files 1

Top