Displaying all open work orders issued to logged individual

[Hammilton]

Good afternoon,

I don't know much about queries and reports, but I have a database for all of our plant work order. The database existed before I started my work on it, so there are a few things I'm fighting with. Before the database just consisted of a table into which all of the data was directly entered, and then a report where the manager would then do a text filter for the work order number he wanted, and used that to print his reports.

I'm changing the database to make it way more user friendly. There are two user classes currently, admin and non-admin. Admins will have the ability to create new work orders and review closed but not yet reviewed work orders, and non-admins need to have the ability to pop up all of the open work orders that are assigned to that user. In the existing work order table, there's an "assigned to" column, and I want my query to display all of the open work orders assigned to the user who is logged in, but I can't begin to understand what I need to do.

Any help would be greatly appreciated. Once I can figure this out, I can probably figure out a lot of the other stuff I need to do yet, but until I can figure out how to do this stuff I can't figure out how to do the next things, but thanks to the help I received in the other subforum, I was able to do a ton of programming and make all the forms work.


I've attached an empty version of my database here. It's not the most current version, but I don't think anything has changed in the tables or report in any of the updates I've made since then.

Thanks!


Empty WO Log.zip

[June7]

You need to identify who is logged in and save that info somewhere for future reference as filter parameter.

User login is a fairly common topic. Start with: https://www.accessforums.net/access/...gin-23585.html

[Hammilton]

I do, when the user logs in, their name is displayed on the main form that opens after authentication.

[June7]

And the main form never closes? Then you're pretty much there. Reference the control whenever needed. Can be referenced in query (I don't use dynamic parameters in queries) or in VBA code to build filter criteria. http://www.allenbrowne.com/ser-62.html

What do you mean by 'their name' - like Jane Carter? or the Network USERNAME? A user ID would be better as filter/search parameter than name.