Hi friends,
I have a small Access 2007 database application for storing record of patients at a small health center. I have been using it for sometime and wish to include a search functionality to it. After adding the new lines of code the application now behaves strangely when the search button is clicked. I get this error message (Error in loading Dll). The code i added is shown below:
I also noticed that pops up the code window in debug mode when i try clicking the OK button of the error message window repeatedly. In the code, i realized that "Btn" in the first line of code has been changed to "Bnt" and always comes back when i try correcting it. Please any form of help on this will be greatly appreciated. I just don't know what to do any more.![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)
I have a small Access 2007 database application for storing record of patients at a small health center. I have been using it for sometime and wish to include a search functionality to it. After adding the new lines of code the application now behaves strangely when the search button is clicked. I get this error message (Error in loading Dll). The code i added is shown below:
Code:
Private Sub Btn_Search_Click()
Dim suchstr As String
suchstr = InputBox("Enter the Patient Last Name to be found", "Search by Last Name", "A")
If suchstr <> "" Then
suchstr = suchstr & "*"
Me![Ufo_Patientenliste].Form.Filter = "PLastName Like '" & suchstr & "'"
Me![Ufo_Patientenliste].Form.FilterOn = True
Else
Me![Ufo_Patientenliste].Form.FilterOn = False
End If
End Sub
I also noticed that pops up the code window in debug mode when i try clicking the OK button of the error message window repeatedly. In the code, i realized that "Btn" in the first line of code has been changed to "Bnt" and always comes back when i try correcting it. Please any form of help on this will be greatly appreciated. I just don't know what to do any more.
![Confused :confused: :confused:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f615.png)