November 19, 2008 02:32am pst

1. vadimrapp1 111,150
2. LSMCons... 59,068
3. boag2000 22,525
4. matthews... 13,400
5. angelIII 13,325
6. peter57r 11,750
7. chapmandew 11,748
8. rorya 11,400
9. DatabaseMX 9,800
10. jimhorn 9,618
11. jimpen 8,875
12. kelvinsparks 7,825
13. TextReport 7,400
14. SidFishes 7,200
15. capricorn1 6,600
16. jmoss111 6,500
17. zorvek 6,000
17. mwvisa1 6,000
19. LPurvis 5,964
20. frankytee 5,350
21. adraughn 4,750
22. ee_rlee 4,500
23. nmcdermaid 4,400
24. harfang 4,100
25. ScottPletc... 4,080

1. vadimrapp1 111,150
2. LSMCons... 109,825
3. LPurvis 89,936
4. peter57r 80,586
5. rockiroads 44,447
6. capricorn1 39,518
7. SidFishes 37,544
8. jimhorn 36,229
9. stevbe 31,815
10. nico5038 26,250
11. thenelson 24,639
12. boag2000 22,665
13. angelIII 22,577
14. JDettman 20,743
15. matthews... 20,125
16. jefftwilley 19,800
17. harfang 19,172
18. DatabaseMX 16,950
19. Arthur_... 16,774
20. kelvinsparks 16,200
21. TextReport 15,950
22. jimpen 15,375
23. jadedata 12,677
24. shanesue... 12,514
25. chapmandew 11,748

10.11.2008 at 03:47PM PDT, ID: 23807034

	[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.4

Get Run-time Error '424': Object Required when trying to implement an ActiveX Merge Control in an MS Access Project

Asked by 4632474 in Microsoft ADP, MS SQL Server, Access Coding/Macros

Tags: Microsoft, MS Access, 2003, MS Access VBE, IE 6, Run-time Error '424': Object Required

I have a MS Access project that connects to an MSDE database on the same laptop. I also have the same MSDE located on a server. Merge replication is set up between the two and is currently controlled using Window Synchronization Manager. Works good. I want to place merge control in the Access project so that the endusers only need to use the Access project to initiate replication. I'm using the ActiveX Merge Control to try to do this. I found an article in SQL Server Magazine that uses the attached code. Listing 1 is a classmodule that allows access to the merge control's Status Event. Listing 2 is the merge replication function. When I run the Replication_Merge function in the VBE Immeadiate Pane I get the Run-Time error 424: Object Required. The 4th line of listing 2 "Set Merge_Control = New_Merge.SQlM" is highlighted yellow when I debug. The contents of the article are also attached.

ThanksStart Free Trial

         
           
             1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:

           
           
             LISTING 1: Creating a Class Module That Uses the Status Event
 
Public WithEvents SQlM As SQLMerge
 
Private Sub Class_Initialize()
   Set SQlM = New SQLMerge
End Sub
 
Private Sub Class_Terminate()
    Set SQlM = Nothing
End Sub
 
Private Function SQLM_Status(ByVal Message As String, ByVal Percent As Long) As SQLMERGXLib.STATUS_RETURN_CODE
    Debug.Print Message & " " & Percent & "% Done"
End Function
 
 
LISTING 2: The Replication_Merge Function
 
Public New_Merge As New clsMerge
 
Public Function Replication_Merge()
Dim Merge_Control As SQLMerge
Set Merge_Control = New_Merge.SQlM
    
 
With Merge_Control
	'Set the publisher properties
 
	.Publisher = "Your Server Name"
	.PublisherSecurityMode = DB_AUTHENTICATION
	.PublisherLogin = "sa"
	.PublisherPassword = ""
	.PublisherDatabase = "Pubs"
	.Publication = "pubs_to_MSDE"
    	
	.PublisherNetwork = TCPIP_SOCKETS
	.PublisherAddress = "www.yourcompany.com"
        
	'Set the distributor properties
	.Distributor = "Distributer Server Name"
	.DistributorSecurityMode = NT_AUTHENTICATION
    
	'Set your local subscriber properties
	.Subscriber = "The Local Machine Name/Server Name"
	.SubscriberSecurityMode = DB_AUTHENTICATION
	.SubscriberDatasourceType = SQL_SERVER
	.SubscriberLogin = "sa"
	.SubscriberPassword = ""
	.SubscriberDatabase = "pubs_local"
	.SubscriptionType = ANONYMOUS
    
    	.Initialize
	.Run
	.Terminate
End With
        
 
End Function

           
         

Attachments:

SQLMagArticle.doc (34 KB) (File Type Details)

SQL Magazine article InstantDoc# 8244

Keywords: Get Run-time Error '424': Obje…

	Title
1	ActiveX trouble
2	ActiveX on HTML
3	terminology of ActiveX <XXX>
4	register ActiveX control ?
5	how to merge text files into a single tex…
6	ActiveX Controls Are Gone

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_2_20070628

Get Run-time Error '424': Object Required when trying to implement an ActiveX Merge Control in an MS Access Project

Asked by 4632474 in Microsoft ADP, MS SQL Server, Access Coding/Macros

Tags: Microsoft, MS Access, 2003, MS Access VBE, IE 6, Run-time Error '424': Object Required

About this solution