Error 438:Object doesn't support this property or method

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A client has an Access 2000 database. The database was recently moved from a
Windows 2000 server to a Windows 2003 server. Now he gets the error when
clicking on a command button for this code.
Private Sub Form_Open(Cancel As Integer)

Me.cmbDateSelect.RowSource = Format(Now(), "dddd mm/dd") & ", " _
& Format(Now() + 1, "dddd mm/dd/yy") & ", " _
& Format(Now() - 1, "dddd mm/dd/yy") & ", ALL"
Me.cmbDateSelect = Format(Now(), "dddd mm/dd/yy")
applyFilter
Me.OrderBy = "priority, product_id, cust_shortname,
t_ship_schedule.order_nbr"
Me.OrderByOn = True
AXtruckSchedule.loadSchedule
End Sub

The debugger stops on the line AXtruckSchedule.loadSchedule

Any suggestions??Thanks
 
Mary:

Since the code is stopping on the AXtruckSchedule.loadSchedule line, can you
tell us what this line of code does? Is AXtruckSchedule an ActiveX control,
and if so, what type? Has the control been registered on the new server?
Any additional information would be helpful.


--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


A client has an Access 2000 database. The database was recently moved from a
Windows 2000 server to a Windows 2003 server. Now he gets the error when
clicking on a command button for this code.
Private Sub Form_Open(Cancel As Integer)

Me.cmbDateSelect.RowSource = Format(Now(), "dddd mm/dd") & ", " _
& Format(Now() + 1, "dddd mm/dd/yy") & ", " _
& Format(Now() - 1, "dddd mm/dd/yy") & ", ALL"
Me.cmbDateSelect = Format(Now(), "dddd mm/dd/yy")
applyFilter
Me.OrderBy = "priority, product_id, cust_shortname,
t_ship_schedule.order_nbr"
Me.OrderByOn = True
AXtruckSchedule.loadSchedule
End Sub

The debugger stops on the line AXtruckSchedule.loadSchedule

Any suggestions??Thanks
 
So how does one go about getting a control registered on the Windows 2003
Server? I have some code that sticks on anything ending in "$". Ex: Error$
 
"Things" ending with $ in VBA are usually functions. I'd check for missing
reference libraries.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
 
Back
Top