Results 1 to 4 of 4
  1. #1
    sut2 is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Jul 2012
    Posts
    2

    Calendar died with most recent Windows update

    I am running Windows 7 64 bit and MS Access 2002. I have a database that uses Calendar 7 that was working perfectly until the most recent Windows update. Now, I get error messages when trying to utilize the calendar. I get two different messages: Run-time error '91': Object variable or With block variable not set. When I click debug, it takes me to this code:


    Private Sub Calendar7_Click()
    multical.Value = Calendar7.Value
    multical.SetFocus
    Calendar7.Visible = False


    Set multical = Nothing
    End Sub


    I also get another error (Run time error '-2147352560 (80020010)': Method 'Value' of object '_CustomControl' failed", and when I click debug, it takes me to this code:


    Private Sub Combo3_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
    Set multical = Combo3
    Calendar7.Visible = True
    Calendar7.SetFocus
    If Not IsNull(multical) Then
    Calendar7.Value = multical.Value
    Else
    Calendar7.Value = Date
    End If
    End Sub


    I am a complete noob, but in searching, it appears it might have something to do with Active X. Can anyone help?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    At the top of your Form's Clas (code) module be sure you have:
    Code:
    Option Compare Database
    Option Explicit
    ...and then Debug>Compile and see what happens.

  3. #3
    sut2 is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Jul 2012
    Posts
    2
    Quote Originally Posted by RuralGuy View Post
    At the top of your Form's Clas (code) module be sure you have:
    Code:
    Option Compare Database
    Option Explicit
    ...and then Debug>Compile and see what happens.
    The code you suggested was already there. I tried Debug>Compile, and it returned: "Compile error: Variable not defined." and highlighted Calendar7 in this line: multical2.Value = Calendar7.Value of this code: Private Sub Calendar7_Click()multical2.Value = Calendar7.Value
    multical2.SetFocus
    Calendar7.Visible = False
    Set multical2 = Nothing
    End Sub

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I believe it is multical2 that is not defined.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Choose the row with the MOST RECENT date
    By taimysho0 in forum Queries
    Replies: 1
    Last Post: 05-14-2012, 02:35 PM
  2. Replies: 12
    Last Post: 02-09-2012, 02:27 PM
  3. Replies: 13
    Last Post: 07-18-2011, 10:05 AM
  4. Replies: 3
    Last Post: 07-15-2010, 05:53 PM
  5. most recent entries
    By tom4038 in forum Queries
    Replies: 0
    Last Post: 09-14-2009, 04:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums