Question Pop-Up Search Bar & Clickable Form Button? (1 Viewer)

kjb0419

New member
Local time
Today, 16:13
Joined
Jul 13, 2016
Messages
2
I'm very new to MS Access but I do understand the basics. I'm currently interning for a company who wants me to design a database that includes all the name of past projects, along with different books and vendor catalogs. They want this database to be searchable so that they can enter key words and then have more info on the book/catalog such as what's included in it and it's location within the library.

So....my question is how can I make it so that when the database is opened there is a popup that automatically comes up that simply just has a search bar/button that will bring up the results for key words that are entered. I'd also like another button which can be clicked to have the form come up to enter in a new catalog or book.

What I'm eventually going to do is make it so that the actual database window is minimized or hidden in the background so that only the "popup" is showing to give it a cleaner look. I have figured out how to do that but I'm just having trouble with the actual popup

I've included pictures of what the different tables/forms are that I'm working with currently. Any help would be greatly appreciated. Thank you for reading!
 

kjb0419

New member
Local time
Today, 16:13
Joined
Jul 13, 2016
Messages
2
Sorry, forgot the pictures
 

Attachments

  • 1.PNG
    1.PNG
    10.5 KB · Views: 100
  • 2.PNG
    2.PNG
    31.9 KB · Views: 108
  • 3.PNG
    3.PNG
    70 KB · Views: 106

GinaWhipp

AWF VIP
Local time
Today, 19:13
Joined
Jun 21, 2011
Messages
5,901
Well...
1. Please show the Relationships window so we can see who these tables are related to each other
2. You are using Reserved Words, i.e. Name, Category for field names, this will present problems. You're going to want to fix that now. Have a look at...

http://allenbrowne.com/AppIssueBadWord.html
http://www.utteraccess.com/forum/Access-Reserved-Words-t539419.html

On that same note, you have spaces in your field names, again, extra work down the road so please adjust. Have a look at...

For Naming Conventions see...
http://www.granite.ab.ca/access/tablefieldnaming.htm
http://www.access-diva.com/d1.html

3. Something like the below will work for a search (adjusting the field names to match your own) but I suggest you get your Tables in order first...

Code:
    Me.Filter = "fSubject Like '*" & Me!txtFilter & "*' OR " & _
                "fText Like '*" & Me!txtFilter & "*'" & " OR " & _
                "fKeywords Like '*" & Me!txtFilter & "*'"
    Me.FilterOn = True
 

Users who are viewing this thread

Top Bottom