Solved

Login Form

Posted on 2008-10-08
5
639 Views
Last Modified: 2013-11-27
I have a login form that allows the user to enter the system.  Once you gain access, it opens a form (Search)  to login to access a record. I would like to tie the user that logged into the first form to the record that is searched.

Log in Form - Allows User to enter Database

Search Form - Allows User to search record using a specific ID

Any Suggestions are appreciated.

Thank You!
0
Comment
Question by:matheinjoe
  • 2
  • 2
5 Comments
 
LVL 77

Expert Comment

by:peter57r
Comment Utility
What do you mean by 'tie the user'?

Do you mean you want to stop the user from moving to a different record?
0
 

Author Comment

by:matheinjoe
Comment Utility
No, I want to show that the User touched that record.
0
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
Comment Utility
Sounds like you are going to need to run an append query in the form current event procedure.

The append query should add a record to a log table identifying the record, the user and the time.

Dim str
str = "Insert into logTable(Recid, UName, TouchTime) Values( & me.recid & ",'" & currentuser & "',#" & Now() & "#")"
Currentdb.execute str, dbfailonerror
0
 
LVL 3

Expert Comment

by:troyw1
Comment Utility
You can access the currently logged in user with

User.Identity.Name
0
 
LVL 3

Expert Comment

by:troyw1
Comment Utility
Ignore that, I see you are Access programming; my comment was for ASP.NET.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now