Searching issues - possibly caused by windows 7?

[Chrisopia]

I have a search tool, which I have developped through previous threads on here, and it worked perfectly until I decided to upgrade my computer to windows 7. Now nothing happens...

I was wandering if there is a patch or add on or some setup I may have missed to avoid this problem.

I only know its the new laptop settings as none of the backups behave either....

Private Sub Form_Load()
Me.SearchBox.Value = Me.SearchBox.ItemData(1)
Me.Requery

End Sub

Private Sub Form_Open (Cancel As Integer)

Me.SearchBox.Value = Me.SearchBox.ItemData(1)
Me.Requery

End Sub

Private Sub Search_Change()
Dim vSearchString As String

Me.SearchHidden = Me.Search.Text
Me.SearchBox.Requery

End Sub

Private Sub SearchBox_AfterUpdate()

Me.Requery

End Sub

 

[dcb]

Have you checked your macro security - trust center
There is nothing in the code that would not work

 

[Chrisopia]

perfect, the macro setting was switched to "disable all marcos with notification"... yet it did not notify me...

after trying all other settings, the only one that would work is the Enable all Macros, which it tells me is highly dangerous... doesn't sound healthy?

Is there a way around it somehow?
​

 

[dcb]

Well if its your own DB and you are writing it in a specific folder then just add the folder in your trust center
We can only assume that you are not going to be writing a virus for yourself.... hee hee