General :: Grayed Out Subform Menu
Jul 22, 2013How to activate the subform menu for MsAccess 2003 on a XP O/S.
View Replies
ADVERTISEMENT
General :: Navigation Pane Is Grayed Out
Dec 9, 2012I tried to modified access 2010 database. But I open it the Navigation Pane is grey out (disable) and I cannot to see any database object. How to make the Navigation Pane active?
View 1 Replies View RelatedGeneral :: Text Boxes Grayed Out After Clicking?
Aug 5, 2015I have a form with text boxes and after I click on the text box, the field gets grayed out. I can still read my text but I would rather it have it stay white.
MS Access 2010
Active X Control Comes Grayed Out?
May 29, 2014Set default controls comes as grayed out. I am in design view of form.
View 1 Replies View RelatedReports :: Print Preview Bar Grayed Out Sometimes
Dec 16, 2014When the report print preview shows up, the entire print preview bar is visible but greyed out, so nothing can be selected. When the user clicks on the report to zoom in, then the buttons become available and the user can print. At that point the user selects the printer and prints the document.They all share a networked back end and a locally installed front end (same version for everyone)
View 2 Replies View RelatedQueries :: Ribbon Choices Grayed Out
Nov 13, 2013Suddenly most of my ribbon functions are greyed out. I noticed it when I was trying to change a simple format. I tried closing outlook and reopening it but nothing is changed. I also tried other databases and still no dice.
View 2 Replies View RelatedTable Ribbon Events (before And After) Are Grayed Out
Aug 26, 2015Using Access 2013, my (Access 2002-2003 database) table ribbon events (before and after) are greyed out. How can I enable them?
View 4 Replies View RelatedGeneral :: How To Disable Menu Choice
Jun 16, 2014I have several menus defined for Access 2010. However, only one is set with the visible property set to true.The user is able to show and bring up the other menus by right-clicking in the menu area. How can I disable this so the user may not bring up these menus? An example is shown in the picture below. I don't want to give the user access to the "CPLAccess" and "Datasheet column removed" menus, but I do want to keep them so that I can make them visible via VBA.
View 8 Replies View RelatedGeneral :: Reset Default Menu Bar?
Dec 12, 2012I just change my default menu bar in access from start up option. And created a new menu with some sub menu which I want. But when I remove all tick mark from different toolbar and only select my new menu, I can't show default menu bar again. How I can show default menu bar?
View 8 Replies View RelatedGeneral :: Creating Custom Menu Bar For Form?
Jul 2, 2012i would like to create custom menu bars for my forms report
View 6 Replies View RelatedGeneral :: Need To Change A User Created Menu
Aug 6, 2014I 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.
General :: How To Edit Access 2010 Default Shortcut Menu
Dec 10, 2014I 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.
General :: Open Save Backup As Dialogue Box From File Menu
Sep 20, 2012I want to open the 'Save Backup As' Dialogue Box from the file menu, using a Command Button on a Form in Access 2003.I know you can do this manually but I would love to do it programically.
View 4 Replies View RelatedGeneral :: Lock / Unlock Full Menu Based On A Password
Sep 28, 2014I want to lock down and unlock the full menu based on a password..
For instance upon load of the database I would like it stripped down when a general user logs in... but if a admin logins in then they get all menus...
so based on the user type will dictate the menus visible.. cane this be achieved'''''''''''';
Forms :: Quick Style And Change Shape Formatting Buttons Grayed Out
Oct 17, 2014The Quick Style and Change Shape formatting command buttons greyed out. What setting do I need to change to make them available?
View 3 Replies View RelatedGeneral :: Rightclick Menu In Explorer - Compact Or Decompile Access File
Sep 24, 2012I am looking for a registry setting or .reg file to rightclick on an Access file and in the menu i want to compact or decompile the access file.
I know it is possible but i don't know what's the registry setting.
How To Show A Full Menu On The Menu Bar
Feb 19, 2007Hi 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!
Drop Down Menu Inside Drop Down Menu
May 15, 2006Ok, This is something I have long wanted to do, but cannot figure out.
I am working on a database for a company that orders a large number of Items. I have these all in one table (itemCode, itemDescription, price, categoryCode, etc). I have another table with categorys (categoryCode, categoryDescription) . Each Item is asigned a categoryCode and the appropiate relationship exsists. Right now I have a comboBox in a form that when selected opens a drops down menu with all the Items. Then another one auto loads up (continuous form) and I get the same drop down list of all the Items.
What I would like to have is a combo box then when it is selected shows the categorys, then based on that selection, I see all the Items that are in that category.
I guess another way of saying this simply is, I would like to create a drop down menu inside of a dropdown menu.
Is this possible? Does anyone have another alternative suggestion that might work well? I'm relectant to use a list box, becoase ideally it would be a drop down menu inside of a drop down menu as seen on many websites.
Thanks in Advance!
:)
General :: How To Refresh SubForm
Sep 27, 2013I have created a form and a subform from a table.Initially I created a table with 11 rows. After completion of my project I added an extra of 480 rows to the main table. But the newly added rows are not coming in my subform.
Main : Main table (It consists of around 491 rows)
MForm : Main Form (It shows of only 11 records which I was 1st created)
How to refresh my subform inorder to display all the rows.
General :: Subform Does Not Accept More New Records
May 14, 2013I have a db for my clinic with 3 tables, one is Patient (P_ID, P_Name, P_Age, P_Sex...etc. The second is Referral (R_ID, R_Date, R_Clinic, R_Diagnosis...etc. The third is Therapist (T_ID, T_Name, T_Division, TherapyDate, T_Plan...etc.
The main form contains all patient info and below I have a subform showing info from both other tables (Referral and Therapist).
Each patient could have more than one referral, so I made the relation between Patient table and Referral table, one to many.
Other relations are as follow:
Patient to Therapist (one to many) because one patient could be treated by different therapist each time he is referred.
Therapist to Referral (one to many) because one therapist could handle many referrals.
Now for the first patient, I entered the first patient info in the main form and then the referral and therapist info in the subform, then the same patient was referred to me for the second time, when I attempted to enter the second record (referral) in the subform I am not able to. Why I do not Know, I am sure I did something wrong.
By the way most of the fields in the subform are comboboxes except for dates.
General :: Subform Keypress Of Return
Oct 7, 2013I have a subform when a user presses Return Or Enter it doesnt go to a new record but instead enters a new line in the same records how can i prevent this from happeneing.
View 1 Replies View RelatedGeneral :: More Than Two Criteria To Filter A SubForm
Sep 28, 2012I need to filter a subform based on the values on the mainform.
Criteria are Multiple. The idea is to show the user the records that are already existing in the table.
First two criteria works, stuck with the third one
I.Criteria - Creative(text type)
Private Sub Creative_AfterUpdate()
Me.frmCommercialWithDetails_subform.Form.Filter = _
"Creative ='" & Creative & "'"
Me.frmCommercialWithDetails_subform.Form.FilterOn = True
End Sub
[Code] ....
Also, how to split the code into two lines
"Creative ='" & Creative & "' And Act_ID = " & Act_ID
when broken into:
"Creative ='" & Creative & "' _
And Act_ID = " & Act_ID
is automatically saved as:
"Creative ='" & Creative & "'" _
And Act_ID = " & Act_ID " and this generates an error on execution.
General :: Error Using A Subform To Navigate
Dec 30, 2014Basically what I am doing is duplicating a split form. I am not using a split form because I want to be able to have better control over the bottom half, and I am giving the end user a slightly different view of the same information in the bottom pane.
I've created a form with a subform. When the user moves through the records in the subform, I want the parent form to navigate with it. Note the parent child relationship does not apply here.
I've almost got it working fine, but there is a bug. It seems to originate when the user clicks on the subform ID field while the cursor is the cross, like the Excel fill symbol. Now if the focus is on the subform where ID=2, when the user moves to the parent, the parent navigates away from the record for some reason.
I've noticed that the GotFocus event is firing multiple times, and some of the events are nested. I've tried to set a flag to prevent the nested events from firing, but the bug persists.
General :: Minus One Amount From Another In Subform
Apr 1, 2014I need to minus one amount from another in my subform.
How to do that and which command to use? Sum?
Also should I go to criteria and do it there?
General :: Add Another Parent Name From A Form To A Subform
Jun 27, 2012I added a text box on my main form. I have to other parent names in a subform that I would like to add to my main form. I have this working just using one parent name "dtdrec" that is working. How would I add "flduser" and "fldstuff".
=[tblPayEstimates Subform].[Form]![dtdrec]
General :: Grid Has Disappeared From Subform
Oct 16, 2012I have a orders sub form that was working great .Then all of asudden when i when to input information into the fields i realised the grid under variuos field names has disappered (Icant enter any info),surly this must be something i have accidentally done without realizing.
View 13 Replies View Related