August 30, 2008 01:23am pdt

Home
Why It Works
All Zones
Testimonials

Microsoft
Apple
Internet
Gamers
Digital Living
Virus & Spyware
Hardware
Software
ITPro
Developer

Storage
OS
Database
Security
Programming
Web Development
Networking
Other

Google Search EE Search

Announcements Feedback

Home
Microsoft
Development
MS Access
Access Architecture/Design
Variant vs. Control type in "For Each..." statement

Username or Email Password

Remember Me

Sign Up
Forgot Password?

1. LSMCons... 134,175
2. boag2000 133,590
3. capricorn1 113,175
4. DatabaseMX 76,689
5. peter57r 70,551
6. harfang 41,526
7. jimhorn 38,854
8. matthews... 34,872
9. hnasr 18,075
10. GRayL 16,347
11. MikeToole 15,650
12. LennyGray 14,955
13. RgGray3 14,896
14. jefftwilley 14,700
15. frankytee 14,550
16. JDettman 13,352
17. clarkscott 12,710
18. wiswalld 11,200
19. kelvinsparks 10,760
20. Arthur_... 10,550
21. nexusnation 10,400
22. eghtebas 10,000
23. omgang 9,375
24. jmoss111 9,150
25. koutny 8,675

1. LSMCons... 199,290
2. capricorn1 156,183
3. DatabaseMX 152,047
4. boag2000 141,565
5. peter57r 113,005
6. matthews... 63,206
7. jimhorn 62,872
8. harfang 60,506
9. jefftwilley 60,468
10. GRayL 36,779
11. JDettman 33,627
12. frankytee 31,442
13. MikeToole 29,650
14. dqmq 22,560
15. stevbe 21,852
16. kelvinsparks 20,260
17. mbizup 20,200
18. rockiroads 19,250
19. hnasr 18,075
20. puppydog... 17,545
21. LPurvis 16,625
22. LennyGray 14,955
23. RgGray3 14,896
24. Arthur_... 14,650
25. jmoss111 13,750
25. adraughn 13,750

07.24.2008 at 11:39AM PDT, ID: 23593296

	[x] Attachment Details

Variant vs. Control type in "For Each..." statement

Asked by midfde in Microsoft Access Database, Access Architecture/Design

Tags: VBA, Object required

Please see the attached image and explain the results - the first "Print" request succeds, and the second "For Each..." (not "Debug.Print") raises error.Start Free Trial

Attachments:

-.bmp (238 KB) (File Type Details)

Demo MS Access application

Keywords: Variant vs. Control type in "For Each…

	Title
1	Blu Ray options
2	Debug.Print Question
3	Why Variant
4	Debug.Print
5	debug.print
6	Debug.Print

Loading Advertisement...

[+][-]07.24.2008 at 11:46AM PDT, ID: 22082238

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

[+][-]07.24.2008 at 12:02PM PDT, ID: 22082400

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

[+][-]07.24.2008 at 12:12PM PDT, ID: 22082488

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

[+][-]07.24.2008 at 12:18PM PDT, ID: 22082554

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

[+][-]07.24.2008 at 12:27PM PDT, ID: 22082641

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

[+][-]07.24.2008 at 06:33PM PDT, ID: 22085288

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

[+][-]07.24.2008 at 06:36PM PDT, ID: 22085299

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

[+][-]07.24.2008 at 06:59PM PDT, ID: 22085385

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

[+][-]07.24.2008 at 10:50PM PDT, ID: 22086216

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

[+][-]07.25.2008 at 04:44AM PDT, ID: 22087560

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

[+][-]07.25.2008 at 07:01AM PDT, ID: 22088627

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

[+][-]07.25.2008 at 07:14AM PDT, ID: 22088781

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

[+][-]07.25.2008 at 07:20AM PDT, ID: 22088829

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

[+][-]07.25.2008 at 07:52AM PDT, ID: 22089100

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

[+][-]07.25.2008 at 05:38PM PDT, ID: 22093150

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

[+][-]07.26.2008 at 05:50AM PDT, ID: 22094892

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

About this solution

Zones: Microsoft Access Database, Access Architecture/Design

Tags: VBA, Object required

Solution Provided By: boag2000

Participating Experts: 2

Solution Grade: B

[+][-]07.28.2008 at 10:33PM PDT, ID: 22108834

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

[+][-]07.28.2008 at 10:37PM PDT, ID: 22108843

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

[+][-]07.29.2008 at 05:01AM PDT, ID: 22110541

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

About Us|
Contact Us|
Member Agreement|
Internet Rank|
Privacy Policy|
Site Map