Access 2010 / Restrict User To Navigation Form?

Apr 22, 2012

I have a database in Access 2010 where I've created a navigation form, and I want a regular user opening the database to enter a password and only have access to that form, and not the actual tables or the navigation pane. They should only be able to view, add, edit, and delete data through the forms I've prepared, and I don't want them to be able to get to the tables themselves unless they have an admin password. I tried looking up how to do something like this, and I tried splitting the database, but it seemed like I was still able to go right to the tables and edit them from the navigation pane even in the front-end, and if I removed the navigation pane links to the tables from the front-end, the forms I made wouldn't be able to display anything from them anymore, and that's not what I want either.

So, I want one password to give access only to my navigation form and nothing else, and then a second password to grant access to everything else.

View Replies


ADVERTISEMENT

Forms :: Access 2010 Navigation Pane Resets Previous Form

May 13, 2015

I have a 2010 Access Database with a Navigation Pane. When I click a Navigation Button to view another form I lose the position and record I was on in the first form. It's almost like the first form refreshed when I click the navigation button to view the second form. Is there a way to setup the Navigation form so when I click on various navigation buttons it won't reset the previous form I was on?

View 1 Replies View Related

Restrict User Access To Specific Records

Oct 12, 2005

I have a staff database in my office which holds, amongst other things a list of staff holiday taken. Presently the staff have no access to view holidays because they will also be able to view other employees details. What I need to do is enable members of staff to see their own holiday, but no others and Im really not sure how to go about it.

I have a workgroup in place; so each user has their own login/password.

Any ideas would be gratefully received.

Thanks,
Adam.

View 3 Replies View Related

Access 2000 - Restrict User To Key In Certain Fields

Sep 26, 2005

Hi, I would like to know how to do the following scenario in Access 2000.

Imagine I have a table, which has two fields X and Y.
User can only enter either field X or Y, but not both.
How to check the above case while user is real-time keying in the fields of the table?

Thanks, Sally

View 2 Replies View Related

Forms :: Coding User Login Form In ACCESS 2010

Apr 14, 2013

I have used Combo box. security_level field is the one that describes their levels and there are only two levels 1 and 2.. I have a table called User (user_ ID, User_Name, Password, Security_Level) On form there is a combo box for user name and text box for password. Two command button where one is for EXIT (Closing the application) and the second button is to run the code.

if the password in table User matches value chosen in combo box or user name and password are correct Then it should check if Security_Level of the user is equal to 1 to displays a form called Admin and when the Security_Level of the user is equal to 2 to display a form called user1.All that I want is to have a login that has two user and each user when login opens his/her own form which is different from the other user.

View 14 Replies View Related

Forms :: Restrict The User To Fill A Field On A Form?

Jul 5, 2013

I have two fields on a form. One of the fields has to be entered first in order for the other field to be filled. How can I restrict the user to enter a value in filed #2 before filling the filed #1?

View 7 Replies View Related

Forms :: Restrict A Form So That Only One User Can Open It Any One Time

Oct 10, 2014

On a split database, is there a way to restrict a form so that only one user can have it open at any one time?

View 3 Replies View Related

Modules & VBA :: How To Stop Display Navigation Pane In Access 2010

Nov 11, 2013

i am running some code from vba to add a linked table and the do some lookups, then delete the linked tables.

When the linked table gets added, the navigation pane gets displayed. I have set it to do not display in the settings and it does not when it opens but when this code runs it opens and then stays open until the db is closed and reopened.

I am trying to use my db as a software and I really do not want this to show.

I have also noticed this in a database I have which has update queries and was fine in access 2000 but does what i described above when using in access 2010.

View 2 Replies View Related

Forms :: Referencing A Control On Access 2010 Navigation System

May 29, 2015

I have an Access 2010 Database frontend to SQL Server 2008 Backend. So far there are 3 Tabs in the Navigation System. The first one is the primary Data Entry form which has a tab control with 3 subforms.

Here's the problem. The database is designed to track potential members based on different types of Ads. The primary Data Entry form holds all of the demographic data for the person that called in response to an ad. The first tab has a subform to track how many times that person has contacted us. The second subform tracks which advertisements the person is contacting us about and the third tracks which Events that person attended. There is no correlation between contacts, Ads and Events.

On the Advertisements we have about 7 different types of Ads we do and each ad can be run multiple times on different days. We want to be able to track which Ad the person contacted us about. The Advertisement subform has a comgo box for the Ad type and a combo box for the ad date. the source for the combo box for the ad date includes the combobox for the adtype as the criteria. That criteria is what's giving me the problem. I've used:

forms!mainmenu!navigationsubform.form!potential_me mbers!frmAdvertisements!cboadvid

Along with every other variation I can think of. The form itself is frmAdvertisements but I'm using it in a tab control and I also tried:

forms!mainment!navigationsubform.form!potential_me mbers!adv!cboadvid

View 6 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

Forms :: 2010 - Exporting To Excel Via Navigation Form (blank Reports)

Jun 13, 2013

I have decided to move away from Switchboard in Access 2010, to what I find to be more user-friendly; the Navigation Forms.

However, when I attempt to export any of the data from my navigation forms, the result is a blank Excel sheet. I can easily go into the forms themselves on the left navigation panel and export from there, but when myself or a user attempts to do this from the navigation forms themselves; well, the blank Excel sheet is the result.

How do you create a work-around, so that it is possible to export to Excel from these navigation forms?

View 14 Replies View Related

Access 2010 - Restricting User Access

Oct 15, 2015

I have Access 2010 database.

I have a Reporting Dashboard form that inturn has many buttons to open up different reports and forms.

Now I have been asked to extend the access to a few other users with restricted access. The new users cannot see all the form and report buttons in the Reporting dashboard form.

How can i restrict this? They also need to be given separate logins and passwords. How I can accomplish this?

View 2 Replies View Related

General :: How To Restrict A User When Log In

Nov 22, 2012

My query is how to restrict a user when he logs in......say for example, if he is a guest user he will not be able to change the setting neither he will be able to see the design mode..i am using access 2003

View 3 Replies View Related

Login Form Which Restrict The Access

Feb 20, 2005

hi

i am having a login form.
where i have only two users..may be 3
suppose it is admin and guest
then i have a main form where i have 5 tabs,...where each tab contains 7 or more command buttons which will open some forms
what i need is when the admin is login he should be able to edit add delete
but if it is a guest then all the forms should be read only
i know abt the allowaddition and etc..but i don't know where to use it..
is it in the login form or in the main form or in each and every form

regards
jenson

View 1 Replies View Related

Access 2010 - Pulling TOP / Max Number Of Records User Prompted For Value

Oct 23, 2013

I would like a user to specify the total number of records they need from a query result. The result must be random, therefore cannot filter on any field or data in the table.

On a form, the user enters the total # of records they need and selects a button that executes this:

DoCmd.RunSQL.SELECT DcountRDP.RDP_IND, DcountRDP.GRP_ST_CD, DcountRDP.AUDIT_STATUS, DcountRDP.AUDIT_TYPE, DcountRDP.AUD_ID, DcountRDP.ACURT_IND, DcountRDP.AUD_DT
FROM DcountRDP
WHERE DcountRDP.MaxRecords = [Forms]![Open_Frm]![IL]

This is not working at all.

How can I make it possible for the user to enter a total needed or be prompted to enter a total and then randomly produce the first top # of records that they specify?

View 1 Replies View Related

General :: Security And User Read / Write Permissions - Access 2010

Jul 19, 2013

I'm a SQL Server DBA and have a few Access 2010 Db's to look after and occasionally have to make amendments to (as is the case today). I've been asked to apply permissions to certain users of the Access database whereby users in a group we're calling 'Viewer' only have read permission and users in another group called 'Writer' (original I know!) have both read and write permission.

The database is form driven (i.e. no-one directly accesses and amends the tables in the database), the file is saved with a .mdb extension.

I've played around with the 'Manage Users & Permissions' in the File Menu however these don't seem to do what I need them to and only result in having to input a user and password to access the database on start-up.

View 1 Replies View Related

Forms :: Navigation Forms In Access 2010

Nov 20, 2014

I have a Main (Home) form that has a sub navigation form (frmNavigationSubform).Need to access 3 forms. Forms 1,2 and 3. Also, have 1 options form.

Subform has 2 Navigation buttons. NavigationButton2 and NavigationButton3.

NavigationButton 2 Navigation Target Name = 1 (frm #1).

NavigationButton 3 has no Navigation Target Name. This is passed on when user picks Option1 or Option2 form options pop screen.

Now I can pass the name to the Navigation Buttons2 but the subform does not show it. I have to click on the Navigation Buttons2 again for it to show. What I want is when the user makes the choice in the options screen the name is passed and form 2 or 3 should load/show.

View 1 Replies View Related

Forms :: Restrict User To Enter Data If Dsum Exceeds Total

Sep 8, 2014

I need to be able to restrict users enter a value in the text box (on Form B) called "FTE Assigned" if Dsum of a field called "FTE Allocated" in another form A is less than what is going to be sum of FTE Assigned after the value is entered.

Both these forms are used by users to enter data in the 2 separate tables which are linked together through a join.

Master table - having FTE Allocated values and secondary table having FTE Assigned values.

Basically a message box would do if Dsum (of FTE used) is coming out higher than FTE allocated.

View 4 Replies View Related

General :: How To Use Automation To Run Word 2010 Mail Merge From Access 2010

Nov 26, 2013

I have a MS Access 2010 application when the User opens form CONTACTS Form

◦User finds single record to be used CONTACTID is identifier to be used for selection
◦User clicks button to open form frm_MAIL_MERGE
◦Frm_MAIL_MERGE has a drop down combo box that reads the folder location where the application resides and displays all .DOTM files (that is all template files) and one more combo box which contains the CONTACTID.
◦User selects single .dotm file for merge
◦Frm_MAIL_MERGE has either drop down to select CONTACTID or UNBOUND data field for user to type in CONTACTID number
◦User enters CONTACTID to be used for the mail merge
◦User selects SUBMIT
◦Application merges selected .dotm file with the information in table CONTACTS for the selected CONTACTID
◦Merged document is saved on the user Desktop as xxx.docx

View 10 Replies View Related

General :: Possible To Have Value In Excel 2010 Cell Used To Update Access 2010 Database

Apr 4, 2013

Is it possible to have a value in an excel 2010 cell be used to update an access 2010 db?

For example, if in a spreadsheet "test" cell A2=3 then in a db "test" a column "value" is 3. However, if the value in the spreadsheet changes so does the db.

View 1 Replies View Related

General :: Calendar Synchronization - Access 2010 To Outlook 2010

Mar 23, 2015

I wish to work in Access 2010 with a subset of my Outlook 2010 contacts (all desktop- no network barriers), so I am exploring the Desktop Contacts DB found in Microsoft's templates. It passes contact data back and forth using the standard macros, but I wish to add more fields from Outlook. It seems I need to find the code associated with the macro. I believe I can solve the problem using a Linked table, but am wondering if there is another solution?

Calendar synchronization is another issue. Linking gets me to the Archive Calendars, but not the Current one in Outlook which is what I want.

View 2 Replies View Related

Forms :: Not Able To Disable Navigation Button When Login Navigation Form

Nov 15, 2014

I am not able to disable NavigationButton when i login navigation form using login form. I am using MS access 2007 - 2010.i am using below code but getting error.

Forms![Navigation Form]!NavigationButton13.enable = False

Error
Run-time error '438'
Object doesn't support this property or method.

Any other method to disable NavigationButton.

View 2 Replies View Related

Restrict Access

Feb 27, 2008

Is there any way for me to have a button on my frontpage visible to only people i name
e.g.
if user = john smith or user = fred bloggs then show the button if not do not display it.?
Being a novice step by step idiot proof help would be appreciated
TIA

View 4 Replies View Related

Forms :: Access 2010 - Opening New Form And Closing Current Form?

Mar 14, 2013

I am using Access 2010 - Version 14.0.61.29.5000 (32-bit)

I am building a custom Export Wizard to export data to Excel using the Report Wizard for the basic ideas.

All I am trying to do is have a [Back] button on a form to open another form and close the current form.

Private Sub cmdBack_Click()
DoCmd.OpenForm "frm_ExportWizardPage2", , , , , , Nz(Me.OpenArgs)
DoCmd.Close acForm, "frm_ExportWizardPage3"
End Sub

The new form is opening but then the current form is not closing. All forms are the same size, shape and positioned centrally although this should not make any difference.

Could this be anything to do with which form has the focus when I open the new form?

View 2 Replies View Related

Restrict Access To Forms

Aug 23, 2006

I have impletemented a user system for my database with different access levels relating to entering and editing data.

I would like to make certain forms only accessible to a specific group of users. Is this possible and how?

Thanks,

Gary

View 1 Replies View Related

General :: How To Get Access To Default Navigation Buttons On Form

Nov 1, 2013

how do I get access to the default navigation buttons on a form ie back, forward, new and last buttons. I want to right some VB code that acts when the buttons are pressed. How do I do it?I don't really want to create my own buttons and do onclick events.

View 3 Replies View Related







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