search (1 Viewer)

[jeannier1975]

Good day, i have a form that i use i have search function in that form it works but there one problem it only allows me to search once i have close the form and restart the form

 

[theDBguy]

Hi. What happens when you search the second time? Do you get any errors? Or, were the result the same as the first search? Or something else?

 

[jeannier1975]

when i search it blank again only i can search again if i close the form

 

[jeannier1975]

i can send u my file if you like

 

[theDBguy]

i can send u my file if you like

Sure, can you post it here?

 

[jeannier1975]

here my file.

 

[theDBguy]

here my file.

Hi. Thanks. Since I am not familiar with your database, can you please give me a step by step instructions on how to duplicate the issue? I tried your form, but I'm not sure I am using it correctly.

 

[jeannier1975]

u open form in area on top select department then go to search button click on it .
project numbers populate in search list box double click on the number it pulls data up.
hit clear to clear search results
now i want to entere another search but it dont work

 

[jeannier1975]

i need i think but not sure how to do it once you hit clear it reloads the form.

 

[theDBguy]

u open form in area on top select department then go to search button click on it .
project numbers populate in search list box double click on the number it pulls data up.
hit clear to clear search results
now i want to entere another search but it dont work

Sorry, I'm still lost. This is the only form in your db. Where is the "search" button to click?

 

[jeannier1975]

go to cheese line 1 there no projects in admin

 

[jeannier1975]

 

[theDBguy]

go to cheese line 1 there no projects in admin

Okay, so I select Cheese Line 1 and then click on the Search button and got four (4) numbers as a result. What should I do next to see the problem?

 

[jeannier1975]

right now i have work around but it not what i want i put in on clear button, it not what i want to do but it works another is how do i stop user from erasing the first search with backspace button

Private Sub cmdClear_Click()
cboDept = ""
cboTEch = ""
txtCapaNo = ""
StartDate = ""
EndDate = ""
txtKeyword = ""
AndOrCombo = ""
ProjNoSearch = ""
ProjectNoList.RowSource = ""
ResetControlObjects Me
DoCmd.Close
DoCmd.OpenForm ("TrackerProjectF"), acNormal



End Sub

 

[theDBguy]

right now i have work around but it not what i want i put in on clear button, it not what i want to do but it works another is how do i stop user from erasing the first search with backspace button

Private Sub cmdClear_Click()
cboDept = ""
cboTEch = ""
txtCapaNo = ""
StartDate = ""
EndDate = ""
txtKeyword = ""
AndOrCombo = ""
ProjNoSearch = ""
ProjectNoList.RowSource = ""
ResetControlObjects Me
DoCmd.Close
DoCmd.OpenForm ("TrackerProjectF"), acNormal



End Sub

Hi. I'm trying to help you, but since I am not familiar with your database (I don't use it everyday), I can't do that until I understand how it works. So, as I said above, I selected Cheese Line 1 and clicked on the search button to get four numbers in the result. What do I do next to see the problem you're seeing, which I really don't know what that (the problem) is yet.

 

[jeannier1975]

double click on the one of the numbers
then record pulls up

 

[jeannier1975]

then when you hit clear to enter a new search instance nothing happens

 

[theDBguy]

double click on the one of the numbers
then record pulls up

Okay, done. It did. Now what's next... and what is supposed to happen?

 

[jeannier1975]

when u hit clear and enter new department to search nothing happens it suppose to pull all project numbers for that department

 

[theDBguy]

then when you hit clear to enter a new search instance nothing happens

You mean the "Clear" button at the top, right? When I clicked it, it emptied out all the search terms and the result. What else is supposed to happen?