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 Replies


ADVERTISEMENT

Forms :: Right Click Menu In Popup Form On Access 2010?

Dec 11, 2013

I'm trying to do right click menu on listbox.

currently i'm trying to implement a right click menu which will show a simple messege box.

My problem is that the list box is on a pop up form which opened up maximized. Now when i'm right clicking on the list box i see the right click menu but when i'm clicking on one of the menu options, nothing happenning (it seems that it don't go to the function as it should). i've also putted breakpoints on the function but it never tips.

It's important to mention that if i'm setting the form popup option to no the right click menu works perfectly (when i'm clicking on one of the options i see its matching messege box).

I'm running the following vba code:

This is the mouse up event handler for my list box:

Private Sub Song_List_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
' Call the SetUpContextMenu function to ensure it is setup with most current context
' Note: This really only needs to be setup once for this example since nothing is

[Code] .....

setting up the "SetUpContextMenu" sub:

Public Sub SetUpContextMenu()
' Note: This requires a reference to Microsoft Office Object Library
Dim combo As CommandBarControl
' Since it may have been defined in the past, it should be deleted,
' or if it has not been defined in the past, the error should be ignored

[code].....

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

General :: Hide File Tab In Access 2010

Jan 25, 2013

I just upgraded to Access 2010. I was able to solve all migrational issues, but my custom ribbon is showing two File tabs, one that I created and the default access file tab. How to get rid of the default File tab or at least disable it?

View 8 Replies View Related

General :: How To Edit Access 2010 Default Shortcut Menu

Dec 10, 2014

I am building a db and i want to disable the Shortcut Menu (pull down menu at form's title bar) to prevent the users from closing the main form.

There is a Disable Shortcut menu setting in the File/Options menu but the whole db gets the setting.

I simply want to deny the users from accessing the Shortcut Menu when on the Main Menu (or a particular form) but allow it on other forms where Printing is required via the Shortcut Menu.

Im looking at 2 options; edit the shortcut menu or force a form to disable that w/o affecting other forms.

View 3 Replies View Related

Reports :: How To Customize Right Click Shortcut Menu In Access 2010

Mar 29, 2015

how to customize my right click "Short-cut" menu in Access 2010. I need a right click menu with ONLY the "Print" and "Print Preview" options for my reports and I would like to disable right click in all other objects.

View 3 Replies View Related

Forms :: How To Create Custom Menu Options In 2010

Sep 15, 2014

How to create custom menus in Forms in MS ACcess 2010. For example, I have a form fmrMainMenu. At the top of the form I want to create a menu labelled "Reports" that when clicked or hovered it displays a list of sub-menu options of all the Reports available in the database. Once the user makes a selection the report is generated. The functionality that I am looking for is similar to the old menu options like File, Edit, etc., in MS Office.

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

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

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

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 9 Replies View Related

Hide Objects Window On StartUp

Feb 9, 2006

How can I hide the objects window on startup. I did it before witha command, but I cant remember how!

View 1 Replies View Related

Hide/unhide Menu Bar

Dec 21, 2005

I did hide the menu bar,

Tools->customize....

but how can I unhide the menu bar, because hide/unhide option is on the menu bar. If I hide it, then I cannot unhide it.

View 4 Replies View Related

Modules & VBA :: Custom Tool Bar / Menu Handling In 2010?

Jun 23, 2014

I know that ever since 2007 custom menus are not well supported as in 2003. From what I've read, outside to using 2003 to make changes, a person can create/update the menus using Commandbars in VBA.

Some coding to use Commandbars to create/update menus/toolbars for Access 2007/2010? It seems possible to do that, although I would expect it would be a lot of work. I've seen a few one-off examples to do specific updates, but so far nothing that would approach what was available in 2003.

View 3 Replies View Related

General :: How To Hide Parent Table In DLOOKUP Wizard In 2010

Dec 1, 2012

here I have capture what is error actually when i make a DLOOKUP wizard.the box of wizard. there i want to make a relationship with table2. but we could see that table1 still show. yes right, it's reality making error and show message ""you can't modify the structure of table, because it is already in use by another person or process"and warning message ""Microsoft access couldn't launch the lookup wizard, or this wizard has been disabled...blabla...blaa"

on my laptop, ms access 2010 nothing happen the mattter and when i make DLOOKUP, parent table have been not seen.and make DLOOKUP Wizard is successfull.

why in my PC, when i make DLOOKUP wizard, parent table still show?what is this bug for MS access 2010?

View 4 Replies View Related

Forms :: Multi Select Listbox Access 2003 Code Gives Syntax Error In MS Access 2010

Oct 24, 2013

I've been using the following code successfully in Access 2003 & now I need to migrate to Access 2010. The purpose of the code is to use the items that the user selects in the list box to build the criteria of a query. Access 2010 keeps giving me a syntax error when I try to run the query & I don't know why:

My code is:

On Error GoTo Err_Command151_Click

' Declare variables
Dim db As DAO.Database
Dim qdf As DAO.QueryDef
Dim varItem As Variant
Dim strCriteria As String
Dim strSQL As String

[Code] .....

The syntax error I get in Access 2010 is:

Syntax Error in query expression 'SELECT * FROM
qryContractListSummarybyDateContract3TYPEBREAK WHERE
qryContractListSummarybyDateContract3TYPEBREAK.Rep ortableName IN('Adbri
Masonry NSW');'

View 12 Replies View Related

Forms :: Find Hex Or RGB Value For Blue Color That Access 2010 Uses By Default For Buttons On Forms?

Sep 5, 2014

Where can I find the Hex or RGB value for the blue colour that Access 2010 uses by default for buttons on forms? I need to change some buttons to yellow (I know the code for that) but later change them back to the previous shade of blue, which is shown in the Properties pane "Accent 1, Lighter 40%".

By clicking in the standard colors area at the bottom of the colour chooser I can find a very similar blue #D6DFEC but it doesn't look quite right. And the "accent" colour does not give me a Hex value.Is that "usual" blue even one colour? How can I reset a button to that style having changed it?

View 14 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 :: Access 2010 - No RTF For Textbox

Jun 12, 2014

I am using Access 2010 and have a form based upon a query (qry_student). In tihs query I have a field called Details that contains the student's address; a composite of the relevant fields from the table tbl_student. I have used chr(13) & chr(10) to create linebreaks wihtin the query field.

I have a textbox where the Control Source is set to this field of the query.

The textbox does not display the data correct and I believe this is because it is in Plain Text mode.

When I try to change it to Rich Text I get an error message.

If I remove the control source then I can change it to Rich Text but then this negates the very purpose of the textbox.

View 1 Replies View Related

Forms :: Converting 2010 32 Bit Access Form To 64 Bit

Apr 7, 2014

We recently updated to 64 bit Office 2010, however there is a form created by an intern who has since moved on, anyways the form was created in 32 bit. SO hence we cannot open it. We get any error message that it was created in 32 bit and cannot be open in 64 bit Office. I have tried to resaved the form on a different pc with 64 bit office. But it will not allow me to save, possibly because the form is locked down from changes. The file extension is .accde.

View 1 Replies View Related

Forms :: Access 2010 Subform Filtering

Nov 5, 2014

I have not used access since Office 97 so, I see many changes. A while back I used Access to create some minor tracking databases. Now, with 2010 I'd like to modify the database that I am currently using. I have a main form that tracks daily trips or tasking(s). Within the form are two sub forms that track:

1. People assigned to the trip through a combo box; and
2. Itinerary for this trip.

I have been asked to add a Trip justification(s) through a combo box which will have several selections avail that can be chosen and would apply to each trip. These can be added to by double clicking the justification (figured that one out). What I would like the sub form to do for each new trip that is entered is to display only these values as a single selection rather than 12 times (example) if there are 12 trips that have the reason justification as part of the trip/tasking.

I just can't seem to make this work. The personnel one and itinerary one work just fine (previously existing). I just can't seem to get the new one to work. I have checked that the new table is connected through the relationships. In the exact same manner. The new form has the ID (Key) OPID (to link each trip separately) and justification text field.

View 6 Replies View Related

Forms :: Put Password To Open A Tab In Access 2010

Jul 31, 2013

Is it possible to put password for a tab in Access 2010?

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







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