Automatic answers in a Macro

Automatic answers in a Macro

Post by Douglas J. » Fri, 27 Aug 2004 23:56:52

Pick the SetWarnings action, with WarningsOn set to No before you run the
queries. Don't forget to set the warnings back on when you're done.

Doug Steele, Microsoft Access MVP
(no e-mails, please!)

there a

1. How do I only get valid "answers" in a VLOOKUP function (no #N/A's

2. excel - macro - automatic initiation of a macro at a pre-specified "system time"

i am working on developing a test to be administered to a candidate.

how can control the process by time. when the test-taker clicks th
"start test" button, i can record the "system time" (DateTimeStart) a
that moment. but how do i ensure that at the end of a pre-specifie
duration, that is when "system time" becomes = DateTimeStart
TestDuration, a macro is initiated automatically which will end th

am a novice in macro code writing. would appreciate if you can use
beginner's language in your respnse. many thanks

3. using automatic macros or object macros

4. RE--Automatic fill in's

5. Preventing automatic fill-ins

6. Automatic Updates Office 2003: KB957835 and KB951535 failed to ins

7. plug ins to make automatic rotation image

8. Automatic sign-ins from the start bar

9. Automatic fill in's

10. GPO Setting Configure Automatic Updates = 3 vs Update Approval Ins

11. IE8 automatic configuration (ins)

12. FAQ - Answers answers and answers :)

13. Excel Add-ins and personal macros don't load when opening files on

14. Access macros in add-ins

15. Macros Add-ins