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!
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.
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?
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.
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.
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.
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)"
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.
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.
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.
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...
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.
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.
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.
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.
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.
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.
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.
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?
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.