Hi,
I had a database created in 2003, the VBA that pulls the first problems when I try to open the form in 2010 is...
Private Sub Form_Load()
LngEmployeeID = 0
Me.CboEmployees.SetFocus
End Sub
Brings back a compile error saying it can not find project or library.
The part in questions seems to be LngEmployeeID = 0.
This also pops up in the VBA in this after update:
Private Sub CboEmployees_AfterUpdate()
Me.TxtNI = Me.CboEmployees.Column(2)
Me.TxtBand = Me.CboEmployees.Column(3)
Me.TxtPensionRate = Me.CboEmployees.Column(4)
Me.TxtPCT = Me.CboEmployees.Column(5)
Me.TxtID = Me.CboEmployees.Column(0)
Me.NonCont = Me.CboEmployees.Column(6)
LngEmployeeID = Me.TxtID
GetHistory
End Sub
I am using a form to select employees then enter payment information for them, this is then saved/submited to a query/table and I run queries to calculate how much tax, pension etc... they pay.
Does anyone have any ideas?
Thanks
Will
I had a database created in 2003, the VBA that pulls the first problems when I try to open the form in 2010 is...
Private Sub Form_Load()
LngEmployeeID = 0
Me.CboEmployees.SetFocus
End Sub
Brings back a compile error saying it can not find project or library.
The part in questions seems to be LngEmployeeID = 0.
This also pops up in the VBA in this after update:
Private Sub CboEmployees_AfterUpdate()
Me.TxtNI = Me.CboEmployees.Column(2)
Me.TxtBand = Me.CboEmployees.Column(3)
Me.TxtPensionRate = Me.CboEmployees.Column(4)
Me.TxtPCT = Me.CboEmployees.Column(5)
Me.TxtID = Me.CboEmployees.Column(0)
Me.NonCont = Me.CboEmployees.Column(6)
LngEmployeeID = Me.TxtID
GetHistory
End Sub
I am using a form to select employees then enter payment information for them, this is then saved/submited to a query/table and I run queries to calculate how much tax, pension etc... they pay.
Does anyone have any ideas?
Thanks
Will