Yes, I saw the Allow Filters and set that to "No", but I was still able to right click and say "Sort ascending/descending". Basically if these subforms had any field filtered or sorted, the entire record would become unlinked with the parent and would be broken. The form was kind of a Frankenstein and it basically has records created from the subform by selecting a tag within it.
Also, warnings were turned on.
jbrumbau
Last Activity: Mar 5 '12, 08:00 PM
Joined: Sep 11 '07
Location: Austin, TX
-
Figured it out (about 10 months later :S ) Apparently if you have Access 2007, customizing right click menus (Shortcut Menu) either involves code, or you have to open it in Access 2003 and customize the menu from there. You can then pick the shortcut menu for Current Database or for Form Properties.
In Access 2003, you go to View, Toolbars, then Customize. Select the Toolbars tab, then create a new menu. Click properties, then from...Leave a comment:
-
Okay I solved it! It wasn't a context tab, it was in the main tabs. Here is my final layout:
...Code:<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="OnRibbonLoad"> <ribbon startFromScratch="false"> <tabs> <tab idMso="TabHomeAccess" getVisible="AdminVisible" /> <tab id="jTabHomeAccess"Leave a comment:
-
Ok so I built this thing up some more, I've disabled design view in the home tab by essentially rebuilding it. It turns out I celebrated a bit too soon. Upon opening a report, I noticed the pesky Excel export button appeared again, this time in a "Print Preview" tab in the "Data" group. I want this group to go away. Here is my current XML code:
...Code:<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
Leave a comment:
-
Aha, I figured it out! Thanks Hennepin for pointing me in the right direction. I found a Microsoft article here and was able to solve it:
http://office.microsoft.com/en-us/ac...010211415.aspx
I created a table with the following items:
Table Name [USysRibbons]
ID - Autonumber
RibbonName - Text, 255 characters
RibbonXml - Memo
For record 1, I entered:...Last edited by jbrumbau; Nov 2 '11, 04:15 PM. Reason: Clarified how to set the new ribbon XML to the current database.Leave a comment:
-
Hennepin,
Thanks for your reply. I don't want to eliminate all ribbons, as nearly everything on the Home tab would be used by database users. Could you please let me know what XML code to use to just include the Home tab?
Searching around the internet some more I found a list of all ribbon commands:
http://www.microsoft.com/download/en...ang=en&id=3582
NeoPa,
If you're...Leave a comment:
-
Also I'd like to add that CommandBars(209 ), the ribbon one, only has 1 control in it, which is also called ribbon. Disabling it likewise had no effect.Leave a comment:
-
Hi NeoPa,
Thanks for your reply. I tested what you said, I did a loop through all CommandBar objects and determined the following ones could be what I'm interested in disabling:
However, upon setting any of the above's Enabled property to...Code:CommandBars(191) '.Name = "Export Pop-Up" CommandBars(192) '.Name = "Import/Link Pop-Up" CommandBars(209) '.Name = "Ribbon"
Leave a comment:
-
Unfortunately, unchecking "Allow Full Menus" is taking away the toggle from form view to datasheet view, which is something all users of our database use regularly. Is there a different solution? Any VBA code I could run that specifically disables the button?
Thanks.Leave a comment:
-
How to Disable or Reroute Export to Excel Button in Ribbon?
Hello,
I had a database user click on the "Export to Excel" button in the ribbon to try and export a report to excel when I already have a button on a report selector that runs VBA code I created to copy data into an excel templated report.
My question is how can I reroute the ribbon button to my code that works correctly? Or if that can't be done, how do I hide the button from all users?
Thanks... -
Narender,
Thanks for your reply. I disabled the option "Allow full menus", and though it did get rid of the design view shortcut, it also got rid of the form view and datasheet view toggling which I would like to keep. I did see there were some dropdowns for [Ribbon Name], [Menu Bar], and [Shortcut Menu Bar] in that same options section, are there things I could type into these boxes to just remove the design view from the view toggler?...Leave a comment:
-
Access 2010 Ribbon - Disable Design View?
Hello,
In Access 2010/2007, how do you prevent users from flipping into design view from the ribbon? I do not want to hide the entire ribbon (DoCmd.ShowToolb ar "Ribbon", acToolbarNo) or even the "View" part of the "Home" tab because users like being able to flip between Form View and Datasheet View in the forms. It turns out that on our network, if a user inadvertantly clicks Design View, then the database... -
Unfortunately I can't reduce the size of these forms any more. It isn't one query that has 25 tables, but each query has several queries nested inside of it, so the total tables referenced could be 10 or so per query. With 3 forms open that means "Invalid Database Object Reference" which is very limiting and annoying. These queries all use type 2 or 3 integer based links to autonumber fields, no string links, so nothing strikes me as unusual...Leave a comment:
-
Form SQL or Query Limit? Error 3276, Invalid database object reference
Hello,
In my database, I'm having an issue where if a user opens too many forms with massive numbers of SQL statements and table references, they'll get error 3276 - Invalid database object reference whenever they try to open another form or if any VBA code executes CurrentDb.OpenR ecordset. This message happens with any table or query that would otherwise open without issues.
Because of the limit, a user can only have... -
Ok so it appears nobody could come up with anything, so I did some experimenting and came up with another solution that avoids .print with boxes that have too much text:
...Code:If rpt.TextWidth(ctl.Value) > ctl.Width Then If IFCChange Then ctl.ForeColor = vbRed ctl.FontBold = True Else ctl.ForeColor = vbBlack ctl.FontBold = False End IfLeave a comment:
-
Thanks for the reply. I omitted a lot of code in my post because it didn't pertain to the issue I was having and I didn't want to overwhelm people with extraneous information (see ... on line 2).
I'm thinking the solution is just 1-3 function calls that need to be added that I don't currently know about. I remember reading somewhere you can set the width of the printed text box, and any text that is printed past the width automatically...Leave a comment:
-
With report .print, how do I set text box width?
Hello all,
I am trying to print values in a report with the following code:
...Code:Dim IFCChange as Boolean, notFormatted as Boolean ... If notFormatted Then rpt.FontName = ctl.FontName rpt.FontSize = ctl.FontSize If IFCChange Then rpt.FontBold = True rpt.ForeColor = vbRed Else rpt.FontBold -
Though VBA code works in form view, it actually doesn't work when you do
Instead, I took the unbound control of interest and referenced my parent control txtSpecCaption by doing:Code:DoCmd.RunCommand acCmdPrint
Default Value = [Parent].[txtSpecCaption]
No code required and it works like a charm.Leave a comment:
-
How to generate a fillable PDF from an Access form?
Hello,
I would really like to know how to create fillable PDF files with an Access form. I know how to print a form and create a static PDF file but would like one that automatically converts blank text boxes into fillable fields.
If it requires 3rd party software that is OK, even if it isn't free, as long as it works.
Thanks in advance. -
I know my question was rather long, but all I'm wanting to know is how to prevent the user from right clicking on a form and sorting or filtering the data in it.
Does anybody know how to do this or can it only be done with a global right click disable?Leave a comment:
No activity results to display
Leave a comment: