Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / April 2005

Tip: Looking for answers? Try searching our database.

using filters in switchboard

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Shannie - 26 Apr 2005 15:45 GMT
I am creating a big project that will allow my company to access member
information.  I want to use a switchboard so that this is more user friendly
to those who will be using it.  In the switchboard I want there to be command
buttons to open and view member information and another to add member
information.  I have all of that created so far.  My problem is: I want to
apply a filter onto the command button of opening and viewing member
information.  This way, my users can click the command button, a screen will
come up and ask what they want to look for, they will tape in that member's
name and their 'file' will be pulled up.  
Is this impossible?
anonymous@discussions.microsoft.com - 27 Apr 2005 17:46 GMT
hi,
I've never heard of doing that with a filter but i suppose
it could be done. since your are using the word filter, i
assume you only have 1 table.
what i use is a criteria form. have the button on your
switchboard open the form.
the criteria form would have text boxes for name, other
and maybe checkboxes or options buttons to select what you
wanted to see. each checkbox would have it own query
assuming you wish to see data in different ways. depending
on what info you pull, each query may have it's own
report. or if you don't want the report, just have the
query come up in data sheet view.
but what i am discribing here may be more complex that you
want. maybe you could get by with a text box for name and
a go button.

>-----Original Message-----
>I am creating a big project that will allow my company to access member
[quoted text clipped - 8 lines]
>Is this impossible?
>.
Mike Revis - 30 Apr 2005 00:46 GMT
Hi Shannie,
I do something similar with my customer list.
I have a separate form for viewing/editing customer information.
In your case substitute "member" for "customer".
On my MainMenu (switchboard) I have a combo box that selects CompanyID,
CompanyName, CompanyStreet, CompanyCity and CompanyState.
In the afterupdate event of the combobox I have code that opens the customer
form to the customer name selected.
I also have a command button that opens the customer form to a new record.

That might work for you.

Mike

> I am creating a big project that will allow my company to access member
> information.  I want to use a switchboard so that this is more user friendly
[quoted text clipped - 6 lines]
> name and their 'file' will be pulled up.
> Is this impossible?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.