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

M

maryj

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
 
D

David Lloyd

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
 
C

Cornfused

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$
 
L

Linq Adams via AccessMonster.com

"Things" ending with $ in VBA are usually functions. I'd check for missing
reference libraries.
 
Top