Results 1 to 13 of 13
  1. #1
    New Lounger
    Join Date
    Jul 2005
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Switchboard Search Option (Office 2003)

    This should be really simple.. [img]/forums/images/smilies/smile.gif[/img] I have a database called "Software".. I want to create a switchboard option that searches all the fields in "Software" by the criteria the user inputs. Then open the results in a table or in a form. For some reason this is puzzling me.

    Thank you for all your help
    Conz

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Switchboard Search Option (Office 2003)

    Normally, a database may contain multiple tables, so it's hard to know exactly what you're trying to do when you say you have a "database" called Software and want to search it. Do you mean that you have a table called Software and want to search it, or do you want to search on multiple tables (through a query) based on some criteria? You usually present data in a form or datasheet view, which can be accomplished with either a query or a form, but you need to provide more information.

    Are you using the wizard to build an Access switchboard, which is table-driven, or do you have another kind of form you are using as a switchboard? What kind of criteria will the user be entering and how did you intend to capture that input?
    Charlotte

  3. #3
    New Lounger
    Join Date
    Jul 2005
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Switchboard Search Option (Office 2003)

    Thank you for your reply.
    I have a table called Software. I just want to search all fields in that table, with a search field on my switchboard.

    Thank you again.
    Conz <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35> <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Switchboard Search Option (Office 2003)

    What about Charlotte's question
    <hr>Are you using the wizard to build an Access switchboard, which is table-driven, or do you have another kind of form you are using as a switchboard?<hr>
    The switchboard as created by the Switchboard Manager isn't really meant for searching a table, it is intended as a generic menu system for a database.

  5. #5
    New Lounger
    Join Date
    Jul 2005
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Switchboard Search Option (Office 2003)

    Okay - how about a pop up? <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Switchboard Search Option (Office 2003)

    You can create a form based on the table (you can use the Wizard or an AutoForm, if you like), and open this from one of the options of the Switchboard.
    The Standard toolbar has a search button, so there is no real need to provide extra functionality.

  7. #7
    New Lounger
    Join Date
    Jul 2005
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Switchboard Search Option (Office 2003)

    My preference is to have the database open with a search field that will search my whole software table. Is there some way to accomplish this? I would prefer the results either in a table or form? Thank you again for your response. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Thank you,
    Conz <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35> <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Switchboard Search Option (Office 2003)

    As Charlotte pointed out, your terminology is confusing.
    - A database is the entire .mdb file, containing tables, queries, forms, reports, macros and modules.
    - A field is a column in a table or query.

    It is relatively easy to create a form with a text box in which the user can enter a word or phrase, and to use this to search of filter the table on a single field, or if really necessary, across two or three fields. If you want to search across all fields, it is much easier to use the built-in Search dialog (Edit | Find...).

  9. #9
    New Lounger
    Join Date
    Jul 2005
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Switchboard Search Option (Office 2003)

    Thank you again for your reply. I have a database "software support", when one of the users double-clicks on the "Software support" database (it should auto-launch Access), I want it to open with a search textbox (instead of just opening with a switchboard). I would like the function of the text box to be that it searches the entire table labeled "Software"

    Thank you again,
    Conz

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Switchboard Search Option (Office 2003)

    Do you really want to search across all fields (columns) in the Software table? Can't it be narrowed down to a few fields?

  11. #11
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Switchboard Search Option (Office 2003)

    Surely all fields don't contain the same kind of information, so what kind of a search do you envision? What would the user be searching *for*? What kind of data is entered in the table in the first place.

    It is quite possible to search all fields using the built in find tools. but there are undoubtedly fields (like the primary key) that need not be searched on. <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29> If you have, for example, a field that lists the type of record and is a fixed list, you could present a combobox so the user could search for a particular type of record. Without details on what you need to accomplish with this, it is very hard to offer useful suggestions.
    Charlotte

  12. #12
    New Lounger
    Join Date
    Jul 2005
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Switchboard Search Option (Office 2003)

    <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35> This is a database of computer troubleshooting tips. There is a a field for
    "catagory" - meaning is this related to a Raid drive? or Anti-virus?
    "Title of software or hardware component" - meaning is it a maxtor hard drive or Norton anti-virus or Macafee?
    "error Message" - this is a bulk of information - this contains troubleshooting tips, error information ect. This is a memo box
    "secondary cause" meaning is there another piece of hardware or software that is interfering?
    "Link" - for Hyperlinks to article describing fixes
    "Blue screen errors" - this is a for those lovely blue screen errors.

    Basically, if I had to choose, I would search, error message, title of software/hardware, secondary cause..

  13. #13
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Switchboard Search Option (Office 2003)

    Create a form based on your table, for example a continuous (tabular) form.
    Place a text box txtFilter (not bound to any field) in the form header section, and a command button cmdFilter next to it.
    Create an On Click event procedure for the command button:
    <code>
    Private Sub cmdFilter_Click()
    Dim strFilter As String
    If IsNull(Me.txtFilter) Then
    Me.Filter = ""
    Me.FilterOn = False
    Else
    strFilter = "[catagory] Like '*" & Me.txtFilter & "*' Or " & _
    "[Title of software or hardware component] Like '*" & Me.txtFilter & "*' Or " & _
    "[error Message] Like '*" & Me.txtFilter & "*' Or " & _
    "[secondary cause] Like '*" & Me.txtFilter & "*' Or " & _
    "<!t>[Link]<!/t> Like '*" & Me.txtFilter & "*' Or " & _
    "[Blue screen errors] Like '*" & Me.txtFilter & "*'"
    Me.Filter = strFilter
    Me.FilterOn = True
    End If
    End Sub
    </code>
    Note: check the field names carefully (isn't 'catagory' a typo?)
    Save this form.
    Select Tools | Startup...
    Specify the form you created as form to display when the database is opened.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •