Identifying The User
Feb 14, 2007I have made some accounts with the user-level security wizard, and i was wondering is there a way to know who logs in?
Im wanting to give a person preset information on forms and stuff.
ADVERTISEMENT
Identifying User's Workgroup
Mar 13, 2007Is there any function or code that would display the workgroup in which the current user belongs simular to the function "currentuser()" which displays the user logged onto the db?
View 9 Replies View RelatedAdd Identifying Information For User Actions That Took Place
Oct 20, 2015I 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?
Forms :: Identifying Whether User Is Checking Or Unchecking A Checkbox
Mar 12, 2014I have a checkbox on my form that basically deletes a record when the user ticks the checkbox. What I want to know is how do i check whether the person is "ticking" or "unticking" a checkbox before any action is carried out?
View 3 Replies View RelatedIdentifying Form - Check Username And Password Of A User
Jan 15, 2015How to make a form that must Check the username and password of a user, in case if they are true then let the user to visit other forms and Tables...
View 1 Replies View RelatedIdentifying Updated Records
Oct 23, 2006Hi
I have my table set up to add today's date as a "date last updated" field. this works for all new records but I need to flag instances where a user has amended any existing records, so that on a daily basis I can filter out anything new based on the "date last updated".
Any ideas how I can flag changes to existing records?
Apologies if this is a straight forward question I'm fairly new to Access
Identifying Duplicate Records
Jun 26, 2005Be advised that I'm a complete novice with Access, and have used it only to view Excel files with more than 64,000 records. Any help would be appreciated.
I have an Excel file of 10,000 records entered by salesmen of possible prospects, with salesmen, prospect name, address fields. Some salespeople have entered the same prospect and address information; the only thing different in these records are the salesman name.
I know how to import the file into Access. But from this point, how do I construct a query and generate a report that shows me ONLY THE DUPLICATE RECORDS? We would like to use this report to identify the double entries and the salespeople so they can clean up the database. I know Access (I have Access 2003) can create this query, I don't have a clue on how to do it.
One hint: A post on another forum suggested " Make a group-by query (grouped on all fields except salesperson). Add a count field. Select if count >1. This should do the trick."
I'm sure this is the answer, but I don't know how to "make a group-by query", how to "add a field", etc. Like I said, I know how to import the data. That's it.
This is extremely frustrating to be this close to the answer and not know how to finish it. Any assistance would be appreciated. Thank you.
Identifying The Active Form
Jan 17, 2006Apologises if the answer is out there somewhere but I have searched to no avail.
I have a number of Forms which the user can jump around from one to the next. All the forms remain open with the form they are currently viewing showing on top. If they make a change on one particular form then when they return to a previously viewed form I want to disable or hide certain certain controls etc.
I know this would be simple to do on the on open command but as previously mentioned as I am not closing the forms after they are viewed, if the user returns to a previously opened form then this is not picked up.
Soooo, basically I'm after something like
When the user moves from one form to another already opened form for the new form to immediately know that it now has the focus and for it to do something along the lines of on open.
Any help will be appreciated
Identifying Table Links/relationships
Mar 22, 2007I am new to Access and just inherited a very large database to work with. Is there an easy way to figure out the relationship between each table and how they are linked? Thanks.
View 5 Replies View RelatedQueries :: Identifying Whole Numbers Vs Integers
May 2, 2013I currently have a calculated field that will result in either a whole number or a decimal. From there, I need to set up a field that identifies if the previous field is either a whole number or a decimal.I have tried several different formulas, but always seem to get an error or a query that does not return any results.
View 3 Replies View RelatedForms :: Identifying Which Control Is Being Pointed At?
Jan 5, 2015I'm familiar with screen.activecontrol but what I am trying to do is to activate an event relevant to the control currently triggering the mousemove event.
In the attached db, if you open the MMHighlight form and move the mouse over the boxes, as they are moved over they go yellow (mousemove event), whilst still hovering, click on a box and the first box displays the first and last boxes selected (mousedown event). release the click to trigger the mouse up event which clears the boxes. Broadly this is working as intended
The problem is the mousemove event which has to be 'personalised' for each control - highlighted in yellow
In the real application there are several hundred controls, so I'm looking for a timesaver - one option being to build a form via vba, but ideally some equivalent to screen.activecontrol and perhaps a third where I can replace [text0] with a generic name - a bit like 'Me' to refer to the form.
General :: Identifying In And Out Work Times Records
Feb 1, 2015I have a table (Imported from Excel) with In and Out records.
Here are the problems I have:Each record has either In or Out data. I have an identifier to know which ones are In and which ones are Out
It might have some misses, either no In or no Out record for the specific work time. A worker can get in at the evening and get out at the morning of the next day. Might have more then one entrance/exit on the same date.
I want to have the record sorted so I'll have an In and Out on the same row (record) including holes for the missing ones.
Queries :: Identifying Feeder Query That Has Zero Results
Oct 2, 2014I have a query (A) as the data source for a report. That query (A) has a another query (B) as one of it source files.
How can I tell if query (B) has no output, so I can stop query (A) and the report attempting to run.
Queries :: Identifying Decimals In Calculated IIF Statement
May 22, 2014I have a statement as follows:
Code:
ohc: IIf(([oh]/[csqty])>1,[oh]/[case_qty] & " (LTSU?)",[oh]/[case_qty])
The intention was that it would add " (LTSU?)" to the calculated number where it was less than 1 (or not a whole number). Stupidm, me didnt account for fractions greater than 1 (ie 1.566). Just wanted to know how I can identify all 'non-whole' numbers in the above IIF statement.
Identifying Words Spelt Incorrectly With Numbers Instead Of Letters
Nov 15, 2007Hello
I have some data I need to clean.
It is in an address field the majority of the data is fine but there are some records with words that have been spelt with numbers:
2 9RAMBLEGATE
2 Forest V1EW
2 KEM8LE Close
2 BELLEMOT4TE Road
Is it possible using a query to find instances where this has happened so I can flag these?
Any help would be greatly appreciated
Tim
:confused:
General :: Identifying List Of Each Object With Their Relative Size?
May 19, 2015I have a large database. I want to identify which objects take up the most space. Any way of identifying a list of each object with their relative size?
I can do this in sql server, but no in Access?
Queries :: Identifying And Combining Rows Based On Matched Fields?
Jul 10, 2013I have two tables. One table is a list of classes with the number of enrolled students:
Class............StEnrolled
English 1A........6
English 1B........12
English 1C........20
English 1D........25
Reading 1.........4
Reading 2.........15
And the other table is a list of "combined" classes (meaning they are, essentially, the same class and should be counted as such):
Class...........CombinedWith
English 1A.......English 1B
Reading 1........Reading 2
Using the first table, I currently generate a query (and build a report) that displays class enrollment levels. What I need is for this query to identify combined sections from the second table and display them as such:
Class........................StEnrolled
English 1A/English 1B........18
English 1C.......................20
English 1D.......................25
Reading 1/Reading 2..........19
Modules & VBA :: Identifying Highlighted Or Bold Cells To Import Into Access
Jun 12, 2014I receive a bunch of excel files with items to be added to a database. some of the items are to be added as new, some to be deleted and others to be modified.
I identify the action (add/delete/modify) by looking at a column in the excel file e.g. column A.
At this point I am fine with the add/delete because I can filter the data or bring all the files to a temporary table in an Access database via vba script and then running queries to do the rest.
My issue is that the spreadsheets have a lot of columns and for the modifications what they do is use the same file for instance, make changes on the cells (any cell) that need modification and then highlight, bold or underline only the items that need modification and ignore the rest of the file (a tedious process since I have to then open each file and manually modify the database).
Forms :: Restrict User Input In Textbox Depending On What Option User Has Selected
May 22, 2013I 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 RelatedMulti-User - Can You Assign Which User Created/amended A Record?
Aug 4, 2007Hi 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
General :: Access Multi User Database - Error On Only One User
Apr 24, 2013I 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.
Calc User Totals Table 1 And Enter In User Records In Table 2
Oct 28, 2004I 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
Forms :: Second User Record Changes When First User Selects Record
Jul 31, 2014I have a database for mutli users which is split. Front end is available separately for 3 users. These users make data entry in the same form from their front end form. This particular form has combo box that retrieves data based on selection in combo box and the use starts filling the data in the subform. Upto this, form is Ok, no problems seen.
But when the second user opens the same form from the split database front end stored in his computer, and once the second user selects another record from the combo box, first user's record also changes immediately to the record of Second user. Both users now have the same record even though the form is separately accessed from front end.
First User Allow To Read And Write / 2nd User Only Allow To Read?
Sep 2, 2014Will like to check, i have a access database which can be open up by a few users.
How can i only allow the first user who open up the database to read and write the database and the follow users who open up the access have only read access?
A User End?
Jul 26, 2005I need some help building what I believe is called a user end. I'm done building the tables and forms and all that jazz, now I need an interface that my boss, who knows nothing about access, can easly access and manipulate data. Of course it would be nice if I'd look nice. Is there anybody who can help or can give me link to a decent tutorial.
I already searched these forums and googled for help.
User Id
Nov 29, 2005i plan to use the Group security feature for my DB.... using the user ID and password... i also want to make use of the user ID in the autopopulating of some of the field in my forms.... if for an instance the person logged in is akshal... then the a particular field named "filled in by" is to be autopopulated by the user ID (i.e. akshal)
View 2 Replies View Related