Solved

Microsoft Access 2010:   How to Hide File tab and also Hide Min Ribbon Bar, Access Help, Min, Restore, Close on the right/top of screen

Posted on 2010-11-10
57
8,982 Views
Last Modified: 2012-05-10
Help!  I’m new to Access 2010 and trying to create Ribbon Bars…
I can’t seem to “hide” the File portion of the Ribbon bar.  When I create the ribbon bar and put it on a form I still see the File tab and Save, Save Object As, Save Db As, Open, Close db, List of recent db’s opened, Info, Recent, New, Print, Save & Publish, Help, Options, Exit
On my Main Menu form I Hide the Navigation Pane on the Open Method:
  DoCmd.SelectObject acTable, "ProjectInfo", True
 If Application.CurrentObjectName = "ProjectInfo" Then DoCmd.RunCommand acCmdWindowHide

 I’ve created a table called: USysRibbons
  -contains the ribbon bars I created
 On the forms I put in the Ribbon Name from the USysRibbons table  
 
Here is an example of my ribbon bar:

  <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
  <ribbon startFromScratch="true">
 <qat>
     <sharedControls>
     </sharedControls>    
       <documentControls>                    
       </documentControls>
     </qat>
    <tabs>  
      <tab id="dbCustomTabFile" label="File" visible="true">
         <group id="dbCustomGroupFile" label="File Group">                  
            <control idMso="MasterViewClose" label="Close Screen" enabled="true"/>              
         </group>
     </tab>
        <tab id="dbCustomTabEdit" label="Edit" visible="true">
          <group id="dbCustomGroupEdit" label="Edit Group">                  
            <control idMso="Undo" label="Undo" enabled="true"/>
            <control idMso="Cut" label="Cut" enabled="true"/>
            <control idMso="Copy" label="Copy" enabled="true"/>
            <control idMso="Paste" label="Paste" enabled="true"/>        
          </group>
      </tab>
         <tab id="dbCustomTabPrint" label="Print" visible="true">      
         <group id="dbCustomGroupPrint" label="Print Group">                  
             <control idMso="FilePrintQuick" label="Quick Print" enabled="true"/>
             <control idMso="FilePrintMenu" label="FilePrintMenu" enabled="true"/>  
             <control idMso="PrintPreviewClose" label="Close Print Preview" enabled="true"/>              
        </group>
  </tab>
      <tab id="dbCustomTabHelp" label="Help" visible="true">      
         <group id="dbCustomGroupHelp" label="Help Group">  
            <control idMso="SpellingAccess" label="Spelling" enabled="true"/>    
            <button id = "OpenForm" imageMso ="Help" label = "Data Entry Help" onAction = "OnButtonPress"  tag="Help"/>              
            <control idMso="ViewsDesignView" label="ABCC Only (D)" enabled="true"/>
            <control idMso="ViewsLayoutView" label="ABCC Only (L)" enabled="true"/>
      </group>
      </tab>
    </tabs>
  </ribbon>
 <backstage>
     <button idMso="FileCloseDatabase" visible="false"/>
     <button idMso="SaveObjectAs" visible="false"/>
     <button idMso="FileSaveAsCurrentFileFormat" visible="false"/>
     <button idMso="FileOpen" visible="false"/>
     <button idMso="FileSave" visible="false"/>
     <tab idMso="TabInfo" visible="false"/>
     <tab idMso="TabRecent" visible="false"/>
     <tab idMso="TabNew" visible="false"/>
     <tab idMso="TabPrint" visible="true"/>
     <tab idMso="TabShare" visible="false"/>
     <tab idMso="TabHelp" visible="false"/>
     <button idMso="ApplicationOptionsDialog" visible="false"/>
     <button idMso="FileExit" visible="false"/>    
  </backstage>
</customUI>


I thought the <backstage> portion would ‘hide’ the File tab…  But it’s still there.

Also how do you hide the functions on the right side of the screen (Min Ribbon Bar, Access Help, Min, Restore, Close)

Thanks in advance for any suggestions

Thanks,
   Donna
0
Comment
Question by:abcctech
  • 27
  • 20
  • 9
  • +1
57 Comments
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
0
 

Author Comment

by:abcctech
Comment Utility
Hi mx,
I agree with you we absolutely need to find a way to hide that "FIND" tab...
When I put in  DoCmd.ShowToolBar "ribbon", acToolBarNo.  I no longer see my customized ribbon...
I need to have that ribbon on the screen...

Why doesn't the <backstage> thing work?  Does anyone know?

This is insane....  I have 22 db's that have to be converted to Access 2010!


0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
what FInd tab? can you show a pic of it?
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
Find tab >> File tab

mx
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
try this
access options>>current database>> document window options
select document "tabbed Documents"
uncheck "display Document tabs"
ee2.bmp
0
 

Author Comment

by:abcctech
Comment Utility
Sorry I meant File Tab..
See the  2 File tabs below...  The First one is the one that has to be hidden and I can't find how to hide it.

File1.png
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
here try the below code.
* note that all of the things you can make not visible are done with <ribbon startFromScratch="true">  * with the exception of the help button.
so your "backstage" section is unnecessary.

i am using 07 so i cant test the below code  i changed the schema/ the first line. change it back to
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">

'---------------code

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">

  <commands>
  <command idMso="Help"  enabled="false"/>
  </commands>
<ribbon startFromScratch="true">
<tabs>  
      <tab id="dbCustomTabFile" label="File" visible="true">
         <group id="dbCustomGroupFile" label="File Group">                  
            <control idMso="MasterViewClose" label="Close Screen" enabled="true"/>              
         </group>
     </tab>
        <tab id="dbCustomTabEdit" label="Edit" visible="true">
          <group id="dbCustomGroupEdit" label="Edit Group">                  
            <control idMso="Undo" label="Undo" enabled="true"/>
            <control idMso="Cut" label="Cut" enabled="true"/>
            <control idMso="Copy" label="Copy" enabled="true"/>
            <control idMso="Paste" label="Paste" enabled="true"/>        
          </group>
      </tab>
         <tab id="dbCustomTabPrint" label="Print" visible="true">      
         <group id="dbCustomGroupPrint" label="Print Group">                  
             <control idMso="FilePrintQuick" label="Quick Print" enabled="true"/>
             <control idMso="FilePrintMenu" label="FilePrintMenu" enabled="true"/>  
             <control idMso="PrintPreviewClose" label="Close Print Preview" enabled="true"/>              
        </group>
  </tab>
      <tab id="dbCustomTabHelp" label="Help" visible="true">      
         <group id="dbCustomGroupHelp" label="Help Group">  
            <control idMso="SpellingAccess" label="Spelling" enabled="true"/>    
            <button id = "OpenForm" imageMso ="Help" label = "Data Entry Help" onAction = "OnButtonPress"  tag="Help"/>              
            <control idMso="ViewsDesignView" label="ABCC Only (D)" enabled="true"/>
            <control idMso="ViewsLayoutView" label="ABCC Only (L)" enabled="true"/>
      </group>
      </tab>
    </tabs>


</ribbon>
</customUI>
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
***
i am using 07 so i cant test the below code  i changed the schema/ the first line. change it back to
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">

change it back if you recieve an error**

0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
here is a good link to check out on ribbons that i came accross

http://msdn.microsoft.com/en-us/library/dd909370(v=office.12).aspx
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
this looks like the link where the answer would be if there is one

http://msdn.microsoft.com/en-us/office/aa905530.aspx
0
 

Author Comment

by:abcctech
Comment Utility
Hi Conagraman,
 I tried your code and still see the whole microsoft File tab (as is was before).  I was so hoping this would work.  Does it work in Access 07?  Do you think they totally changed it in Access 2010?  Is that why it's not working??
 I'm checking out those 2 links you sent.  So far, I haven't see anything that would help but I'll keep looking in there.
 The "Backstage" stuff I see all over (like in my original code) just doesn't work...
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
just to be sure: you do know your asking for a file tab?

<tab id="dbCustomTabFile" label="File" visible="true">
         <group id="dbCustomGroupFile" label="File Group">                  
            <control idMso="MasterViewClose" label="Close Screen" enabled="true"/>              
         </group>
     </tab>
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
i cant help you with the backstage stuff. its only in 2010. here is a link for it

http://msdn.microsoft.com/en-us/office/ff808348.aspx
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
i dont see the file tab. if the code dosent help i'd wonder if you can get rid of it.

in 07 i cant get rid of the "microsoft button" i wonder if they changed it to the "file" button.
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
ya thats exactly what it looks like. they replaced the "office" button with a file tab. i have tried everything to hide that. ur prob sol.
0
 

Author Comment

by:abcctech
Comment Utility
What is in the Microsoft Button?   Does it have:  Save, Save Object As, Save Db As, Open, Close db, List of recent db’s opened, Info, Recent, New, Print, Save & Publish, Help, Options, Exit?  That is what is in the File Tab now...
The Code: <tab id="dbCustomTabFile" label="File" visible="true">   is to show "My" version of the file tab I want my users to see.
The Backstage stuff (from what I am reading..) is to manipulate the "File Tab" stuff.
<backstage>
     <button idMso="FileCloseDatabase" visible="false"/>
     <button idMso="SaveObjectAs" visible="false"/>
I'm trying to make them "Not visible"...  Well at least I'm trying and it's not working...
How do you work around the Microsoft Button?  


0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
see my last post. there is no work around.
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
what i can do is hide almost all of the options that appear. sounds like the same thing as the backstage. so there is almost nothing on the menu except a close button
0
 

Author Comment

by:abcctech
Comment Utility
Yes, that is what I am trying to do with the backstage thing...  But it's just not working.  
Do you have the code that hides all but the close button?  

This shouldn't be that hard should it?  Why do they do this to us?  You would think that would be an option because that file tab is so powerful and the user can ruin your database that you just wrote!
There should be an option to just turn it off!
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility

try this command

docmd.showtoolbar "ribbon",actoolbarno
0
 

Author Comment

by:abcctech
Comment Utility
Hi Capricon1,
 if I use: DoCmd.ShowToolbar "Ribbon", acToolbarNo then I don't see the File tab (which is what I want) but I do not see my customized ribbons either.
This is driving me insane...  
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
ok
place this code in between  <ribbon startFromScratch="true"> and <tabs>
 in your xml so for example <ribbon startFromScratch="true"> the below code goes here----<tabs>

 <officeMenu>
   
   <control idMso="FileNewDatabase" visible="false"/>
   <control idMso="SourceControlCreateDatabaseFromProject" visible="false"/>
   <control idMso="FileOpenDatabase" visible="false"/>
   <control idMso="FileSave" visible="false"/>
   <control idMso="ConvertDatabaseFormat" visible="false"/>
   <control idMso="FileSaveAsMenuAccess" visible="false"/>
   <control idMso="FileManageMenu" visible="false"/>
   <control idMso="FileSendAsAttachment" visible="false"/>
   <control idMso="MenuPublish" visible="false"/>
   <control idMso="FileServerMenu" visible="false"/>
   <control idMso="FileCloseDatabase" visible="false"/>                                                        

  </officeMenu>
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
i dont have 2010 so you will have to work off of what i have here and hope there is something like it.

in 2007 i would uncheck the "allow full menus" in my ribbon options. see the below pic. again this is 07 non 2010 so it might look a bit different.


eerib.bmp
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
thats it.
0
 

Author Comment

by:abcctech
Comment Utility
Hi Conagraman,
  Access 2010 options looks just like that.  I already had "Allow Full Menus" unchecked...
 Still see the File tab. Options
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
you will see the file tab no matter what you try. what i am saying is you can hide all the options it would bring up.
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
this means i went from the normal menu to just recent documents and a close button. its not ideal but the best i think you can get.
eemenu.bmp
0
 

Author Comment

by:abcctech
Comment Utility
Yes, I understand that now...  I will still see "File" but nothing should be in there.  Right?  Unfortunately, I still see the file tab and all of it's contents...
 with this code:
 <backstage>
     <button idMso="FileCloseDatabase" visible="false"/>
     <button idMso="SaveObjectAs" visible="false"/>
     <button idMso="FileSaveAsCurrentFileFormat" visible="false"/>
     <button idMso="FileOpen" visible="false"/>
      .......
0
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

Author Comment

by:abcctech
Comment Utility
Oh I wish I could just do what you have up there!!!
   That has to be doable in 2010!   Doesn't anyone else use 2010 out there?
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
you could try

<backstage>
   
   <button idMso="FileNewDatabase" visible="false"/>
   <button idMso="SourceControlCreateDatabaseFromProject" visible="false"/>
   <button idMso="FileOpenDatabase" visible="false"/>
   <button idMso="FileSave" visible="false"/>
   <button idMso="ConvertDatabaseFormat" visible="false"/>
   <button idMso="FileSaveAsMenuAccess" visible="false"/>
   <button idMso="FileManageMenu" visible="false"/>
   <button idMso="FileSendAsAttachment" visible="false"/>
   <button idMso="MenuPublish" visible="false"/>
   <button idMso="FileServerMenu" visible="false"/>
   <button idMso="FileCloseDatabase" visible="false"/>                                                        

  </backstage>
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
or maybe

<backstage>
   
   <control idMso="FileNewDatabase" visible="false"/>
   <control idMso="SourceControlCreateDatabaseFromProject" visible="false"/>
   <control idMso="FileOpenDatabase" visible="false"/>
   <control idMso="FileSave" visible="false"/>
   <control idMso="ConvertDatabaseFormat" visible="false"/>
   <control idMso="FileSaveAsMenuAccess" visible="false"/>
   <control idMso="FileManageMenu" visible="false"/>
   <control idMso="FileSendAsAttachment" visible="false"/>
   <control idMso="MenuPublish" visible="false"/>
   <control idMso="FileServerMenu" visible="false"/>
   <control idMso="FileCloseDatabase" visible="false"/>                                                        

  </backstage>
0
 

Author Comment

by:abcctech
Comment Utility
I tried that.  Got errors on these lines:  SourceControl CreateDatabaseFromProject, ConvertDatabaseFormat, MenuPublish..  I think those names have changed in 2010.
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
get rid of thoes two lines. are the others gone?
which one are you using   <control idMso or <button idMso?
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
when i get rid of the code i only have a few options new open and close database. so maybe some of that code is not needed anyway.

try just using

   FileNewDatabase" FileOpenDatabase" FileCloseDatabase"                                                        

0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
worked on my end
0
 

Author Comment

by:abcctech
Comment Utility
Tried:
   <control idMso="FileNewDatabase" visible="false"/>  
   <control idMso="FileOpenDatabase" visible="false"/>  
   <control idMso="FileCloseDatabase" visible="false"/>      
 I think is doesn't like Control idMso.  I get an error on each of these lines...
  No error on  <button idMso="FileCloseDatabase" visible="false"/>
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
so this?
<backstage>
   
   <button idMso="FileNewDatabase" visible="false"/>
   <button idMso="FileOpenDatabase" visible="false"/>
   <button idMso="FileCloseDatabase" visible="false"/>                                                        

  </backstage>
0
 

Author Comment

by:abcctech
Comment Utility
The only backstage command I have in there is : <button idMso="FileCloseDatabase" visible="false"/>

When I click on the File tab I still see "Close Database."  along with all of the other stuff.

Here it is:
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
  <ribbon startFromScratch="true">
    <tabs>  
     <tab id="MyTab1" label="My Tab 1">
      </tab>
    </tabs>
  </ribbon>
 <backstage>
     <button idMso="FileCloseDatabase" visible="false"/>  
  </backstage>
</customUI>
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
looks like you might have already had it. i just didnt realize you did.

<backstage>
<button idMso="FileSave" visible="false"/>
        <button idMso="FileSaveAs" visible="false"/>
        <button idMso="FileOpen" visible="false"/>
        <button idMso="FileClose" visible="false"/>
        <button idMso="ApplicationOptionsDialog" visible="false"/>
        <button idMso="FileExit" visible="false"/>
        <tab idMso="TabInfo" visible="false"/>
        <tab idMso="TabRecent" visible="false"/>
        <tab idMso="TabNew" visible="false"/>
        <tab idMso="TabPrint" visible="false"/>
        <tab idMso="TabShare" visible="false"/>
        <tab idMso="TabHelp" visible="false"/>
</backstage>
0
 

Accepted Solution

by:
abcctech earned 0 total points
Comment Utility
Hi,
 I figured it out.  The <backstage> does work if you open the program from scratch...  If you are in the program and view the screens the <backstage> doesn't work!  In other words when I don't open the db in design view the <backstage> works!   Does that make sense?

I want to thank those who tried to help!

Thanks again,
  Donna
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
yes that does make sense. a custom xml ribbon in my environment doesn’t appear until runtime. glad you figured it out! also thanks for posting what you found out as i am sure i will be switching to 2010 soon.

: )
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
"Donna'
fyi only ... your EE icon shows a male :-)

So, in summary ... which post Hides the File tab ... while retaining any custom menus from A2003 on the Add-In ribbon ...?

mx
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
in summary the only way to hide the file tab is to hide the entire ribbon.
0
 

Author Comment

by:abcctech
Comment Utility
Hi DatabaseMX,
  This is what hides the file tab:
 <backstage>
<button idMso="FileSave" visible="false"/>
        <button idMso="FileSaveAs" visible="false"/>
        <button idMso="FileOpen" visible="false"/>
        <button idMso="FileClose" visible="false"/>
        <button idMso="ApplicationOptionsDialog" visible="false"/>
        <button idMso="FileExit" visible="false"/>
        <tab idMso="TabInfo" visible="false"/>
        <tab idMso="TabRecent" visible="false"/>
        <tab idMso="TabNew" visible="false"/>
        <tab idMso="TabPrint" visible="false"/>
        <tab idMso="TabShare" visible="false"/>
        <tab idMso="TabHelp" visible="false"/>
</backstage>
 also added code to hide the "Recent db"
  see this:
    http://www.accessribbon.de/en/index.php?FAQ:FAQ_Access_2010:2

Thanks for the EE icon tip!
 Donna

0
 

Author Comment

by:abcctech
Comment Utility
conagraman is correct.  
 What the code does is hide what is in the File tab.   But you still see the  "FIle" tab.
   I put a Close Program button on that tab...  So, that is all you see in there!

  Hope that clears things up!
 
  Donna
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
Would you be able to post a screen shot of the 'ribbon' are (top of app) that shows the end result?

thx.mx
0
 
LVL 10

Expert Comment

by:conagraman
Comment Utility
i can’t show you 2010 but see my post 34122170 to see 2007. I’m sure the result is similar.
0
 

Author Comment

by:abcctech
Comment Utility
Here is a picture...
 With File closedPic2.bmp
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
So, I'm slightly confused.  The File tab is still there?  And if you click it, does all of the stuff underneath appear ?

And you created the Close and Help items ?

mx
0
 

Author Comment

by:abcctech
Comment Utility
Yes, the file tab is still there..  If you click on it the only thing you see is the "Return to Main Menu" button.  Yes, I  created the Close and Help tabs. They have things that are needed for this specific program.  
The file tab is the system generated one that you can't hide without totally hiding all Ribbon Bars.
So, the solutions is to hide all of the contents in the File tab (hide the Save db, Options, Print, Recent db, etc...)  I put the "Return to Main Menu" button in the File Tab.  So what ever screen they are in at the time they can click on the "FIle" tab and  then click on "Return to Main Menu" button to get back to the Main Menu Screen of the program.
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
I see. So, I'm wondering if ... I had an A2003 custom menu, that would appear on the Add-In Ribbon ... if I 'hide' the File tab in this context, will I see the File tab + my custom menu (via the Add-In ribbon) ... say in place of your Close & Help items ..?

Also, did you use the     http://www.accessribbon.de/en/  tool to create all of this ?

thx.mx

0
 

Author Comment

by:abcctech
Comment Utility
I'm not sure about that?!!?   Haven't tried that.  
 I converted my Custom Menus/toolbars to the XML code...
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
" I converted my Custom Menus/toolbars to the XML code..."
Meaning you recreated them in XML ... or used some conversion tool?
The reason I'm asking these questions is I will be doing this shortly on many mdb's here at work.  I just got an A2010 workstation set up yesterday ... to start testing A2003 apps on.  Not converting to ACCDB, but they need to run in the A2010 environment.

mx
0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
btw ... close the Q anytime you like ... no pts for me, these are just academic questions ... lingering on lol.

mx
0
 

Author Comment

by:abcctech
Comment Utility
No, I didn't use a conversion tool.  Found stuff on the internet to help me create the code.
This is a good site to use:
Access Ribbon Website  called Avenius Gunter
<http://www.accessribbon.de/en/index.php?Welcome>
We are moving to Office 2010 and I have many db's to convert.  I'm converting to ACCDB.  Why are you staying with the mdb format?  

0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
Not converting at this time because O2010 deployment to all work stations will not be simultaneous ... and not starting until Dec or Jan.  So, the apps will have to work in both environments for a period of time. Down the road next year, I will mostly likely convert ... once everything is 'stable'.

mx
0
 

Author Closing Comment

by:abcctech
Comment Utility
I didn't realize I had to run the program from scratch to see that the  <backstage> code I had worked....
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now