User Profile

Collapse

Profile Sidebar

Collapse
SurgeArrester
SurgeArrester
Last Activity: Nov 29 '13, 10:45 PM
Joined: Sep 26 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • There is a form called Calendar with a blank box where the calendar control should be! When you look at the properties, CalendarESBNG is an ActiveX control, which looks as if it was custom written, but is no longer being picked up by the database. The 'class' is ESBNGCalendar.E SBCalendar, rather than a more typical microsoft calendar class, which leads me to believe that whoever wrote the db modified or created their own activex calendar control....
    See more | Go to post

    Leave a comment:


  • When I start up the database in Access 2007, I get "run time error '438' - Object doesn't support this property or method".
    The offending code is as follows:
    Code:
    Sub Main_Form_Issue()
    Dim cal As Object
    DoCmd.OpenForm "Calendar", , , , , acHidden
    
    Set cal = [Forms]![Calendar]!CalendarESBNG
    
    
    If cal.ESBWeek < 10 Then
        [Forms]![main form]![Data Issue] = "1.0"
    ...
    See more | Go to post

    Leave a comment:


  • Thanks zmbd - I had seen some of those microsoft suggestions, but figured I'd ask on a forum such as this too!

    As far as I can see, there are some extra attributes assigned to the calendar object - for instance it will return the isoweek value based on the current date. ISO weeks sometimes start the last week of the previous year, or sometimes start two or three days into the new year. (Some years will have 53 ISO weeks, and other...
    See more | Go to post
    Last edited by zmbd; Sep 27 '13, 03:54 PM. Reason: [z{please format poste code/sql/formated text using the [CODE/] button}]

    Leave a comment:


  • Broken Calendar Control in MS Access 2007 - How can extra methods and attributes be a

    I have inherited an Access Database that seems to work in Access 2003 and earlier but not in 2007 and later, and the issue is around a custom-built calendar control which appears to be similar to the existing MS calendar control but with some extra methods added such as "cal.ISOWee k", "cal.ISODay ", based on ISO calendar system. There is no documentation for this control, and I've no idea who created it - probably long since...
    See more | Go to post
No activity results to display
Show More
Working...