Obtaining User Information

Dec 10, 2007

Hello to you all...

I am just after a bit of assitance if anyone can kindly help?

Basically, I need to redevelop a Complaints database for my employer as the current one is no longer fit for purpose. The current database is a FE/BE database and users are required to login with a username and password. This causes me a massive headache as users constantly forget their password and email me to reset it. I had included a password reminder form which emailed users their password if they got their pre-defined security questions correct but our business standards dept did not want us to store personal data for the reminder questions. Is there a way that the database can obtain the users network login ID from windows without too much difficulty?? We had something similar in a previous database but it dipped into the system registry and our IT dept had a fit when the found out....not surprisingly. :-)
Thanks people. Have a great day!

View Replies


ADVERTISEMENT

Delete User Information In System.mdw File?

Jun 15, 2006

Is it possible to delete user information in workgroup information (System.mdw) file from command line or programmatically?

Thanks

View 1 Replies View Related

Log-in User Information Text Box Is Not Passing Into Table

Mar 21, 2006

Hello experts

good morning. here comes my doubt. i use =CurrentUser() in text box of form. but when am testing, the user name is not there in database.

i am using Access 2003 and Access security.

Can anyone tell how to resolve this

Thanks you:)

View 1 Replies View Related

Add Identifying Information For User Actions That Took Place

Oct 20, 2015

I don't know if this can be done. I'm using Access 2010 and I have users updating information on a hourly basis.

Can I have a field that basically shows the last user that edited the form or saved it?

View 6 Replies View Related

Forms :: How To Capture Windows Log On Information Of A User Using Database

Apr 8, 2014

I have several data entry forms in my DB. What I would like to do is capture the windows user name of the people adding records and changing records. How do I go about doing that? I was think of an on change event to a given field that would then pull the username and insert it in another field/object.

Lets say the an on change of me.cmbModel update txtUserName.

View 5 Replies View Related

General :: Timestamp Information When Certain Field Changed By User

Feb 19, 2013

I have a form that i want to some how in a text box post a time stamp anytime information in a certain field is changed by another user.

The time stamp shows on the table only when the table is saved or imported.

Is there a vba code i can attach to a text box that will show me anytime an entry is made?

View 4 Replies View Related

Tables :: User Form Design To Enter Necessary Information?

Dec 30, 2013

I have given an example in the attached excel spread sheet with a few comments at the head of each column.

1. I want to confirm that my best modelling approach for this kind of information is a series of 1 to many relationships linking the attributes in columns A->D?

2. In the example given an environmental rating is given to each make/model of car based on each combination of attributes A-->D. How would this work in terms of user form design to enter the necessary information? in order to assign an environmental rating?

View 4 Replies View Related

Write Conflict When User Updates Customers Information On Form.

Oct 24, 2007

Hi,

Well I know why this happens b/c the table that the information is being pulled is the subsequently being updated however when moving to a diff customer or closing the form etc.. The user is then displayed the MsgBox of Write Conflict and supplying the user with 3 options of Disregarding Changes, Saving changes to Clipboard or Save Changes.

Baisically is their a way to restrict this write conflict msgbox and have it so that it saves the users changes every time.

cheers

monkey o_0

View 2 Replies View Related

Queries :: Create Query Where User Will Enter Information In Boxes?

Jun 26, 2014

I am trying to create a query where a user will enter information in boxes (any combination) on a form and a query will bring up the joined information from 4 different tables but I do not know where to start with the relationships on the query let alone the best method to search.

To start it off I have attached a db with the tables and the form I want the user to enter the search criteria into as well as my attempt at a query.

View 3 Replies View Related

Obtaining DSN List

Dec 7, 2005

Hi All,

Long time no see y'all...

Question: is it possible to obtain a list with all the Access based System or User DSN entries on a system? First I don't know how to get such a list at all, and second I don't want to bother the users with non-Access entries - they're confused enough as it is.

Any help appreciated & regards,

Michiel

View 1 Replies View Related

Problem With SQL Obtaining MsysObjects

Sep 25, 2005

Hello,

I've got a workaround for the SQL of obtaining a count of tables matching a certain name-style. Ideally, I want to use the Like function (sql2) as it codes more simply, but found that the query doesn't work. As a workaround, I rewrote with a string comparison using the Left function sql1.

My question is: What is wrong with sql2?

When I paste the SQL into the Query Designer it works, yet when I debug in module code form, it fails.

Any ideas?

Regards.



Private Function getTableName(strName As String) As String

'---------------------------------------------------------------------
' Purpose
' This function is used to create a new table name. First it looks up
' all the table names in the database matching the passed in variable
' name, and then returns an incremented version of the name.
'---------------------------------------------------------------------
' Returns
' Table name as string.
'---------------------------------------------------------------------

Dim sql1 As String, sql2 As String, rst As New ADODB.Recordset, n As Byte

' Get number of characters for passed-in variable.
n = Len(strName)


sql1 = "SELECT Name FROM MsysObjects WHERE left(Name," & n & ")=left('" & strName & _
"'," & n & ") AND (Type=1)"

sql2 = "SELECT Name FROM MsysObjects WHERE (Name Like '" & strName & "*') AND (Type=1)"

rst.Open sql2, CurrentProject.Connection, adOpenKeyset

Debug.Print sql2
Debug.Print rst.RecordCount

If rst.RecordCount >=1 Then
getTableName = strName & rst.RecordCount + 1
Else
getTableName = strName
End If

rst.Close
Set rst = Nothing

End Function

View 9 Replies View Related

Obtaining Latest Price Data

Jul 23, 2007

Hi,

I have a table containing the following fields;

ProductID (UniqueID)
Date
Price

Each day some, but not all, of the products in this table have their prices updated.

When I write a query how can I ensure that the latest price is recalled ?

Any tips greatfully received.

View 2 Replies View Related

Queries :: Obtaining 3 Separate Totals In One Query?

Jul 22, 2014

I have three tables A, B and C.

I want to build a query that displays three separate totals: Total of A, Total of B and Total of C.

When I try to do this, the query has a weird behaviour summing the totals of the totals of the totals, and I don't know why .

I'm attaching a really basic sample of what's happening, where totals SHOULD be $4, $8 and $16 instead of $16, $32 and $64.

View 14 Replies View Related

General :: Obtaining Creation Date Of Excel File

Apr 10, 2014

I want to use the create date of a file which is stored as a linked table in my Access 2010 database. I have attempted this by creating a query (qrysysObjects) using the MsysObjects and that gives me the filename of the linked tables, well almost - a few are csv files and this does not have the file name in the database field text, but I have found it in the foreignname field except it is name#csv rather than name.csv so I can't simply concatenate this in a query.

I know there is a function called FileDateTime which you can use in vba or a query but can you use a variable with this rather than the actual path name? I tried this in the query qrySysObjects but it said unknown function.

View 2 Replies View Related

Obtaining Multiple Report Parameters Via Menu Form Lookup Control

Feb 11, 2015

In our Student Administration database, we have a Student Evaluation Report which prints a 1 page per student report in memo like format. The instructor had previously input rating numbers (4=Best, 1=Worst) for 9 categories for each student via a database form into the Evaluations Table.

Two other elements of the rating are an Attendance based on number of days absent and a Grade Point Average (GPA) calculated from the student's test scores. The instructor then prints and reviews the report with each student.

There is an Evaluations Parameter table which has the following fields:

Field
Description

ID
The autonum key field.

Class
eg., 2015-1

Evaluation Number
A single digit (eg., 1, 2). There may be more than 1 evaluation for each class.

EffectiveDate
The "as of" date of the evaluation.

There are then several other tables that are input to a query that will be the record source for the report:

Table
Purpose/Data

Students
Student Name, Class

Absence
Has a record for each student's absence with date and a 1 or .5 indicating a whole or half day absent.

Test Grades
Has a record with each student's test results with date and score.

Evaluations
Holds the rating score for each of the 9 rating categories.

The Student Evaluation report is launched from an unbound Reports menu form via a button. On the Reports menu form I wish to have controls for the user to select which evaluation to report on. The Absence and Test Grade information needs to include records that are <= the EffectiveDate in the Evaluation Parameter table. The Evaluations records need to match the Class and Evaluation Number in the Evaluations Parameter table.

I would like the user to be able to select the Evaluation Parameter via a combo box vs. specifying the Class, Evaluation Number and Effective Date separately and then have the query record source for the report use those two fields as criteria. But my limited understanding of the Combo box indicates that only 1 field from the lookup query of the Evaluations Parameter table can be stored in the control whereas I need 3 (Class Evaluation Number and EffectiveDate).

How the user can select the desired Evaluation Parameter record on the Reports menu form and use the 3 fields from the selected record as criteria in the report's record source query.

View 10 Replies View Related

Forms :: Restrict User Input In Textbox Depending On What Option User Has Selected

May 22, 2013

I am building a form in access and I am trying to find a way where user input isn't possible in the associated textbox when "No" from on option box is selected.

View 3 Replies View Related

Multi-User - Can You Assign Which User Created/amended A Record?

Aug 4, 2007

Hi guys,

I've seen different log in forms and tips on multi-user use but can't seem to find info on the following...

We have 6 people at work and I'd like to assign which user updated a form or created a new record...this would be particularly useful on the sales part of the database to track who made a call to a particular customer...

Best ideas anyone?

dazza61

View 6 Replies View Related

General :: Access Multi User Database - Error On Only One User

Apr 24, 2013

I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .

All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.

View 1 Replies View Related

Calc User Totals Table 1 And Enter In User Records In Table 2

Oct 28, 2004

I have two tables. The first contains details of a budget holders money allocation for a given period, and the other tracks their spend on products over that period. How can I generate a query to calculate the total running spend for each user from the "budget spend table" that will be written into the users record in the "budget allocation table".

My aim is to show details of budget allocation, total spend to date and remaining budget for each user in an Order form / report.

Can anyone please advise me on how to do this or suggest another way of doing it. Any help would be greatly appreciated.

Thanks in advance.

Regards Peter

View 5 Replies View Related

Too Much Information

Jan 4, 2006

I wonder if anyone has a quick fix for me. I have two tables in a project management DB that I am making. The first table is a projects table and the second is a tasks table. I would like to have a list box in the projects table containing all the tasks completed for the specific project. However, the current list box is showing all tasks rather than the ones specific to the project ID. The project ID is the primary key in the projects table and the foreign key in the tasks table. I am not sure if/how setting up a filter would correct this or if I just need to adjust the relationships. An example of the DB is avaiable if helpful.
Any advice or ideas would be greatly appreciated.

View 1 Replies View Related

Getting All DB Information

Jul 12, 2006

I have a client who wants his Accs db converted to MySQL. I have no problem understanding MySQL. However, my knowledge is limited with Accs.

This db is quite large (53mb) and has several tables, queries, reports, forms, modules, etc. I suppose he tried to create a backup and sent it to me. The problem is that all I have are the tables...nothing else.

Did he do something wrong or is that standard w/ Accs? Is there anyway I could have all of the information saved to some type of txt or .doc file and send that to me? I understand that would make it larger. The problem is right now Im on his computer (networking) and it's running too slow. I'm having to make screenshots and what-not (and that's when his secretary ISN'T WORKING...so pretty much at night). Really need some suggestions with this.

Thanx,

Tim

View 2 Replies View Related

Getting Information Out Of A ListBox

Jun 14, 2005

I am brand new to Access(I started yesterday). I have a ListBox that gets its selections from a Query. I set it for MultiSelect, and now I have to figure out how to store the selections. The list is organized in accending order, which does not match the table that the Query is based on. I have no experience with VBA. The form name is Trouble_Ticket and the ListBox name is List24.

Thank you

View 1 Replies View Related

Shortening A Row Of Information.

Jul 4, 2006

I have got a set of information that has a mixed bag of names. Some have only a first name but some have a middle name also.

I am looking to shortern the information just to the firstname (i.e. in stead of the results showing "Bill William" as the firstname, i want to just show "Bill").

i tried using the Left function but because the strings are of varied length i need the cut off to be the space between the various names.

Any help would be much appreciated.

View 4 Replies View Related

Information Boxes

Dec 27, 2006

I seem to remember - way back in my access class that I have not used regularly, therefore have forgotten much - that there is a way to put a description of the query or form or table that pops up in a kind of box when the cursor is placed over the name. I hope that makes sense - if not, read on.

I have a lot of queries and would want anyone using them to know what they will do before they click on one - because it might mess things up.

Thanks in advance,
Peg

View 7 Replies View Related

Linking Information

Feb 8, 2007

I am having a hard time linking some certain information. I think I have my relationships formatted correctly but not all the information is connecting.

For example: I have a form where I am creating a sales quote. In the form I have a combo box where I select my product ID. When I select the product ID, the product name automatically populates but the price does not.

I have attached a screenshot of my relationships. Can someone please look it over and see if anything stands out to you as being incorrectly formatted? Or offer any advise in getting my price to connect to the product ID I enter?

View 14 Replies View Related

Loosing Information

Mar 14, 2007

Hi there..

We have Access 2000 database. Everythign is working fine but suddenly it have started loosing information. I entered one record last week and its not showing up now.
I am not a remote user. I entered the data from local machine.
Do someone have any idea about this issue.

Thanks
Danny

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved