Ability to search by two fields

[nuno1340]

Hi...


I am in the process of building an Access database to hold all of my projects.

Being new to Acesss I have managed to design the framework of the database but am getting stuck with a few specialised features.

On the front main switchboard page I would like a button which will create the ablity for "Ops Project Manager" to be able to select their own name to show all projects in their name. I would also like the ability to to then be able to filter by "Project Status", this will enable the project manager to view only statuses that are relevant.

I would also like the "Sponsor" to be able to perform the same time of search.

Any help would be appreciated,

Regards


Nuno

 

[ColinEssex]

A search would have found this example.

Col

 

[nuno1340]

A search would have found this example.

Col

yes i found that example but it actually isnt what I am looking for... But thanks for highlighting the search facility.

 

[gemma-the-husky]

depends how sophistacted your users are.

if you design a query for your ops manager returning his jobs, and open it, he can filter it /sort it/report/save it to excel etc from the query, without you doing anything else.

it depends how much you need to insulate your people from all this stuff

 

[nuno1340]

depends how sophistacted your users are.

if you design a query for your ops manager returning his jobs, and open it, he can filter it /sort it/report/save it to excel etc from the query, without you doing anything else.

it depends how much you need to insulate your people from all this stuff

Hi ya


I guess the most simple thing would be for the Ops manager to be able to select his own name which will then return his jobs... I know how to do this by running a macro with a 'where' condition assigned to each manager but that requires me to write a new macro everytime a new manager is created...

 

[gemma-the-husky]

then you need a login module of some sort to identify your user. You could ask the user to select a manager, but then any user could see other users details (which masy not be an issue)

you could read and use the windows login name if you dont want to use access security
this is in environ("username")

 

[nuno1340]

then you need a login module of some sort to identify your user. You could ask the user to select a manager, but then any user could see other users details (which masy not be an issue)

you could read and use the windows login name if you dont want to use access security
this is in environ("username")

no issue at all with other users seeing other users project... I would prefer it if the manager could select their name from a list.