Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 27th, 2004, 08:20 PM
Authorized User
 
Join Date: Sep 2003
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Default Trying to Place ActiveX Calendar Control on Form

I am attempting to add an ActiveX Calendar Control to my form, and I
keep getting the following error:

"The object doesn't contain the automation object '[vertical line].'

"You tried to run a Visual Basic procedure to set a property or
method for an object. However, the component doesn't make the
property or method available for automation operations.

"Check the component's documentation for information on the
properties and methods it makes available for automation operations."

FYI, I used the ActiveX Calendar Control that ships with Access and
it appears to be registered in Windows. I did not obtain the error
until I opened the Properties Window of the Calendar and then went
to the Visual Basic Editor to automate a task.

Thaks in advance for helping me correct this error.

David Tolson
aka dvdtolson



 
Old October 29th, 2004, 01:54 AM
Authorized User
 
Join Date: Jul 2004
Posts: 68
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to aravwind Send a message via Yahoo to aravwind
Default

whether u r using Microsofr Calender Control 8.0.
chk whether it is registered properly.

i tested by changing the color and some other property now.
It works fine.

My o/s: Windows2000 Proffessional
Visual Basic 6.0


i don't know if u r using som third party tools.
 
Old October 29th, 2004, 04:03 PM
Authorized User
 
Join Date: Sep 2003
Posts: 32
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am using the MS ActiveX Calendar Control 7.0 that shipped with Access 2002 XP.

Thanks,

David

 
Old October 29th, 2004, 07:29 PM
Authorized User
 
Join Date: Oct 2004
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts
Default

David-

It sounds like the control isn't registered properly. Frankly, I gave up on the ActiveX controls distributed with Access a long time ago. I now use a form designed as a calendar that I pop open from a command button. You can find a sample at http://www.viescas.com/Info/links.htm#Downloads. It's an Access 97 database, but you can convert it easily to a newer version.


John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"





Similar Threads
Thread Thread Starter Forum Replies Last Post
ActiveX Treeview Control in Access Form cej2583 Access VBA 7 March 18th, 2008 02:40 PM
locate winodws form in right place Medes Word VBA 1 June 5th, 2006 03:52 PM
Implementing ActiveX Control on Access Form JimmyNeutron Access VBA 2 November 2nd, 2005 01:33 AM
ActiveX Controls - Calendar Control, Note/Memo Con twsinc Access VBA 9 February 29th, 2004 07:51 AM
Calendar Control ActiveX - Where umagrama Access VBA 0 December 9th, 2003 01:42 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.