Switchboard/Menu On Startup That Is Specific To The User

Dec 22, 2004

Hi all - I'd like to create a menu for 3 different users so the menus will pop up when each respective user opens the database. I'd use a switchboard but I want more freedom in my form. Is there a way to do this in access? For example, I'd like Menu 1 to automatically open when USER 1 logs on, Menu 2 to automatically open when USER 2 logs on, and so on. I've set up security already and know how to use the startup, Display Form/Page item under tools. I just need to open different menus depending on the user. Any ideas would be of great help. Thanks much.

View Replies


ADVERTISEMENT

Startup Menu

May 21, 2007

I craeted a startup menu and unchecked all the backend functions - now I cant getinto design view - what should I do?

View 14 Replies View Related

Switchboard Open On Startup

Mar 8, 2006

Is there i way so that when you open up your database you can get your Switchboard to open up??? is there a simple box to click to make it do this that i am missing or is it some VB code?

Help please thanks alot
l33tskyline aka Chewstar

View 5 Replies View Related

Toolbars: View, Tools, Startup Menu

Aug 29, 2007

Hello,
I've read most of the General category on Toolbars and Startup Menus, but still can't figure this out. I have no VIEW or TOOLS on my toolbar, so I can't get to the startup menu, toolbars, or anything else. When I go to Customize, one option is Built-in Menus. When I try to drag the VIEW or the TOOLS to the menu bar, it won't happen. I have tried the Shift trick, but it did not work either. Can someone help me?

View 1 Replies View Related

Database Window Not Closing With Startup Menu!!!

May 10, 2006

MS Access 2000

Hello everybody,

I am having a strange problem and despite trying out all the suggestions already discussed in this forum, the problem still persists.

My DB is already complete and I have done the following
1) Startup menu/uncheck all the option boxes
2) Tools menu/options/unchecked "windows in taskbar"
3) converted the DB into mde. file
4) Disabled the shift key
However, despite doing all the above, the "Database windows" shows up behind all the forms.

As per suggestions given by many here, I have also used

DoCmd.RunCommand acCmdWindowHide

This also does not work.

Also tried running the following in a macro from this link
http://www.mvps.org/access/api/api0019.htm

All the above have not worked and if anyone has any ideas or another way of doing this, I would really appreciate it.

View 3 Replies View Related

Forms :: Access 2010 - Hide Menu On Startup?

Feb 4, 2015

Well, I made the move and am using Access 2010 now and I am running into a couple issues.

First off, I want to get rid of this menu on startup:

Not sure what it's called (ribbon, menu bar, etc). I am able to hide it using

DoCmd.RunCommand acCmdWindowHide
DoCmd.ShowToolbar "Ribbon", acToolbarNo

...in the OnLoad event, but this only works when running the opening form from the form list. When the form runs at startup the menus do not hide.

Also I would still like to have the file menu available because sometimes the user need to access the print menu to choose an alternate printer.

View 14 Replies View Related

How Can I Create My Own SwitchBoard Menu?

Mar 12, 2007

Hi

Can anyone tell me how I can create a switchboard without using the Switchboard manager?

I want to create my own menu that will allow the user to add or edit forms. But im not sure how to do this. Does this involve VBA coding?

View 4 Replies View Related

Creating A Switchboard (main Menu)

Sep 9, 2005

I have recently created a small inventory database just for fun, but I am looking to expand my knowledge with Access since I have not dealt with it hardly at all. I would like to know how to create a regular main menu to the database that gives you options on what you want to do. I would like to be able to look up inventory by serial number, edit inventory, add inventory, and run reports from the main menu. If anyone could help, I would greatly appreciate it.

View 1 Replies View Related

Set Different Startup Forms Depending On User

Mar 2, 2007

Hi! I have a database and I have two groups of users: admins and users. The admins' switchboard is different than the users' switchboard. I cannot for the life of me figure out how to tell the db to open the admin switchboard if the admin logs in, or the user switchboard if the user logs in. Any suggestions? Is this even possible? I'm looking forward to your replies. Thanks!

KellyJo

View 1 Replies View Related

Modules & VBA :: Load User Defined Function At Startup?

Jul 15, 2013

I have quite a few user defined / custom functions which I would like to be available in any new database that I create without have to copy the VBA codes in a module each time. Basically, some sort of add-in that loads on MS Access startup may be (but I am not too sure - never created one). So something that will start with the MS Access Application and not just a particular database. I know excel addins can be copied to the XLStartup folder to achieve something like this in excel, but not sure about Access.

View 11 Replies View Related

Finding And Opening A Specific Record From A Switchboard

Oct 5, 2004

I have created a database with a switchboard and a form ("RMA"). Currently, on my "RMA" form I have a command button that allows the user to find a specific record by entering an RMA number into an input box. My code is as follows:

Private Sub cmdFindRMA_Click()
Dim myFilter as String
If vFindRMA = "" Then 'vFindRMA is a global variable, string.
vFindRMA = InputBox ("Enter the RMA Number to find:", "Find RMA", "", 5000, 3000)
myFilter = "[RMA_Number]='" & vFindRMA & "'"
Me.Filter = myFilter
If Me.Filter = "" Then
Me.FilterOn = False
Else
Me.FilterOn = True
End If
End If
vFindRMA = ""
End Sub

I want to be able to remove this command button from my RMA form and add it to my Switchboard. My problem is, I don't know what code I need to use in order for it to work from the switchboard. Can anyone help?

S.Pommier

View 1 Replies View Related

Reports/query By User From Drop Down Menu

Mar 16, 2005

I have a report which lists spend by customer. It is based on a query which requests the customer number I want the report for.

How can I get the query/report to offer a drop down list of the customer numbers available, so that I don't have to manually enter the number each time from memory!

Thanks in advance!

Regards

Peter

View 2 Replies View Related

General :: Need To Change A User Created Menu

Aug 6, 2014

I have a database that was created in Access 2003. I'm using this MDB in Access 2010.I need to change a user created menu. The update involves changing an existing entry and adding a new menu item. The menu looks like:

Project
Time Entry
Time Spread

I need the "Time Spread" to change to "Time Spread Daily" with a changed macro name. After that a new menu entry is "Time Spread Monthly". This menu will run a new macro that will display a form.I think the only way to do that in 2010 is to use VBA.

View 1 Replies View Related

User Security Access 2013 For Switchboard Items

Aug 3, 2015

I have user security level setup with username and password.I have set forms and tables etc to security levels.what i am having trouble with is setting user security levels to command buttons on the switchboard.Example if you sign in Mary Jones and you click on the command button (open Tom Smith switchboard) button on the main switchboard and your not tom smith you get a message access denied.

Code:
Private Sub Form_Open(Cancel As Integer)
If Forms!frmLogin!cboUser.Column(4) <> 2 Then
MsgBox "you cant open this form"

[code]...

it is a switchboard page. and putting CoCmd.OpenSwitchboardPage that does not work either..when you look at the event on click of the command button a macro opens up but I dont see how you can edit it.

View 5 Replies View Related

Forms :: Creating Report Menu To Allow User Filters

Aug 26, 2013

I have been tasked to create a report menu for my users to select a report (there are about 20), select which filters that they want to apply to that report, then run based on what the user selected as the filters.

I have about 30 different filters to create, and based on which report the user selects, the filters that apply will need to be shown. I'm thinking the reports will be in an option group, and based on which report the users selects the filters that apply to that report will be displayed. From there the user can choose to apply a filter or not, and run the report.

I am trying to figure out the best way to tackle this. Should I try to create a table that contains the report name and type of filter to loop thru the controls to set visible, and build the SQL?

View 6 Replies View Related

Forms :: User View - Reduce Amount Of Options On Menu Bars

Aug 15, 2013

I have created a front end and put into production for my users but I want to reduce the amount of menu bar options they see so someone cant click on a button wondering what it does and mess something up. What is the best way to reduce the amount of options a user sees on the menu bars when they open the front end of the db?

View 1 Replies View Related

Editing The "Application-Specific" Menu Items...

Feb 14, 2007

Hello,I have been examining an Access application and it has menus and several menu items under the headings of those menus. (I could call them as well "Application-Specific menus" as they contain shortcuts to the forms inside the application, such as "Offers>>Prepare a sales offer" , "Definitions>>Customers & Locations" , or "Definitions>>Series & Models" and so on...)In View>>Toolbars>>Customize, selecting the checkbox of that menu,I can make those Application-Specific menus appear also in design mode.So far so good, but....if I'm able to make them appear in design mode, I should also be able to "edit" them, right? But I simply can't edit them.For example, I can't seem to pull the menu item "Definitions>>Customers & Locations" and put it under the "Offers" menu. (so that a new item called "Offers>>Customers & Locations" is formed)Well as an Admin, I 'm supposed to do it, as one the users suggested that it be more effective if the menu item "Customers & Locations" stood under the "Offers" menu.So, how can I edit my "Application-specific" menu items? Thanks.

View 5 Replies View Related

Query By Specific User Help

Oct 12, 2007

Hi.

I want ot create a query for specific users. I have 10 users. my problem is that one of the users can view all the other users entered in the database and the other 9, can view only what each user entered.

example user1 : view only his records
user2 : view only his records
user 10 : view all records entered by user1 and user2

Any help please.
Thanks

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

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

Form Opens To Records Only For Specific User?

Nov 7, 2005

I have a User Main Menu as seen below with the command buttons for New Work Log Entry and Edit Work Log Entry. The New Work Log entry opens a blank Work Log as shown below. The Work Log form's record source is tblWorkLog. The user will fill out all the fields except the End Page and Total Worked Pages. The user will then exit out of the database. When ready to enter the total worked pages the user log back in to the db and will click on the Edit Work Log Entry.

This is supposed to open up the last entry the current user was working on so that he or she can enter the End Page and Total Worked Pages

Currently it is opening up the last entry of the table even if it was a different user's.

How can I change this? I need it where it opens up the last record for that person. There are going to be 50 users so I can't have it open up to the last record of the table.

Any help will be apppreciated.


http://img.photobucket.com/albums/v332/youmnac/UserMenu.jpg

http://img.photobucket.com/albums/v332/youmnac/WorkLog.jpg

View 2 Replies View Related

Forms :: Form Reminders For Specific User Only?

Feb 25, 2014

In my database, I have a form of reminder.

Query collect all the information about the unfinished business at the base and at the start-up of the base shows form reminders.

The base is splitet into front and back end, and are located on the server. Each user is assigned rights what can be done in the database.

The problem where I am "stuck" is to make the form reminder that can be seen only by those users whose jobs are not completed and not all users of the database. Each user uses his computer with your username and password. I tried to connect to form reminder with this information, but I failed.

View 5 Replies View Related

Tables :: End User Input To Pull A Specific Record

Dec 5, 2012

I want to use a Form or Report to have the end user enter say a Customer # or the Customer Last Name and then have Access pull and display that record so that the end user can than print all the saved information from that record.

View 2 Replies View Related

Modules & VBA :: Moving PDF Files To User Specific Folder

Feb 11, 2015

I'm Trying to move PDF Files associated with a customer to there specific folder

The query gathers the data, Gives me a list of files by account number

Now I want to use the results of the query to move those files

View 5 Replies View Related

Modules & VBA :: How To Log Into A Specific Outlook User Account In Access

Aug 6, 2013

How to log into a specific outlook user account and then send an email from that account ? I need the code

At the moment i can only get it to send emails from the account my outlook logs into by default ie my own profile's account.

View 12 Replies View Related

Sending A Form From Access Via Outlook To A Specific User

Aug 12, 2015

I have built a Travel database and what I'm trying to accomplish is sending the form. For instance, If I fill out the form with the travel information, expenses, destination, etc. at the bottom I specify a manager who needs to approve my request. I have two command buttons one to save the record and the other to submit. What I would like to happen is that when the person filling out the form clicks the submit button an email generates to the manager they've selected with a link of that specific form in the message body.Then when the manager receives the link they go in open the form approve it and then when the manager clicks the submit button I would like it to send the form to our financial personnel.

View 4 Replies View Related







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