Main Menu Form

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 Replies


ADVERTISEMENT

Database With A Main Menu Form Containing A Button That Loads Main Data Entry Form

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

Forms :: Main Menu Form Not Maximized?

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

Making Navigation Form /main Menu That Linked To Tables

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

Forms :: Closing Opening Form With Timer Then Opening Main Menu

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

Deactivating Main Menu Bar

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

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

Display 5 Last Records On A Main Menu

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

Access 2010 - Search Field On Main Menu?

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

Count Number Of Yes Entries And Display It On Main Menu

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

Unable To Create A Main Menu Page For Database

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

Reports :: Column Heading On Report To Pull From Main Menu?

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

Forms :: Getting Monday And Friday Of Current Week On Main Menu?

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

Access 2010 - Main Menu Needs Drop Down Box Referencing A Table For SEARCH

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

Why Is Main Form Update Event Triggered When Subform Dirties Main Form?

Dec 1, 2005

I have a subform which makes a change to a field on the main form. When focus is returned to the main form, the BeforeUpdate and AfterUpdate events fire. Why? I thought from the form's perspective, the subform is just another control.

BTW, I get the same behavior if I modify the field from within the Exit event of the subform control.

In either case, the main form's Dirty event is NOT triggered.

View 2 Replies View Related

How To Show A Full Menu On The Menu Bar

Feb 19, 2007

Hi everyone,
I was trying out the options on the startup item of the tools item on the menu bar and my access window has gone except the following menu items: File,Window and Help.
Can someone kindly show me how to bring back these seemingly lost items?
Thank you for your willingness to help me out!

View 2 Replies View Related

Menu On Form

Feb 24, 2006

I have searched and read and figured out how to make a custom menu bar. I see how I can use the forms property sheet to change the menubar that is available when it is open.

I've also seen code to hide the database window so that the form appears as a stand alone application. Like these links:

http://www.access-programmers.co.uk/forums/showthread.php?t=100545
http://www.access-programmers.co.uk/forums/showthread.php?t=98163&highlight=hide+access

If I do that will my custom menubar is hidden?

Is there a way to add a menu bar directly to the form? Make it part of the form?

I found similar questions unanswered here:

http://www.access-programmers.co.uk/forums/showthread.php?t=75316&highlight=menu+bar+form

http://www.access-programmers.co.uk/forums/showthread.php?t=14722&highlight=menu+bar+form

It was answered here but I must be missing something.

http://www.access-programmers.co.uk/forums/showthread.php?t=55582&highlight=menu+bar+form

When I change the forms menubar property to me menubar, my menu bar is dsplayed when I open the form. It is displayed in the Access window, not in my form.

View 2 Replies View Related

Menu In A Form

Nov 11, 2006

I have a form that I want to display at startup and in that form I want to have a menu that will allow me to show outer forms and reports.

Can anyone tell me how to do that?

View 2 Replies View Related

Form Dropdown Menu

Nov 4, 2005

In an Access Project I have a form with a drop down menu linked to a parameter query. How would I set the query parameter to Environ("userName")? Any help would be appreciated.

Thank you

View 1 Replies View Related

Open Form On Menu Then Close Old Form

Feb 19, 2005

I've a custom menu bar from which I can choose any of my forms. However when you choose a new form the old form stays open, sloppy in my mind. Is there any way i can choose the new form from the menu bar & close the previous form? I've tried to close on deactivate, w/ no luck.

View 2 Replies View Related

Sub Menu In Form Based On Above Field

Feb 21, 2005

Hi it possible for lookup in 1 column to be dependant on the lookup on another columns depending on what is clicked in a form to make it easier

brand table
field 1: Number auto
field 2: Drink linked to lookup table called
drinks
field 3: type of drink linked to lookup table called
subdrinks

Drinks table
Pepsi
Coke
other

Subdrinks table
original coke cola
diet coke
coke with vanilla
coke with lemon
original pepsi
diet pepsi
persi max
pepsi with lemon

now in a form looking at the brand table. the person clicks on Drinks = picks coke from drop down menu
what I need is if the person picks on coke the next drop down menu type of drink it should only show those related to coke.
original coke cola
diet coke
coke with vanilla
coke with lemon
what i am getting is the second drop down shows everyhting and if the user makes a mistake the reports ie chose coke but in the next field chooses diet pepsi, the data does not make any sense. is there any way to limit the second drop down based on the choice in the first drop down.if there are any ideas to help in this matter maybe some VBA or macro may be required, i am not too sure open for suggestions and help would be appreciated.
Thanks

View 1 Replies View Related

Close Popup Menu Form

Sep 17, 2006

I've created a popup menu form to be loaded when you cick on another form. I need to know how to get the popup menu form to close when you click off it. I've tried using lostfocus and deactivate but that didn't work. Modal is set to no. What code should i use and where would it go?

View 8 Replies View Related

Open A Form From Drop Down Menu

Nov 15, 2006

I have an MS Access problem I need some help with. I am trying open a form for input from selection in a drop down menu in an access database. Any ideas on how I should do this??:confused:

View 3 Replies View Related

Forms :: Menu Form Keeps On Opening?

Jul 28, 2013

I have a series of forms. The 1st form is my main menu. On this form I have 5 command buttons which gives the user options to ...

Button1 - Enter Station Scores
Button2 - Print Performance Sheets
Button3 - Print Audit Sheets
Button4 - System Administration
Button5 - Quit

When the user clicks one of the buttons (with the exception of the Quit button) I perform the following code (This code is for the 1st button)...

Code:
Private Sub cmdEnterStationScores_Click()
' Open select workstation
DoCmd.OpenForm "frmSelectWorkstation", acNormal, , , , acWindowNormal
' Close main menu
DoCmd.Close acForm, "frmMainMenu", acSaveNo

End Sub

So far so good...

The "Select Workstation" form opens fine with no sign of the main menu. I have a "Continue" button on this form which opens yet another form using the following code...

Code:
Private Sub cmdContinue_Click()
' Delete workstation name
Call DeleteWorkstationName
' Store selected workstation
Call StoreWorkstationName(strSelectedStation)

[Code] ....

...For some reason the "Main Menu" form reopens itself at the same time as the "Enter Sort Scores" form, so I have 2 forms on the screen, with the "Main Menu" screen on top.

Why does the Menu form re-open?

I have set breakpoints in every bit of code I have and stepped through it all, but nothing I can see references the Menu form!

View 7 Replies View Related

Creating Drop Down Menu In A Form

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

Opening A Form From The Program Start Menu

Jun 10, 2006

Hi,

I would like to be able to open a customer form without starting MS Access.

Is there a way to make a form an executable module?

John

View 2 Replies View Related







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