If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need an unbound text box and command button (Search)
I need to create an unbound text box with a command button (Search) on my
form which will enable the user to find the current record for a space no. I would like the user to only have to type in the space no. My fields a SpaceNo Current "Yes" I am not experienced at writing code. Thanks so much. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200911/1 |
#2
|
|||
|
|||
Need an unbound text box and command button (Search)
On Wed, 25 Nov 2009 23:09:36 GMT, "Uschi via AccessMonster.com"
u25116@uwe wrote: If you don't write code, it may be easier to instruct the users to hit Ctrl+F on the SpaceNo field, and enter the value they want to search for. -Tom. Microsoft Access MVP I need to create an unbound text box with a command button (Search) on my form which will enable the user to find the current record for a space no. I would like the user to only have to type in the space no. My fields a SpaceNo Current "Yes" I am not experienced at writing code. Thanks so much. |
#3
|
|||
|
|||
Need an unbound text box and command button (Search)
Tom,
Many thanks for your quick reply. My users have limited computer skills. The Find command is creating a BIG problem because they do not always pay attention to when the current record for that space comes up. The current record has a check mark (Current, if checked). I thought it would be more user friendly if they could just type in the space no into a text box (Please enter space no) and then click a SEARCH button (search will bring up the current record for that space). For their purpose they only need to find the current record for a space no. Also, I do not want them to click into the SpNo field. Once they click into it they start typing! If not corrected, then that record will have a different space no. I had to reposition and redesign the SpNo field on the form to make it look different from the others to discourage that. Tom, would you help me with the code for the Search button? It would be appreciated. I have looked through the threads and I haven't found anything I think I could use. Thank you, Uschi Tom van Stiphout wrote: If you don't write code, it may be easier to instruct the users to hit Ctrl+F on the SpaceNo field, and enter the value they want to search for. -Tom. Microsoft Access MVP I need to create an unbound text box with a command button (Search) on my form which will enable the user to find the current record for a space no. I [quoted text clipped - 7 lines] Thanks so much. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200911/1 |
Thread Tools | |
Display Modes | |
|
|