By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,560 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

Login page that feeds a filter or query for a form

P: 4
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.
Oct 6 '06 #1
Share this Question
Share on Google+
2 Replies


100+
P: 143
You are looking at two seperate things. An audit trail to capture the dates modified, look here.

http://www.candace-tripp.com/pages/access_downloads.aspx

and Access security. Have a look at the Microsoft Knowledege base for the security question.

http://support.microsoft.com/kb/207793/en-us
Oct 6 '06 #2

P: 4
You are looking at two seperate things. An audit trail to capture the dates modified, look here.

http://www.candace-tripp.com/pages/access_downloads.aspx

and Access security. Have a look at the Microsoft Knowledege base for the security question.

http://support.microsoft.com/kb/207793/en-us

Thanks Tanis, will look ino it
Oct 6 '06 #3

Post your reply

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