473,385 Members | 1,427 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

How to record user name upon record has been added or edited in a particular field?

Hai friends,

have a great day

i am using ms access 2003 in which i created a file with login username and password form(with some simple code not OS login username and password) and made the file such that it will open only if they enter correct username and password in that form every time the file is opened.

Now i want to record the name of the login person in a particular field of table or form whenever they add a new record or edit existing record.

please anyone help me in solving this problem which will be very much helpful for me.

for any details please send me an email to ** Edit - email removed as per site rules **

Thank you advance for helping.
Nov 17 '10 #1
1 1552
NeoPa
32,556 Expert Mod 16PB
First you need to store the data entered somewhere. This would most easily be done in a global variable in a standard module of your project.

When you have this available it is possible to add this information into a query by updating the SQL in your code.
Nov 17 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Tony | last post by:
Thanks for writing back and don't laugh at what I am about to post I am new to this type of stuff....this is what I have tried and it isn't working(please note in the try section I was just trying...
5
by: Michelle Stone | last post by:
Hi everybody I am writing a simple asp.net application using form authentication. I store the list of all users and their passwords in an SQL Server database table. My client recently told me...
3
by: Funky | last post by:
Hi, I have developed an ASP.NET application which has been running in production for around 3 months without any major glitches. Recently, a user was attempting to upload a rather large CSV file...
0
by: micky | last post by:
Error message and webconfig file are like this.. it says "The entry 'admin' has already been added." but i didn't add admin user . what's problem?? ++++++++++++++++++++++++++++++++++++++++++++==...
4
by: Joe | last post by:
This may actually be an IIS configuration issue but any help would be appreciated. I'd like to display some content based upon who the current user is that is accessing an internal ASP.NET...
2
by: Fred Wilson | last post by:
Hello, How does one go about finding all the tables that have a particular field name? For example a field name "EVENT_CODE" I would like to find all the places in the database this is...
9
by: =?Utf-8?B?UHJhdmlu?= | last post by:
We are using .net Framework 1.1 We are having one page on which we are using this Grid component. From this page we open a popup for adding new record as well as for editing an existing record...
6
by: tonialbrown | last post by:
I was hoping that someone may give me some help in regards to writing some code. I have the following code that works - basically a user selects a record from a list box & it copies the fields...
1
by: Mark B | last post by:
VB.NET: How do I get the value of a particular field in the currently edited gridview row?
11
by: prashantdixit | last post by:
Hi, I am developing a stock control software. Iam stuck somewhere. I have a form "Add new stock" consisting of combobox, text boxes etc. which is used to add records in a table. I have another...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.