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
http://www.yqcomputer.com/
(no e-mails, please!)





those
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
test.

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