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 Replies
ADVERTISEMENT
Jun 24, 2015
I have a database with a Main Menu Form, containing a Button that loads my main data entry form. When the Button is Clicked portions of the data entry form that is loading shows through the Main Form Background (e.g. portions of the navigation bars, and portions of the boarder on the form that is loading.)
View 5 Replies
View Related
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
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 9 Replies
View Related
Jul 6, 2006
Is there a way to have a song play when a form is opened?
View 2 Replies
View Related
Jun 1, 2005
Hey Guys,
Is there any way of deactivating the main Menu Bar ("File","Edit","Insert","Format") when a form opens?
I need to implement this for a single form to stop an idiot user from trying to break the system! :mad: He's not doing it on purpose - he's just ignorant and doesn't listen or understand when I try to explain to him NOT to add a record by using the "Insert - new record" command, but to use the command button on the form which has some built in safety features (such as password protection).
I've managed to get rid of some of the other ones by using the coding below:
Application.CommandBars("Form View").Enabled = False
Application.CommandBars("Formatting (Form/Report)").Enabled = False
Application.CommandBars("Formatting (Page)").Enabled = False
Any help would be greatly appreciated.
Cheers,
Rusty
:D
View 3 Replies
View Related
Nov 26, 2006
Hello all, i'm trying to create a database just now and i'm banging my head a little on the forms side of things.
Can anyone tell me how, or if its possible, to create a "Main Menu" form, that gives you options to say, add a record to a table, to delete a record etc.
any help would be greatly appreciated.
cheers guys
View 2 Replies
View Related
Nov 15, 2006
after i open a form using the switch board, i need to click a button to close the form and return back to the default switchboard.. what code do i need to put in the button to do the task?
View 8 Replies
View Related
Aug 13, 2015
menu items is it possible to show the last 5 items entered into the database on the main screen?
View 8 Replies
View Related
Apr 25, 2014
I have a front end that I have distributed to four users. The front end sits on a shared drive and when I make design changes I just replace it and have the users copy it over to their desktops.
I set up a main menu for them to access the various forms, reports, etc. When I first open the front end on my desktop the main menu form is small and not taking up the entire screen. I put the cmd.maximize command in the on open event and still does not maximize the form when I open the database. I tried to size it and saved changes but still not working.
I just did a share session with a user and she opened the form and it was maximized on her desktop.
View 3 Replies
View Related
May 7, 2014
Currently I have a basic database with the following
Table 1 = "EmployeeT" with fields "Employee_ID", "First_Name", "Last_Name" etc.
Table 2 = "NewLabReportT" with fields "Report_ID", "Report_History", "Submitted_By", "Reviewed_By", "Date_Submitted", "Report_Title", "Abstract"
Form 1 = "MainMenuF" this is where I would like to have the search
Form 2 = "NewLabReportF" with fields "Report_ID", "Report_History", "Submitted_By", "Reviewed_By", "Date_Submitted", "Report_Title", "Abstract"
Form 3 = "EmployeeF" with fields "Employee_ID", "First_Name", "Last_Name" etc.
Problem:I would like to have on the Main Menu a drop down list with all of the fields described in NewLaBReportF ("Report_ID", "Report_History", "Submitted_By", "Reviewed_By", "Date_Submitted", "Report_Title", "Abstract") and then allow the user to click a button to the side of it to alert a pop up.
In this pop up:
If they originally clicked "Report_Id" then have the message prompt then to "Enter a Report ID"
If they originally clicked "Submitted_By" then have the message prompt them to "Enter an employees Last Name"
etc...
Further More, after they enter the respective value in this box, have a FORM not a REPORT generate that lists all of the records that match the criteria. This way then can specifically click on each record individually and have it open directly up to it.
View 14 Replies
View Related
Aug 19, 2015
I have a table called exiting staff data and a field called Follow up required. I want to count the number of Yes entries and display it on the main menu. Have tried
Code:
=Count([Exiting Staff Data].[Follow up required]="Yes")
And using dcount but keep getting error messages.
View 13 Replies
View Related
Jun 2, 2015
I want to create a main menu page for my database. I have tried the Navigation form and obviously I am doing something wrong....because the tabs won't open the forms. We have Access 2010 at work and I would like to create something similar to this:
Cardinal Rap - Main Menu
[button] Input Monthly data
This button would take me to another screen that would list the tables for appropriation, expenditures and revenue, each with their own respective button
[button] Reports
This button would take me to another screen that would would list the reports available each with their own respective button
[button] Monthly reconciliations
This button would take me to another screen that would list the tables necessary for my monthly reconciliations each with their own respective button that open that table.
The tabs in the Navigation form don't seem to do anything.
View 1 Replies
View Related
Nov 20, 2014
I have fields on the main menu where folks put in a start and end date prior to running a report. I'm doing a monthly report that pulls current month, and two prior months of data. For example, the user selects a date range of 10/1/14 to 10/31/14 the report will show August, September and October results.
I need the column headings to change each month depending on the date range they select to run the report so in November they will pull 11/1/14 to 11/30/14 and get September, October and November.
The headings for the columns would then adjust.
I put an unbound text box with the formula as follows in the control source of the report page header to pull the month that is equal to the current month minus two (I'm just showing one of the column headings formula):
=Format([Forms]![Main Menu]![EndDate]-2,"mmmm yyyy")
This is not working. It's pulling the current month which I have set to run for October so it should show August 2014.
View 3 Replies
View Related
Jan 3, 2015
For some reason i'm having difficulty getting the Current Monday and Friday of the Current Week on my Main Menu. Monday shows 12/29/2014 ???
Here is the code for the scenario.
Monday: =CDate([AnyDate])-(Weekday(CDate([AnyDate])))-2+4+3-3
Friday: =Date()-(DatePart("w",Date(),2,1)-1)+4
AnyDate: Date()
View 8 Replies
View Related
Sep 6, 2013
I have been trying to figure out how to make a main menu that link to certain tables I have. I want the links to go to the tables/forms so that they can be edited, but I don't want the user to be able to enter design view. I have attached an image of what I want to have below.
View 3 Replies
View Related
Oct 1, 2013
I have a very large Access application and use a hidden "main switchboard" to store data such as the current customer ID. Prior to the advent of tempvars, I embedded a key control into many query's underlying combo boxes, list boxes and forms criteria:
"Forms![main switchboard]![currentcustomerid].
The problem arises when the user quits the application on with forms using this in their underlying query(ies). As far as I can tell, the application closes forms in the order in which they were opened, so the "main switchboard" closes first. Then, for some reason, the current form has a requery and the user is presented with a prompt to enter the parameter "forms![main switchboard]![currentcustomerid]. I tested and found I could replace the criteria reference to a tempvar to "fix" the problem. I wonder if there would be a way to open every query in design view and do a search and replace on the criteria statement.
View 9 Replies
View Related
May 6, 2014
I have a main menu "MainMenuF" in my database and I would like the database to be able to be searched by any of the column headings. For example I have a table titled "NewLabReportT" this table has many column headings like "Submitted By" "Reviewed By" "Title" "Abstract" etc...
I would like my users to be able to click a radio button with the same column headers on this main menu and have a box that pops up to say "Enter search parameter" and have that parameter be searched in the table "NewLabReportT" and generate a FORM not a REPORT of all of the listings in the database that have that keyword associated to that certain category searched. That way they can "CLICK" the exact field they are looking for and have it open right up to that form.
View 2 Replies
View Related
Aug 4, 2005
Greetings.
I am pulling my hair out trying to create a customized menu bar. Eventually, I want to have a customized menu bar and tool bar for report and different customized menu bar and tool bar for forms. I created the tool bar for the report window. Then when I tried to create a new menu bar I could not remove menu selections without removing the same menu selections from the default Menu Bar.
I selected View->Toolbars->Customize...
Then I clicked on New (command button)
Then I named it (RptMenuBar)
Then I selected 'Built-In Menus' from the Commands Tab
Then I dragged the 'File' from the Command list into the new Menu Bar
Then I went to the new menu bar and dropped down the selections under File and started to left click and drag what I didn't in the NEW MENU BAR. However, it turns out when I did that the same selections were removed from the default Menu Bar.
I was ablel to restore the default Menu Bar. But I want to have a customized Menu Bar and be able to select that new Menu Bar and associate it with every Report that is in my Database.
Any ideas? If you have some good instructional references, please point me in that direction. Thanks.
SueB
View 10 Replies
View Related
Jun 2, 2014
How I can create my own Ribbon which include drop down menus?
View 3 Replies
View Related
Aug 6, 2015
In the Lesson 22 tutorial presented here: [URL] .....
They create form where the called Countries toward the end where:
The have a textbox for Government Type. It is a drop down menu of choices that the database creator can choose such a capitalist, socialist, and communist etc.
However, in the form (with the records source as Countries) there is only a space for input no drop down menu. I know this may seem awful elementary to the seasoned database designer, but how does one get it to be a drop down menu?
I have made the input in Countries table to be a look-up which I typed (see above choices) and the is the control source for the Countries Form government type. But there is still no drop down menu with choices on the Countries form. What must I do additionally?
If this is already talked about in one of the MS Access 2010 tutorials earlier lessons then a referral to that source is all that is needed.
View 4 Replies
View Related
Jun 5, 2014
I'm working to put together a shortcut menu for a form that will be viewed as a datasheet. I'm trying to put together the vba to create the menu. I'd like a lot of the standard options i.e. sort a-z, filter toggle etc. I'd also like to add the menu option that is displayed in the default menu called "Text Filters". I've been unable to find the id code for that option, and since it, when chosen opens another menu, I'm not real sure how to code it. Here is what I have so far:
Sub CreateWIPShortcutMenu()
Dim cmbRightClick As Office.CommandBar
Dim cmbControl As Office.CommandBarControl
' Create the shortcut menu.
Set cmbRightClick = CommandBars.Add("cmdWIP", msoBarPopup, False, True)
[code]....
View 2 Replies
View Related
Jul 2, 2012
i would like to create custom menu bars for my forms report
View 6 Replies
View Related
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
Aug 16, 2013
I finally got tired of having 100 macros managing my different custom shortcut menus, and decided to figure out how to generate the shortcut menus programatically (because lets be honest, Macros are the devil.)
I found a good tutorial here : [URL] .....
and was able to create some basic shortcut menus like the following:
Code:
Sub CreateCopyShortcutMenu()
Dim cmbshortcutmenu As Office.CommandBar
Set cmbshortcutmenu = CommandBars.Add("CopyShortcutMenu", _
msoBarPopup, False, False)
'ID 19 adds copy command
cmbshortcutmenu.Controls.Add Type:=msoControlButton, Id:=19
End Sub
Nice and simple, now I have a copy command. But the problem is that I also need some custom commands. Most (possibly all?) of these would be function calls.
View 3 Replies
View Related
Apr 7, 2014
I have a Form opening from Access Options. I would like to close this Form using the Timer. The following is the code I have used but it is not working.
Private Sub Cover_Page_Form_Load()
OpenTimer = Timer
End Sub
Private Sub Cover_Page_Form_Timer()
If (Timer - OpenTime) = 5 Then DoCmd.Close acForm, "Cover_Page_Form", acSaveYes
End Sub
Next question. If I can get this to work can I then use a DoCmd to open new Form within the code above or do I need a new process.
View 5 Replies
View Related
