accessturtle
XL Guru but new in XS
- Local time
- Today, 09:27
- Joined
- Feb 26, 2010
- Messages
- 12
Hello to all Access Expert,
I am very new to MS Access but have a background in Excel, i understand that there is a good diffrence between Access and Excel. Now coming to the point: i have created a database to record all the incoming complaints for a comapny which is working fine but now i am facing a challange to create a Search form that will allow user to for possible matches, for example
[Text box] [combo box] [command button]
Text Box: I want user to type in whatever they want to search e.g Customer, Phone number, Complaint number etc i also want user to perform partial text search if they dont remember the entry.
Combo Box: In this i want user to make a selection in which field they want to search e.g Phone Number, Complaint number, Customer Name, Source etc etc by the way these are my field names in table
Command Button: This is pretty much self explaintory, a button to perform the search. Altough i also want user to press enter to perform search.
I have been searching this on the internet for past 2 days but cannot find anything,
Thank you in Advance
Access Turtle
I am very new to MS Access but have a background in Excel, i understand that there is a good diffrence between Access and Excel. Now coming to the point: i have created a database to record all the incoming complaints for a comapny which is working fine but now i am facing a challange to create a Search form that will allow user to for possible matches, for example
[Text box] [combo box] [command button]
Text Box: I want user to type in whatever they want to search e.g Customer, Phone number, Complaint number etc i also want user to perform partial text search if they dont remember the entry.
Combo Box: In this i want user to make a selection in which field they want to search e.g Phone Number, Complaint number, Customer Name, Source etc etc by the way these are my field names in table
Command Button: This is pretty much self explaintory, a button to perform the search. Altough i also want user to press enter to perform search.
I have been searching this on the internet for past 2 days but cannot find anything,
Thank you in Advance
Access Turtle
