Hi there,
I’m relatively new to access so please forgive any ignorance. Here is my, rather long-winded, plea for help:
I have a main table which contains a list of ‘projects’ and associated information (team name, staff member dealing with a particular project, project description, budget etc). Team names and staff names are stored in separate tables and linked to the main table by their ID.
I have fed the various required fields into a query and then created a main form to be fed by this query.
I also have a table containing a ‘date modified’ and ‘modified by’ column which is used to record who modified a particular record and when. This table is tied to a sub-form embedded within the main form.
In the sub-form the ‘date modified’ field is automatically filled in with today’s date when a record is modified however the name in the ‘modified by’ field has to be selected manually from a drop down list.
What I wish to accomplish is that when the database starts up, a form is opened which requests a user to select their individual name or team from a drop down list (fed by my existing tables). When this is selected it would ideally trigger a query or filter of some sort so that when the main form was opened only the records relevant to that individual or team would be displayed for editing. Furthermore, the ‘modified by’ field would automatically be chosen by the name selected at login stage.
I have a feeling this requires some kind of code or macro attaching to an ‘event’, unfortunately my knowledge of adding and modifying code is fairly basic at the moment so any help would be greatly appreciated.
Kind Regards
Doc. FG.
2  1699 
You are looking at two seperate things. An audit trail to capture the dates modified, look here.
http://www.candace-tripp.com/pages/access_download s.aspx
and Access security. Have a look at the Microsoft Knowledege base for the security question.
http://support.microso ft.com/kb/207793/en-us
You are looking at two seperate things. An audit trail to capture the dates modified, look here.
http://www.candace-tripp.com/pages/access_download s.aspx
and Access security. Have a look at the Microsoft Knowledege base for the security question.
http://support.microso ft.com/kb/207793/en-us
Thanks Tanis, will look ino it
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: dylanhughes |
last post by:
I'm looking for an example of a login system that has multiple fields
(2 to be exact) + password. e.g username, company name and password,
the user, company and password are checked against a mysql database. I
have it working with just the username field but I'm confused on how
to go about adding another field. I'm pretty new to PHP so don't beat
me up too much for this example code, I borrowed and hacked it
together in a very short period...
|
by: nth |
last post by:
I wan to filter the database show out information by using the user login name. Means that when that user login by entering their names n password, if correct then it will go to the other page by showing that user result only, not other user result. Can somebody help me pls?.
Following is the login page code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/conResult.asp" -->
<%
Dim Recordset1__MMColParam...
|
by: bh |
last post by:
I am using a built-in login control on a form, and have set the
"DisplayRememberMe" property to false.
It correctly does not display that checkbox on the login form; however,
after authenticating, I'm prompted with an Autocomplete Passwords Dialog
box, asking if I want to remember the password. Is there any way to disable
this dialog, and force it to not remember any passwords?
Thanks in advance.
|
by: adweaver |
last post by:
Hello All,
I'm new to the world of php. I've just had a site designed for me by a company, and I'm now trying to manage and grow it, so it will suit my needs.
The site was built in a folder called mysite.com/test. I coppied this folder a number of times, so I now have mysite.com/test2, mysite.com/test3 etc. Each folder acts as its own landing page.
they setup an interface where we can control the upsells presented to the customer;...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
