General :: Setting Limit For User To View Specific Data

Aug 6, 2012

I am trying to limit what a user can see when accessing a database in access. I am only testing with this in access before taking it to SQL server. I have 3 databases and I combined the data into one set of tables and now what i am trying to do is a certain user can only view data from a particular database.

I have a table with the users id and password, as well as an ID number from each database that I am trying to tie to the users.

for example one user can view and add/edit data in databases 1 and 3 but not 2. while there might be a user that can view and add/edit on 1 and 2 but not 3.

View Replies


ADVERTISEMENT

General :: Restricting User To View Specific Record After Logging Into Login Form

Mar 17, 2015

i am currently developing a database what i need to do is to restrict user to view selected record and change them. i have build a login form in which i have two areas as a user name in combobox and a password text box. i have another form in which i have a combo box named area what i need to do is to limit the area combo based on the selection of the user login form previously. for example if a user select LAS VEGAS in user combo and enters its password after clicking the button login the another form appears in which thier respective stores and sales are saved, their is a combo box named area in which i want to limit it by LAS VEGAS i mean it would only show LAS VEGAS in drop down based on the previous selection in login form.

View 4 Replies View Related

Limit User From Accessing A Specific Form

Jan 11, 2008

I am having a problem restricting a user from a certain form.
I have a module that detects if a user or admin based on the roles entered in the employees table.

If their windows login is not listed in the employees table, they will not be able to view any of the forms.

Here's my problem, I want the users to access the switchboard, but they should not be able to get into the reporting button.

here's my code:
If LOAStatusbtn.Caption = "View Report" _
And Not admin _
Then
'useraccess denied because not an admin
error_text = "You do not have privileges to access this screen." & vbCr & "Please contact an administrator"
MsgBox error_text, , "No Privileges"

End If

If they click on LOAStatusbtn and their role is not admin, then a message should pop up.

I searched the forum and could not find anything similar to this.

Thank you,

View 4 Replies View Related

General :: Setting Up A Specific Database?

Aug 12, 2015

I have appx 500 customers that have contracts..... The contracts have 15 products that are available. Not all of the customers purchased all of items on the contract. I want to have a database that lists (on one page) the client information, contract information and the product details for that customer. I have no clue how to go about doing this. The Contact database template is what I am starting with. I want to click on a customer and pull up the information all on one page.

View 1 Replies View Related

Queries :: General Date Field Criteria - Limit Results To Only Specific Month

Apr 16, 2015

I basically have General Date field (e.g. 10/1/2014 6:34:11 PM) and I want to limit the results to only a specific month and only to show reuslts after 6PM. I tried everything and still stuck.

View 2 Replies View Related

General :: Disable SharePoint Access Setting Option For Certain User

Oct 3, 2014

I just published an access database to sharepoint. However, after I set some user as contributor, those users can see structure of my database, and export tables to excel directly. Is there anyway that we can remove the access to "Setting"?

View 2 Replies View Related

General :: Setting Printer Paper Size To User Defined

Feb 18, 2014

I want to set my paper size to user defined, but it not working,

<<<<<<<<<<<<<<<<<<<<<<<<<<
Set Application.Printer = Application.Printers("P1121E")
Application.Printer.PaperSize = acPRPSUser
Application.Printer.ItemSizeHeight = 9.35 Application.Printer.ItemSizeWidth = 26.9
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Showing "Run time error "2595"

"Cannot set this property when defaultsize property is set to true"

I try add "Application.Printer.Defaultsize = true or false" also not working

View 1 Replies View Related

General :: Stop User To Go Into Design View

Mar 7, 2015

Is it possible to stop anyone from going into design view ( even right clicking the mouse ) .

View 3 Replies View Related

Forms :: Saving Specific Data From Data Entry Form Depending On User Selection

Dec 18, 2014

I am trying to save specific data from a data entry form to a specific depending on what the user selects from a dropdown/combo box.

So if the user selects "test company from the combo box, that data (from that form) will save to the Test company data table.

View 5 Replies View Related

General :: Complex Spreadsheet With Unique User View?

Dec 19, 2014

The spreadsheet I've attached contains a ton of calculated cells and linked data. The people who created and utilize it aren't necessarily interested in changing the way they use it or populate it each quarter. That being said, my task is to somehow create a way that it can be sent to/seen by each person differently. First I'll point out that the 3 columns that are blank normally contain names, I deleted them for obvious reasons. The first of those columns, B, contains unique names for each agent in the firm, these people need to ONLY see their own data. The second column of names are basically managers, they need to see the records for each agent that falls under them. The 3rd column of names is irrelevant for these purposes.

Now if all this data were in access, and everyone had access to it I could easily just make records visible or invisible based on user name and I wouldn't be here right now. But they can't and that's not an option. I honestly don't know if this should be done solely in Excel, in Access or a bit of both. Currently this spreadsheet gets emailed to each manager and they have to review the data with each agent.

The first tab, worksheet, is basically instructions. It would be nice if those were images on the page and then all of the data were below that so that the agents could see them together and understand it better. As I'm sure you'll see it's a pretty complicated system so they have a hard time understanding it.

Note: There are actually about 3,000 records, I've deleted most of them for size purposes.

View 4 Replies View Related

General :: How To Allow User Add Fields To Form (without Going Into Design View)

Dec 4, 2012

I got a form called "Make quote". In this form a user can select a product from a line of fields. This "line" contains: article code, product, price and quantity the customer requests.

Each single quote can contain a very different amount of products. Some quotes just have 1 product, other quotes have 25 products.

I'm looking for a way to let the user add as many "lines" as necessary for the quote. BUT I don't want him to need to go into design view.

I'm thinking of maybe adding a button to the form which does this, but I'm not sure how.

View 10 Replies View Related

Modules & VBA :: Get Msgbox To Let User Enter Data In Specific Text Boxes

Jun 17, 2014

i want to get a msgbox to let the user enter the data in specific text boxes so they can't let it empty if not empty then do..this is my code

If Me.Client_Name.Value = "" Then
MSG = MsgBox("You Should Enter The Client Name")
ElseIf Me.Username.Value = "" Then
MSG = MsgBox("You Should Enter The UserName")
ElseIf Me.Address.Value = "" Then
MSG = MsgBox("You Should Enter The Address")

[code]....

the msgboxes that tell the user this textbox is empty is not appearing what's wrong with my code

View 3 Replies View Related

Queries :: Running Total With Limit - Reset After Specific Value

Apr 2, 2015

Is it possible to have a running total either in a query or using the Running Sum function on a text box on a report that will reset after a specific value. Here is what I would like to have happen:

The RunningTotalCube field to reset when it has reach 2.3 or whatever number comes closest to that number.

Date Time Item Cube RunningTotalCube
4-2-15 12:05 15615 0.5 0.5
4-2-15 12:06 15918 0.8 1.3
4-2-15 12:10 98563 0.5 1.8
4-2-15 12:12 45268 0.4 2.2
4-2-15 12:15 25854 0.9 0.9 {reset}
4-2-15 12:17 75136 0.5 1.4

Is this possible either in the query or the report/in Access or in VBA?

View 3 Replies View Related

Forms :: Limit Dropdown List To Specific Record

Mar 24, 2015

I have a list of customers. [ID] on (Form1)

I click_on their name [ID] that opens a dialogue (Form2 )specific to them.

I have a table of several dates with the relevant [ID]

I want a dropdown box on Form2 that only shows the dates for that specific customer[ID]

Ive tried [Form2].[ID] in the criteria of the ID field in the query for the dropdown data source.

View 3 Replies View Related

Can Limit A Specific Value From Lookup Field To Only ONE Record At A Time?

Aug 2, 2012

Any way I can set a table up with an intrinsic limit, specifically that only ONE record at a time (this will vary) can possibly have value X selected from a lookup field containing assigned values X, Y and Z. Is this possible? If so, how do I do this?

View 2 Replies View Related

Forms :: Limit Records Shown On Open In Datasheet View

May 16, 2015

I have a question on number of records displaying in datasheet view on a form. Is there a way to limit the number of records showing on open.I have a command button on a Navigation form that opens a frmEnterPartsOrder using a Macro.

I have set the Macro to OpenForm, View Datasheet then GoToRecord, Record New..Works perfectly, but it does open the form and fill the screen with records, putting focus on the "new" record at the bottom of the form. Is there a way to set it to open this form, but only display say last 10 records and then focus on "new" record.

View 2 Replies View Related

Maximum User Limit?

Jan 10, 2006

Hi
What is the maximum number of users who can be connected to one single database at one time? Is there a web site that has info on this?
Thanx for the info

View 1 Replies View Related

General :: How To Add Combo Box Field To Data Sheet View In Form

Dec 29, 2014

I created a new field as a text box, converted it to Combo box, then the Values are pulled from a query and all that works fine.

I have a form that opens and displays these Fields in a Data Sheet view and the new Combo box doesn't drop down and is flagged as a text box in the property bar but no way to change it??

I need the drop down like the other Category field I have, that works but this one doesn't.

See screen shot.

You can see in the Category field, there is a Drop down, but in Category II there is not, even though this is a drop down field. - BUT in this data sheet view it doesn't show it as a drop down.

[URL] ......

View 5 Replies View Related

Setting Design View Password

Apr 12, 2006

Hello to all,

Can you tell me please is there any way to set password to form design view button in a .mdb database? I have seen it somewhere that a guy set password if you want to view his modules in a design view. Is it possible to do the same with forms, reports etc. Any help is very welcome.

Best Regards

Thanx

View 1 Replies View Related

General :: Search Filter Option For Users - Ability To View Data?

Mar 12, 2014

My department and limited the users to only specific tables based on their need and role. However, users have expressed the need to view past work. I do not want to give them access to the table - I am thinking that there should be a way to create a report that shows the data, but how would I set up a search filter option so they can find the one record that they are looking for?

View 2 Replies View Related

Forms :: Setting New Record View As Default?

Oct 28, 2014

How to set a new record view as default in form view???

View 1 Replies View Related

Limit User's Security Permission With Code

Sep 15, 2005

My db is secured using Access security but now find myself needing to code a little security work around if possible.

I have a form that has a subform. On the subform is a field named "Comments". The subform security only lets a particular group write to the fields it contains (including "Comments"). I have a new user that I need to allow to write to "Comments" but not to any of the other fields on the subform. I could make another subform with "Comments" only field and redo my security so that the original group can write to both subforms and new user can only write to "Comments" subform but I think it might be easier to code in that the new user is only allowed to write to field "Comments" in the existing subform. Every user logs into the db so I can get the user ID.

Is it possible to do this?

View 2 Replies View Related

General :: Missing Data For One User But Not The Rest

Jul 10, 2012

I work in an office where we use the same database in a folder on a shared server. When Mary Jane is signed on to her computer she can't see all of the data for a record but I am able to see all of the data for the same record on my computer. So I had Mary Jane log out of windows on her computer and I logged onto window on her computer. Once I was logged onto windows on Mary Jane's computer, I then opened the database in the same folder on the shared server and I was able to see all of the data for that record.

View 1 Replies View Related

Forms :: Limit User Access In Form And Report

Jun 19, 2015

what is the best way and good practice in limiting user's access in form or report.For example, i have 2 users in my UserTable, one is Administrator and the other is just ordinary user.In case i want the ordinary user to open the form in "Read Only" mode, and the Administrator in "Edit" mode.

Do I need to make a code for each form to be opened or there's another easy way to handle this? (I am thinking for additional fields in UserTable to store their individual rights, but after that i don't know what to do next)

View 1 Replies View Related

Setting User Privileges

Aug 3, 2006

Hi,

Does anyone know a good tutorial about setting user privileges in MS Access?
I have googled it, but could not find any thing interesting!

Thanks in advance.

View 1 Replies View Related

Forms :: Way To Limit The Number Of Entries A User Can Make To A Form Based On A Value

Jan 20, 2015

My problem is the following: when I receive say 5 computers in a purchase form, I want to register the serial number of each of them in another form, bound to another table.If I receive 2 units in the purchase form, my user should only be able to input 2 records in the serial form (a continuous form), if we receive 3, then only 3 records,I cannot quite figure out how to build this second (serial number registration form), so that it refuses input after the correct number has been reached.

View 14 Replies View Related







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