December 5, 2008 12:26am pst

1. DanRollins 20,000
2. jkr 19,350
3. fridom 18,050
4. Gurudenis 6,900
5. alb66 5,750
6. TheLearn... 5,000
6. alexcohn 5,000
6. kaylanreilor 5,000
9. graye 4,000
9. LordOfPo... 4,000
11. jaime_oliv... 3,850
12. JohnGaby 3,800
13. AndyAins... 3,400
14. itsmeandn... 3,250
15. vachooho 2,620
16. Mikal613 2,500
16. weellio 2,500
16. BlueDevilF... 2,500
19. xuserx2... 2,000
19. ksuwolf 2,000
19. slam69 2,000
19. developm... 2,000
19. bobahop 2,000
19. Merete 2,000
19. Infinity08 2,000

1. jkr 48,100
2. fridom 24,350
3. DanRollins 22,000
4. alexcohn 7,500
5. Gurudenis 6,900
6. itsmeandn... 6,575
7. mahesh1... 6,500
8. TheLearn... 6,000
9. alb66 5,750
10. kaylanreilor 5,000
11. AndyAins... 4,900
12. graye 4,000
12. LordOfPo... 4,000
14. jaime_oliv... 3,850
15. JohnGaby 3,800
16. peterchen 3,600
17. vachooho 2,620
18. jasonclarke 2,500
18. weellio 2,500
18. BlueDevilF... 2,500
18. Mikal613 2,500
22. Infinity08 2,100
23. alexo 2,000
23. drichards 2,000
23. harfang 2,000
23. gelbert 2,000
23. DaveMon 2,000
23. angelIII 2,000
23. ksuwolf 2,000
23. shout77 2,000
23. sognoct 2,000
23. slam69 2,000
23. developm... 2,000
23. pjasnos 2,000
23. KCTS 2,000
23. ivanblue 2,000
23. surajguptha 2,000
23. stammencm 2,000
23. bobahop 2,000
23. roos01 2,000
23. Merete 2,000
23. sh0e 2,000
23. AlexFM 2,000
23. xuserx2... 2,000

08.03.2008 at 05:05PM PDT, ID: 23617751

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.0

Error message when trying to automate Access

Asked by MattOHPreserve in Microsoft Visual C#.Net, Windows ATL / WTL / COM Programming, .Net Editors & IDEs

Tags: c#, System.Runtime.InteropServices.COMException (0x800A0C07): The specified field '[Guar_Legal_Status_History].[Step]' could refer to more than one table listed in the FROM clause of your SQL statement.

I'm trying to automate the printing of an Access report via a C# app I've written. The application tries to open the Access report via the code below. The report pulls records from a query using the join below, plus the additional 'Step' and 'Outcome' where clauses. This works fine in Access. I can open both the query and view the report directly from Access but trying to do the same thing programmatically causes this "specified field '[Guar_Legal_Status_History].[Step]' could refer to more than one table listed in the FROM clause ". This seems odd since I specified the table and the field in the WHERE clause.

So what the heck could be wrong?

FROM ((Guarantors INNER JOIN
Accounts
ON Guarantors.ID=Accounts.Guarantor_ID) INNER JOIN
Guar_Legal_Status_History
ON Guarantors.ID=Guar_Legal_Status_History.Guarantor_ID) INNER JOIN
Most_Recent_Step
ON Guar_Legal_Status_History.Guarantor_ID=Most_Recent_Step.Guarantor_ID
WHERE Guar_Legal_Status_History.Status_Date=Most_Recent_Step.MaxOfStatus_Date;Start Free Trial

         
             oAccess.DoCmd.OpenReport(
    "Legal Process Approved",
    Access.AcView.acViewNormal,
    oMissing,
    "[Guar_Legal_Status_History].[Step]='" + strStep + "' AND " +
    "[Guar_Legal_Status_History].[Outcome]='" + strOutcome + "'",
    Access.AcWindowMode.acHidden,
    oMissing);

Keywords: Error message when trying to automat…

	Title
1	Legalizing drugs...???
2	PHP Inner Join thing...
3	Excel Automation
4	legalized xp corp version
5	outcome of an inner join query
6	Legalize marijuana?

Loading Advertisement...

20081112-EE-VQP-43 / EE_QW_2_20070628

Error message when trying to automate Access

Asked by MattOHPreserve in Microsoft Visual C#.Net, Windows ATL / WTL / COM Programming, .Net Editors & IDEs

Tags: c#, System.Runtime.InteropServices.COMException (0x800A0C07): The specified field '[Guar_Legal_Status_History].[Step]' could refer to more than one table listed in the FROM clause of your SQL statement.

About this solution