Hi,

I'm working on a user form and it works great on hlaf the pc's in the
office, but not on others.

We are getting different Error Messages on Different PC's.
The Version of Excel we are using is 2000 SP3 Standard Corp Edition.

Some Error's are : All on Microsoft Visual Basic.

Compilation Error : Method or data member not found.
Compilation Error : Project or Library not Found.
Compilation Error : Thisworkbook

and for some :

Microsoft Forms -
Could not Load Some Objects because they are not available on this Machine

The code I'm using is

Private Sub DateArrived_CallbackKeyDown(ByVal KeyCode As Integer, ByVal
Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)

End Sub

If you can help, you'll save me a lot of head scratching

On the affected machines hav eyou looked in the VBE - Tools - References to
see if there are any missing references?
--
HTH...

Jim Thomlinson


"Stringhaussen" wrote:

Hi,

I'm working on a user form and it works great on hlaf the pc's in the
office, but not on others.

We are getting different Error Messages on Different PC's.
The Version of Excel we are using is 2000 SP3 Standard Corp Edition.

Some Error's are : All on Microsoft Visual Basic.

Compilation Error : Method or data member not found.
Compilation Error : Project or Library not Found.
Compilation Error : Thisworkbook

and for some :

Microsoft Forms -
Could not Load Some Objects because they are not available on this Machine

The code I'm using is

Private Sub DateArrived_CallbackKeyDown(ByVal KeyCode As Integer, ByVal
Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)

End Sub

If you can help, you'll save me a lot of head scratching

Note from my Calendar page

Excel 97-2007
It is possible you don't see it in the list, because it is installed with Access.
So if you don't have that program installed you possible don't have the control.
You can download the control if you don't have it (See link on the bottom of this page).

This is the page
http://www.rondebruin.nl/calendar.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Stringhaussen" wrote in message
...
Hi,

I'm working on a user form and it works great on hlaf the pc's in the
office, but not on others.

We are getting different Error Messages on Different PC's.
The Version of Excel we are using is 2000 SP3 Standard Corp Edition.

Some Error's are : All on Microsoft Visual Basic.

Compilation Error : Method or data member not found.
Compilation Error : Project or Library not Found.
Compilation Error : Thisworkbook

and for some :

Microsoft Forms -
Could not Load Some Objects because they are not available on this Machine

The code I'm using is

Private Sub DateArrived_CallbackKeyDown(ByVal KeyCode As Integer, ByVal
Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)

End Sub

If you can help, you'll save me a lot of head scratching

Hi Jim,

Thanks for replying, we checked all the references matched but still the
errors appeared.

Stringhaussen

"Jim Thomlinson" wrote:

On the affected machines hav eyou looked in the VBE - Tools - References to
see if there are any missing references?
--
HTH...

Jim Thomlinson


"Stringhaussen" wrote:

Hi,

I'm working on a user form and it works great on hlaf the pc's in the
office, but not on others.

We are getting different Error Messages on Different PC's.
The Version of Excel we are using is 2000 SP3 Standard Corp Edition.

Some Error's are : All on Microsoft Visual Basic.

Compilation Error : Method or data member not found.
Compilation Error : Project or Library not Found.
Compilation Error : Thisworkbook

and for some :

Microsoft Forms -
Could not Load Some Objects because they are not available on this Machine

The code I'm using is

Private Sub DateArrived_CallbackKeyDown(ByVal KeyCode As Integer, ByVal
Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)

End Sub

If you can help, you'll save me a lot of head scratching

Hi,

Thanks for getting back to me. I tried that file as I found it on another
post of yours. Still the problem remains. I've also tried it on a pc with
access installed and it didn't work there too, yet it works fine on about 50%
of the pc's in the office.

Stringhaussen

"Ron de Bruin" wrote:

Note from my Calendar page

Excel 97-2007
It is possible you don't see it in the list, because it is installed with Access.
So if you don't have that program installed you possible don't have the control.
You can download the control if you don't have it (See link on the bottom of this page).

This is the page
http://www.rondebruin.nl/calendar.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Stringhaussen" wrote in message
...
Hi,

I'm working on a user form and it works great on hlaf the pc's in the
office, but not on others.

We are getting different Error Messages on Different PC's.
The Version of Excel we are using is 2000 SP3 Standard Corp Edition.

Some Error's are : All on Microsoft Visual Basic.

Compilation Error : Method or data member not found.
Compilation Error : Project or Library not Found.
Compilation Error : Thisworkbook

and for some :

Microsoft Forms -
Could not Load Some Objects because they are not available on this Machine

The code I'm using is

Private Sub DateArrived_CallbackKeyDown(ByVal KeyCode As Integer, ByVal
Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)

End Sub

If you can help, you'll save me a lot of head scratching

Hi Ron,

Just to add, when I added this patch onto the pc's I found that the date
picker dissappreared. The code remained, the were just no longer visable on
the form.

"Ron de Bruin" wrote:

Note from my Calendar page

Excel 97-2007
It is possible you don't see it in the list, because it is installed with Access.
So if you don't have that program installed you possible don't have the control.
You can download the control if you don't have it (See link on the bottom of this page).

This is the page
http://www.rondebruin.nl/calendar.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Stringhaussen" wrote in message
...
Hi,

I'm working on a user form and it works great on hlaf the pc's in the
office, but not on others.

We are getting different Error Messages on Different PC's.
The Version of Excel we are using is 2000 SP3 Standard Corp Edition.

Some Error's are : All on Microsoft Visual Basic.

Compilation Error : Method or data member not found.
Compilation Error : Project or Library not Found.
Compilation Error : Thisworkbook

and for some :

Microsoft Forms -
Could not Load Some Objects because they are not available on this Machine

The code I'm using is

Private Sub DateArrived_CallbackKeyDown(ByVal KeyCode As Integer, ByVal
Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)

End Sub

If you can help, you'll save me a lot of head scratching

You use a Date picker I see now ?

Or a Calendar ?




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Stringhaussen" wrote in message
...
Hi Ron,

Just to add, when I added this patch onto the pc's I found that the date
picker dissappreared. The code remained, the were just no longer visable on
the form.

"Ron de Bruin" wrote:

Note from my Calendar page

Excel 97-2007
It is possible you don't see it in the list, because it is installed with Access.
So if you don't have that program installed you possible don't have the control.
You can download the control if you don't have it (See link on the bottom of this page).

This is the page
http://www.rondebruin.nl/calendar.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Stringhaussen" wrote in message
...
Hi,

I'm working on a user form and it works great on hlaf the pc's in the
office, but not on others.

We are getting different Error Messages on Different PC's.
The Version of Excel we are using is 2000 SP3 Standard Corp Edition.

Some Error's are : All on Microsoft Visual Basic.

Compilation Error : Method or data member not found.
Compilation Error : Project or Library not Found.
Compilation Error : Thisworkbook

and for some :

Microsoft Forms -
Could not Load Some Objects because they are not available on this Machine

The code I'm using is

Private Sub DateArrived_CallbackKeyDown(ByVal KeyCode As Integer, ByVal
Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)

End Sub

If you can help, you'll save me a lot of head scratching

Hi Ron,

I use a date picker. It's all sorted now I just added the mscomct2.ocx
control to each PC and it worked.

Thanks for you help.

Stringhaussen

"Ron de Bruin" wrote:

You use a Date picker I see now ?

Or a Calendar ?




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Stringhaussen" wrote in message
...
Hi Ron,

Just to add, when I added this patch onto the pc's I found that the date
picker dissappreared. The code remained, the were just no longer visable on
the form.

"Ron de Bruin" wrote:

Note from my Calendar page

Excel 97-2007
It is possible you don't see it in the list, because it is installed with Access.
So if you don't have that program installed you possible don't have the control.
You can download the control if you don't have it (See link on the bottom of this page).

This is the page
http://www.rondebruin.nl/calendar.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Stringhaussen" wrote in message
...
Hi,

I'm working on a user form and it works great on hlaf the pc's in the
office, but not on others.

We are getting different Error Messages on Different PC's.
The Version of Excel we are using is 2000 SP3 Standard Corp Edition.

Some Error's are : All on Microsoft Visual Basic.

Compilation Error : Method or data member not found.
Compilation Error : Project or Library not Found.
Compilation Error : Thisworkbook

and for some :

Microsoft Forms -
Could not Load Some Objects because they are not available on this Machine

The code I'm using is

Private Sub DateArrived_CallbackKeyDown(ByVal KeyCode As Integer, ByVal
Shift As Integer, ByVal CallbackField As String, CallbackDate As Date)

End Sub

If you can help, you'll save me a lot of head scratching