?
Solved

Login Form

Posted on 2008-10-08
5
Medium Priority
?
646 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 22676238
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
ID: 22677801
No, I want to show that the User touched that record.
0
 
LVL 77

Accepted Solution

by:
peter57r earned 2000 total points
ID: 22679115
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
ID: 22679542
You can access the currently logged in user with

User.Identity.Name
0
 
LVL 3

Expert Comment

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

Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

741 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