Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Macros > URGENT: get mac...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 6 Topic 5618 of 5947
Post > Topic >>

URGENT: get macro to pause, get module to run

by =?Utf-8?B?dGhlaW50ZXJu?= <theintern@[EMAIL PROTECTED] > Jul 10, 2008 at 11:30 AM

I have a macro called TriFilter2.  I need it to pause midway for about 10 
seconds, then continue on.  So, i was advised to make it a module.  I did 
(via the convertor).  Then i created a macro to run it, using RunCode and
the 
module name.  but nothing happens when i run the macro.  below is code for

the module.  even if i take the Wait() out, it still doesn't work.  i'm on

Access 2007.

Option Compare Database

'------------------------------------------------------------
' TriFilter2
'
'------------------------------------------------------------
Public Function TriFilter2vba()

    DoCmd.SetWarnings False
    DoCmd.OpenQuery "SMquery", acViewNormal, acEdit
    DoCmd.OpenQuery "PIPquery", acViewNormal, acEdit
    DoCmd.OpenQuery "PLBquery", acViewNormal, acEdit
    Call Shell("""C:\Program Files\Microsoft Office\OFFICE11\WINPROJ"" 
""C:\Do***ents and Settings\deckers\Desktop\Take-off""", 1)
    Call Shell("""C:\Program Files\Microsoft Office\Office12\POWERPNT"" 
""C:\Do***ents and Settings\deckers\Desktop\ScheduleOutput.pptm""", 1)
    DoCmd.SetWarnings True

End Function

Publice Funcion Wait()
    waitTime = 10
    Start = Timer
    While Timer < Start + waitTime
        DoEvents
    Wend
End Function

thanks
scott
 




 6 Posts in Topic:
URGENT: get macro to pause, get module to run
=?Utf-8?B?dGhlaW50ZXJu?=   2008-07-10 11:30:26 
RE: URGENT: get macro to pause, get module to run
=?Utf-8?B?dGhlaW50ZXJu?=   2008-07-10 11:34:02 
RE: URGENT: get macro to pause, get module to run
=?Utf-8?B?dGhlaW50ZXJu?=   2008-07-10 12:09:01 
RE: URGENT: get macro to pause, get module to run
=?Utf-8?B?dGhlaW50ZXJu?=   2008-07-10 12:11:10 
Re: URGENT: get macro to pause, get module to run
Steve Schapel <schapel  2008-07-11 12:04:58 
Re: URGENT: get macro to pause, get module to run
=?Utf-8?B?dGhlaW50ZXJu?=   2008-07-14 06:45:04 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Nov 21 13:26:18 CST 2008.