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 Replies
ADVERTISEMENT
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.
Add 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 RelatedMulti-user Accessability Issues, Workgroup Needed?
Jul 17, 2006Hate to throw this issue back in the mix, but I seem to be really struggling to find a solution, even after extensive searching through posts. I can't seem to pin down any existing posts that directly addresses my problem, so here it is:
I have a DB that needs to be accessed by no fewer than 9 users for data entry and retrieval, no designing or programming. I seem to be running into a multiple user problem revolving around exclusive opening of some sort.
As it stands, about 4 users can open the DB simultaneously without issues. But as soon as a 5th person tries to open, they get an error saying they do not have exclusive rights, and the other 4 members run into problems closing their opened forms or tables with a "cannot save due to another user already has it open" and an error loop. Then, no one can close because of the auto save function in access.
I believe this may have something to do with workgroups, and have searched the forum with this keyword, but I'm not sure if this is where I need to go. I also don't know how to set it up from start to finish. Do I need to do something on each user's individual computer to make it work? And once I have one set up, will this absolve my current multi-user issues by specifying a shared access at all times?
Please help, as I'm getting a bit tangled up in the steps of this process. Is there a different solution? Thanks for any advice you can offer.
Identifying 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).
Workgroup
Oct 31, 2006Hi there,
I'm trying to put in place a workgroup and I'm struggling with it at the moment. I created a seperate workgroup and have a command line short cut to it. When I try to add a user to the admin group permissions it works fine except that I can't open any of the forms in design mode. It says I do not have exclusive rights . I dont know what to do. I though that the admin password would be set to blank but It won't open the database either.
Any ideas, im pulling me hair out.
Workgroup Security
Jun 2, 2005Might be a stupid question but here goes.
I have successfully created my own private workgroup and have set up security levels for 4 users on one access programme that l have written.
I have a second access programme that l use with the same users, however l want to set different user parameters, can l set a second workgroup up as l did the first.
Is two workgroups possible on the same machine ?
Regards
Andy B
How To Get The Username From Workgroup?
May 18, 2006I have the security set via the Access workgroups for both groups and users. I want to be able to use the username entered on the logon screen to filter my query results.
How can I get the logon id that was entered when my switchboard form opens?
Thanks in advance.
Dennis Cronin
Workgroup Problem
Jun 5, 2006I currently have several Access 2003 databases on my computer. I have been working on a new one that must be secured.I have created a new .mdw file to handle this. The path to this file is included in the shortcut. Everthing works great.
HOWEVER:
Whenever I close this database and then open another, it is still promting me for a password (the other DBs aren't supposed to be secure). I have changed the shortcuts to go through the old system.mdw but it still does it. When I change the workgroup manually, the secure database no longer prompts me for a password. It would appear there is more to selecting the workgroup than just editing the shortcut.
Help -- Workgroup Security???
Jul 26, 2007I'm trying to set-up and secure a networked multi-user database. I used the Workgroup Administrator to create a new workgroup and save it to the network drive. However, when I open my database, it seems it may still be pointing to the the default SYSTEM.MDW workgroup on my hard drive. Do I need to do something to my database to tell it to point to the new workgroup I have set-up? When I start having other people log in from different locations, will they need to join the workgroup or also point the database to the networked workgroup when they open the database? The manuals aren't very clear on this, please help.
View 1 Replies View RelatedWorkgroup Security Sample DB
Jun 6, 2005Can someone post a copy of a sample mdw file so that I may observe the design of the database? I am very new to the concept of db security and would like to take a look at how the design is constructed. Thanks!
View 11 Replies View RelatedWorkgroup File Lost
Sep 21, 2005We have an old Access 97 database with a workgroup file. The problem was that the machine was upgraded and the software was changed to XP. They support guys moved all files to the new PC except the the workgroup file. We can't fine a backup of the w/g file.
I am unable to upgrade the database to access 2002 because of the permissions.
What is the easiest way to get past this stumble block.
Thx