Compile error: Can't find project or library - Windows 7 64 bit

Hi all,

I am soooo frustrated with issues running my project on Windows 7 64 bit PCs! The ActiveX controls needed registers on Windows 7 32 bit PCs, but not 64 bit.

So, I have changed my UserForm to make use of a Class Module cCalendar instead of DTPicker, to eliminate issues on the PCs of other users.

BUT, here is my new Windows 7 64 bit issue:

When I run my app, I first get this error:

Could not load some objects because they are not available on this machine

when I then click on OK, I get the following error:

Compile error: Can't find project or library

highlighting the project or library that cannot be found: FirstRowAdd (see attached image). This is part of this section of code:

Private Sub btnSave_Click()
Dim iRow As Long, LR As Long
Dim WS As Worksheet
Set WS = Worksheets("DataSheet - Fitness")

LR = Sheets("DataSheet - Fitness").Range("A" & Rows.Count).End(xlUp).Row
'Find first empty row in database
FirstRowAdd = FirstVisibleValue(ActiveSheet, 1)
If FirstRowAdd = "" Then FirstRowAdd = "$A$" & LR + 1
iRow = Range(FirstRowAdd).Row

'Check for an ID number

If Trim(Me.txtID.Value) = "" Then
  Me.txtID.SetFocus
  MsgBox "Please enter an ID Number"
  Exit Sub
End If

This ONLY happens on Windows 7 64 bit PCs.

I would really appreciate all your help in fixing this issue, as well as making my app compatible with ALL OS!

Thanks!

Originally Posted by Norie

Try unchecking the reference for Microsoft Windows Common Controls-2 6.0 (SP6).

Hi Norie, great idea. Where and how do I uncheck it?

Thanks! Can't test it this weekend, but will know Monday morning.

Cheers!