Tool Menu Deactivate
Sep 27, 2005I can't use the menu TOOLS because it is deactivate for all mdb.
Is it deactivated from portion of VBA code?
How Can I restore this menu?
By Francy
ADVERTISEMENT
Custom Tool/Menu Bar Added
May 25, 2005Hey..
I'm having a rather strange problem that no one can fix, apparently. My teacher is even baffled :S.
Basically, I created a custom menu bar, took off some of the defaults, but now I am having a problem. I deleted the original custom menu bar and now I am posed with the following error when my database is loaded (I am using an autoexec script that opens the switchboard).
Can anyone shed any light on this? Thanks a lot, again, guys :).
Turn Menu/tool Bars On & Off
Jul 15, 2005What is the best way to turn all the menu bars and tools bars off and back on when a form opens and closes? Can you just loop through the numerated objects?
View 14 Replies View RelatedDisable Tool-Bar Menu - 'Delete Record'
Apr 20, 2006Hello Everyone,
Before I pose my question I would first like to applaud and thank this forum for the excellent and timely help it has provided me so far. The assistance I have received to date, from you as members, and via the search facility has been extremely helpful particularly as I am new to this type of stuff…
My question is this...
I would like to disable users from selecting the 'Edit - Delete Record' facility from my main form upon its load. From searching the various forums I found a method upon which to disable the whole 'Edit' menu but not the specific 'Delete Record' function. Please accept my sincere apologies if this has already been posted but I simply cannot find it readily via a standard/refined 'search'. It might be the fact that I am phrasing the question incorrectly?? I don't want to severely restrict my users by disabling/hiding the whole menu but would rather limit them to accessing this option via a password protected command button?
What I have found so far.
Private Sub Form_Load()
CommandBars("Menu Bar").Controls("Edit").Visible = False
End Sub
Any assistance/guidance would be very much appreciated
Kind Regards – Best wishes to all of the registered site members
CarolW
:)
Modules & VBA :: Custom Tool Bar / Menu Handling In 2010?
Jun 23, 2014I 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.
Tool Bars / Menu Bars - GONE
Apr 20, 2006Help! I'm not sure how I did this, but NO matter what database I go into i can see any toolbar or menu bar. Yes I tried the shift key. How do I turn it all back on?
When I right click I can get the database startup properties, everything has the check, yet I can't see any toolbars or menu bars. I've searched though the help, and I can't see to find out how to put it back.
Deactivate Notification
Mar 20, 2008Dear all,
I create a make table query.
But every time I run the query, the notification will prompt out "are you sure....".
Is there any way to disable this notification?
Tq.
How To Deactivate Report View
Nov 28, 2004I am creating a report from a form. The focus jumps to the report but I want it to stay on the form. I have a macro that creates the report. How can I keep the focus on the form?
View 2 Replies View RelatedForms :: Deactivate Page Down Key?
May 22, 2013I'm trying to deactivate the page down key in my form with no luck. How to deactivate the page down key. Here's the steps I have already completed.
I opened the form in design view, set KeyPreview Property to Yes, selected Database Tools, Visual Basic and inserted code in lines 3 through 9 after the dash / line.
Update_Total
'
'------------------------------------------------------------
Function Update_Total()
On Error GoTo Update_Total_Err
Private Sub form_keydown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
Case vbKeyPageDown
[code]....
Close Current Form On Deactivate?
Jun 24, 2005Hey,
Can someone pls tell me how to close a form as soon as it gets deactivate? Becouse i try with Docmd.Close but it tells me that i can not do that in this event, but thats exactly what i would like to do - close form when it gets deactivated?
Thx
Deactivate Mouse Second Button Click On F
Mar 16, 2006How can i deactivate mouse second button click on form?
Can anyone help me please?:)
Forms :: Activate / Deactivate Field
Feb 25, 2014I have a sub form that hase multiple records. What I would like to do is if my catagory field = "(1) Constrution" the deactivate 'DC to Apply', got that to work BUT it does it for all of the record..Notice in the pic that the first record = "(1) Constrution" and id deactivates ALL of the "DC to Apply"
Here is my code
Private Sub Category_AfterUpdate()
If Me.Catagory = "(1) Construction" Then
Me.DC_to_Apply.Enabled = False
Else
[code]....
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!
SQL Conversion Tool
Jan 3, 2006Does anyone have a Jet to ANSI SQL conversion tool they could either send me or recommend:confused:
View 2 Replies View RelatedCount Tool
Apr 18, 2008I want to know how to count the number of records come up for a query
but it keeps coming up like this:
http://img156.imageshack.us/img156/5150/88274572ke4.jpg
This is how i have it now:
http://img245.imageshack.us/img245/5117/98426599lq9.jpg
Tool Tip Or Message Box?
Apr 20, 2005I have a form with a check box control on it and a pick list text box.
What I looking for is when the user checks the check box, I want to display a message or tool tip to inform the user to ensure that the correct membeship type has been selected from the pick list, (this has a default setting) so can accept the default in this field.
I am trying to aviod the user having to press a button on a message box to continue. it would be useful if it could be display for a preiod of time.
regards
Search Tool Help
May 14, 2006Hi all,
I found this search tool example on this forum which works for my situation. Can someone tell me what changes I need to make so it works with my date field. When I search for data based on Last Name, First Name, or Account # the records appear fine, but when I click on one of the records I get this error message. " Could not locate [8/1/2005]". I would actually like to be able to search by the date field also. Can someone help me modify the database to accomplish this task. Thanks in advance.
Check Box Tool For Forms
Apr 20, 2006please see attachment.
I created a small database to help explain my issue.
When I click on the check box in box 1(train), the text box turns blue...great...and even better the other records stay clear when I scroll down, which is what I want to happen.
But when I scroll back up, from dog to train, the blue in the train box has gone- not what I want!
I would like the blue to stay in every box that I click on. Any ideas?
Thanks,
J
How To Make Your Own Custom Tool Bar
Aug 30, 2005If I wanted to build a database in Access can I make my own file bar. Let's say that I wanted to build a gun inventory but wanted the tool bar at the top to have the specific files I want people to click on. How is this done? Is it done with another program used as a developer with Access database? Hope this makes sense.
View 6 Replies View RelatedAccess Main Tool Bar Help
Aug 2, 2006I have a database which I can not get to the normal tool bar to change the permissions on.
The startup was set to not display this. I need to modify the security on a form.
Help please.
Thanks
Access Lookup Tool
Oct 31, 2006Hey there,
I am wondering if there is somekind of tool that can be used in access that can run and locate any queries that are redundant and not used within a system. Also if there is any kind of tool that can be run that identifies fields that are in tables that are also not used in the application!
Not sure if such software exists but thought id ask before i manually begin to go through the application, this is all done to be done before normalisation of the application data and upgrade of the system
Thanks in advance
Jas
Linked Tables - Looking For Tool
Feb 21, 2008We have a nasty number of access databases spread around our network and linked to each other like a giant spiderweb.
I can easily open an database and using linked table manager find out what is attached and from where.
I need some sort of tool that will tell me where a table is linked to.
IE - you have a master database that holds the data. You have several other databases that are linked to the master data and run queries, reports etc. I need to find out where the master data is used.
Any ideas?
Cool Search Tool Help
Jan 4, 2007Hi All,
Would anyone be willing to somewhat guide me through the cool search tool because coding isn't my speciality.
Thank you in advance.
Josh
Reporting Tool Selection
Nov 19, 2004Hi all,
I want to display data from a database I have in MS Access. Any ideas on what sort of tool I can use to display the data locally? Can I get a free VB dev tool anywhere?
Access's reports and data access pages just aren't flexible enough for me. I know ASP and SQL well, but I don't want this database to be stored on our server.
Thanks for any feedback.
Exporting Custom Tool Bar
Nov 11, 2007How do I export a custom tool bar to another DB??
Any ideas are appreciated.
Can't Click On Option In Tool Bar
Jun 6, 2014I was trying to convert macros but can't click on the option in the tool bar. It's inactive and greyed out. How do you activate this to click on it?
View 8 Replies View Related