Creating switchboard

[c0259621]

Hi Guys,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I need some help to create a very professional looking switchboard in access, where you can search information.<o></o>
<o></o>
If anyone can give me any useful websites or tutorials which will help me i would be very grateful.<o></o>
<o></o>
Thank you<o></o>

 

[Trevor G]

There is a switchboard form you can use, but I personally would add my own elements to a form.

What are you trying to do? You mention Searching Information. Do you mean something like, a number of text box and combos to drive searching or something completely different?

 

[c0259621]

Travor,

Thank you for your reply, I am making a switch board which will allow to search up clients based on several search text boxs, for example , by sex, age, education etc...

 

[Trevor G]

Travor,

Thank you for your reply, I am making a switch board which will allow to search up clients based on several search text boxs, for example , by sex, age, education etc...

I would look to create a form in design view, not attached to any query or table, then add the number of textbox's and/or combo box's you require and name each one through the properties, like:

txtSearchName
txtSearchAge
txtSearchGender

cboSearchName
cboSearchAge
cboSearchGender

If using combobox's you can get them to look at a table where the list of data is held, and then look in the properties at the row source and adjust the list so it will only show you single items rather than a continued list.

Next create a query to show the results, but in the criteria use the build wizard to select the search form and the elements as discribed above. You can use additional parameters to set the find correct detail.

Then add a command button to the form to open the query once you have selected from the combobox's or added your text entry.

I hope this will help you get started.

 

[c0259621]

Hi trevot,

Can you explain the above in more detail please?

Thank you

 

[Trevor G]

Hi trevot,

Can you explain the above in more detail please?

Thank you

Open your database and look to add a new form in design vew.

Then look at add new controls, if using Access 2003 you have a controls toolbox toolbar, if using 2007 you would look to use the Design Tab and then select textbox.

You would add as many textbox tools as you need. Each one you should name so when creating the query you can identify the objects to check.

So say you add a single textbox, then open the properties for that textbox (Use right mouse button on the textbox and select properties). Under the All Tab at the top you can rename the object, so name it with txt and then give it a name, so I suggested something like: txtName.

At this stage svae your form, (you can use F12 on the keyboard as this takes you to Save As). Name the form frmSearch.

Now you need to create a query. So press F11 on the keyboard this will bring the Database Window to the front if using 2003, if using 2007 then just select the Create Tab.

New Query would include the table you need, then add the fields, once selected in the Persons Name field select the criteria and then look for an icon which when you place the mouse on top it will say build wizard. In the feature you would search down the list on the left to find the form you have created and then once you double click it in the middle column you need to select the field which in this example would be txtName. Then click OK.

Save the query like qrySearch. Then close the query.

Back on the form you would add a command button to open the query you just created, when you enter a persons name in the text box it should filter the query showing you just the people with that name.

You would then repeat this to give you the other fields to use as a search tool.

I hope this helps you.

 

[c0259621]

Thank you Trevor,

One last question, for example on the form when searching say all the textbox were not filled in for example hieght was left out would the query still run?

I want the query to be run based on what ever is filled

 

[Trevor G]

You would need to add something like this in the criteria to each field in the query.

Like "*"& [TxtName]&"*"

To each element in your query that should give you the options you need, either they are all completed or not.