Show Records only related for User log in Access 2013

How to create a from that Show Records only related for User log in Access 2013
Please provide any Link that may help, video are preferred.
Dr.Abdulwahab Al-anesiProjects Information Technology ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
By "User Log", do you mean the logged in user?

If so, then do you mean the Windows user, or are you actually logging in users with a custom method (i.e. a form, ect)?

Are your records related to specific users? By that, I mean do you have a "User" field in your tables, and that field contains the name of the user to whom the record is related? If not, then can you explain how you'll determine which records a user can see?
Dr.Abdulwahab Al-anesiProjects Information Technology ManagerAuthor Commented:
For making my Questio more clear , I have tried to do like attached Video in the following link, but it did not work
https://www.youtube.com/watch?v=ppGYIZwpHhU
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
It looks like that video is using the Windows Login, which you can get in several ways. The author there is using Environ, which will work in most cases.

That said: As I mentioned earlier,  you must have your records "tagged" to a specific user. Is your data setup in that manner? If not, there's no point in trying to do this, since it's not possible to filter for a specific user unless you have structured your data correctly.

Basically, you'd need to have a Column in each table named "UserName" (or something like that), which you would use to associated a specific record with a specific user (i.e. "tag" the data). If you've setup your tables something like that, then you can do this. If not, then you'd have to go back and modify your structure, and add values to the UserName field.

Did you "tag" the data with the actual Windows UserName? For example, if my Windows UserName is "Scott", then I assume that you tagged "my" data with the value "Scott" (perhaps in that "UserName" field I mentioned earlier).

If so, then you can simply filter each Form by UserName, and that should do what you want. You can do this in the Load event of each form:

Me.Filter = "UserName='" & Environ("UserName") & "'"
Me.FilterOn = True

When each form loads, it would only show values where the UserName field matches the Windows login name.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Dr.Abdulwahab Al-anesiProjects Information Technology ManagerAuthor Commented:
Dear Scott

Thanks for the help provided, BUT I feel I need more because I tried several times & not succeeded, I felt that I have to send you the data base its self, you may assist me more.

Best Regards
Database1.accdb
Dr.Abdulwahab Al-anesiProjects Information Technology ManagerAuthor Commented:
I still need more help as mentioned in my comments an the attached database
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I've downloaded the database, but I don't have any idea how you use it, or what you need help with. In fact, I can't really read it - I don't speak the langauge used in most of the database for your labels and such.

When you include a database here on EE, you should give exact instructions regarding how to "run" it, and what you need help with.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.