Calendar not working in New Win7 Machine

[evanhughes]

Hi all

I have a database created in access 2010 on win xp.
I have calendars on some forms that pop up when date field selected and it works well.

My problem is that on new machine with windows 7 and access 2010 you get a debug message pops up when date field selected but is still fine on xp machines.

What do I need to do to have them function on all platforms the same.

Evan

 

[boblarson]

What is the message that pops up?

 

[evanhughes]

Dear Bob

When selecting the date field instead of a calendar popping up I get a debug message for the vba code that loads the message.

Is there some setting that disables vba like macros in excel. I have no idea as it works fine on all xp machines with access 2007 and 2010 just not the one with access 2010 and windows 7.

Evan

 

[boblarson]

Again I must ask - does the Windows 7 computer have Windows 7 SP1 or is it without the Service Pack. There is intent in this question.

 

[evanhughes]

Dear Bob

The forms work ok in access 2010 on win xp but when run on win7 sp1 with access 2010 i get this message.

Runtime error 2683
There is no object in this control.

And the debug shows the following line (coloured red) as the error.

Private Sub Combo7_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
' Show Calendar and set its date.
Calendar.Visible = True
Calendar.SetFocus
' Set to today if OrderDate has no value.
Calendar.Value = IIf(IsNull(Combo7), Date, Combo7.Value)
End Sub

Regards

Evan

 

[missinglinq]

It sounds as if this is an ActiveX calendar. If so check to see if you have a missing reference.

And why not use the built-in calendar offered in Access 2007/2010?

Also, why in the world is this being done in a Combobox MouseDown event?

Linq ;0)>