how is this example work, textbox search

[CBrighton]

And it's definitely still in the on click event, not the on double click event?

It works with a single click for me.

 

[woody]

write text to search .. click go to search here work fine and its display result..

now click showall .. and go again to search .here u will need to click twice on go button to search .

 

[CBrighton]

Nope, I can't reproduce this.

I searched & cleared as suggested but then whether I clicked search again right away or changed the contents of the textbox and then clicked search it worked after a single click.

Maybe it's unique to 2007? It's working correctly here on 2003.

 

[woody]

yes, i think i found the problem... after Click on ShowAllbutton.. .we must restore text-box search to default value.. Search Contacts

i don't know how to do that.. we need some code ..after this one
something to clearbox.

Me.Filter = ""
Me.FilterOn = False
cmdShowAll.Enabled = False

 

[CBrighton]

if you want to set it back to null then add:

SearchBox = Null

It might also be worth adding:

Searchbox.SetFocus

This would cause the textbox to get the focus after you click the show all button.

 

[woody]

SearchBox = ""
i add this.. but its still need Double click there..

 

[woody]

Oh... Still need Double Click.. after all that.. I don't know why
If u can talk with me on Skype .. and i can let u access to my PC with Teamveiwer and fix it from my PC..

thank u very much.

 

[CBrighton]

I thought it was unlikely that the contents of the textbox would define the amount of clicks required. Not sure what the problem is as it's not occuring for me. Have you changed it back from an mdb to an accdb? If so, see if the problem occurs when it's an mdb. If not, convert it and see if it occurs on the accdb.

FYI Searchbox = "" negates the If not IsNull(SearchBox) code as after the first search it will never be null.

That's why I suggested SearchBox = null.

 

[CBrighton]

Unfortunately I have no access to skype or a headset while at work.

 

[woody]

Do u have Teamviewer.. i can give u access to my pc now..
just give me your email. and i will send u the code

 

[CBrighton]

I have no remote desktop / VNC type software. Even if I did I don't have experience in 2007 so I would be as lost as you are (moreso infact).

 

[woody]

Ok Dear, Thanks a lot for your help.
I will try myself to fix that. but i see that GO button need to set to unFocus after click on..

can u tell me how ?

 

[CBrighton]

See the second code block in my earlier post:

if you want to set it back to null then add:

SearchBox = Null

It might also be worth adding:

Searchbox.SetFocus

This would cause the textbox to get the focus after you click the show all button.

You cannot remove the focus, you have to set the focus to something else.

 

[venu_resoju]

Hai...I am new to MS Access but I have created one attendance database, which contains Tables 1)Employees, 2)Attendance which is here with attached.
I have a form attendance which contain
1)EmpID
2)EmpName
3)AttendanceDate
4)Present (which is in AttendanceStatus Group)
5)Absent (which is in AttendanceStatus Group)
6)Save & New (Button)

I want to code the "Save & New" Button to store the values like "Present"/"Absent" at AttendanceStatus Field in Attendance Table and refresh the values to do new attendance in Attendance Form.
please anyone help me......

 

[CBrighton]

-Snip-

Please create a new thread for this in the appropriate section of the forum.

I would suggest the 'Forms' section.