How To Create a Search Button That Search in All Fields of a Database Table (1 Viewer)

Danyal

New member
Local time
Today, 03:15
Joined
Dec 1, 2013
Messages
6
Hello All!
I am new to MS Access!

I have design a database and a form to record the information of customer feedback.
The first thing I want is to search the record from the whole database.
Secondly I want to print that searched record.
And finally I want to make a Form Reset Button.
I have made a "Clear" button but it is not working correctly and removes the record from the database after saving.

Kindly resolve this issue
Thank you!

I have attached the database!
 

Attachments

  • Database1.zip
    64.5 KB · Views: 134

AlexHedley

Registered User.
Local time
Today, 10:15
Joined
Aug 28, 2012
Messages
171
The first thing I want is to search the record from the whole database.
There is a Search box at the bottom of the Form which you can use.
Or you could create your own.
http://www.599cd.com/tips/access/multi-field-search-form-like/?key=AlexForum

Secondly I want to print that searched record.
You could create a Report based on your current record and print that.
http://www.599cd.com/tips/access/open-report-specific-data/?key=AlexForum

And finally I want to make a Form Reset Button.
The Navigation buttons along the bottom allow you to go between records using the arrows.
There is a >* which will create a New Record.
 

Danyal

New member
Local time
Today, 03:15
Joined
Dec 1, 2013
Messages
6

You are amazing Bro!
But one thing more!
I have created a report but it shows all the records of the database.
I just want specific record and want to print it out.
Kindly Help!
I am very Thankful to you!

New Database Attached with report!
 

Attachments

  • Database1.zip
    79 KB · Views: 121

AlexHedley

Registered User.
Local time
Today, 10:15
Joined
Aug 28, 2012
Messages
171
The second link should do that.

You just need to create a Query that selects the single record you want. Base the Report on that Query then Print.
 

Danyal

New member
Local time
Today, 03:15
Joined
Dec 1, 2013
Messages
6
The second link should do that.

You just need to create a Query that selects the single record you want. Base the Report on that Query then Print.

Many Thanks Dude!
I have created a report which is displaying the specific record but I want it to show the records in List Box.
Kindly help out this problem!
This last time please help! :)

View the report and type in search box 'MIT' it will find all MIT records.
Database Attached!
 

Attachments

  • Database121.zip
    43.8 KB · Views: 110

Users who are viewing this thread

Top Bottom