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
9,353 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 27
  • 20
  • 9
  • +1
57 Comments
 
LVL 75
ID: 34106607
0
 

Author Comment

by:abcctech
ID: 34111160
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
ID: 34115424
what FInd tab? can you show a pic of it?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 75
ID: 34115640
Find tab >> File tab

mx
0
 
LVL 10

Expert Comment

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

Author Comment

by:abcctech
ID: 34120027
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
ID: 34120265
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
ID: 34120275
***
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
ID: 34120351
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
ID: 34120574
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
ID: 34120947
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
ID: 34121138
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
ID: 34121153
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
ID: 34121178
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
ID: 34121349
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
ID: 34121353
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
ID: 34121386
see my last post. there is no work around.
0
 
LVL 10

Expert Comment

by:conagraman
ID: 34121410
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
ID: 34121655
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 34121715

try this command

docmd.showtoolbar "ribbon",actoolbarno
0
 

Author Comment

by:abcctech
ID: 34121771
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
ID: 34121913
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
ID: 34121949
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
ID: 34121957
thats it.
0
 

Author Comment

by:abcctech
ID: 34122127
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
ID: 34122136
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
ID: 34122170
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
ID: 34122185
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
 

Author Comment

by:abcctech
ID: 34122215
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
ID: 34122377
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
ID: 34122382
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
ID: 34122402
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
ID: 34122427
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
ID: 34122467
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
ID: 34122482
worked on my end
0
 

Author Comment

by:abcctech
ID: 34122524
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
ID: 34122543
so this?
<backstage>
   
   <button idMso="FileNewDatabase" visible="false"/>
   <button idMso="FileOpenDatabase" visible="false"/>
   <button idMso="FileCloseDatabase" visible="false"/>                                                        

  </backstage>
0
 

Author Comment

by:abcctech
ID: 34122617
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
ID: 34122656
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
ID: 34155066
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
ID: 34155133
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
ID: 34157008
"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
ID: 34157147
in summary the only way to hide the file tab is to hide the entire ribbon.
0
 

Author Comment

by:abcctech
ID: 34157186
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
ID: 34157218
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
ID: 34157275
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
ID: 34157354
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
ID: 34157819
Here is a picture...
 With File closedPic2.bmp
0
 
LVL 75
ID: 34158059
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
ID: 34158144
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
ID: 34158234
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
ID: 34158324
I'm not sure about that?!!?   Haven't tried that.  
 I converted my Custom Menus/toolbars to the XML code...
0
 
LVL 75
ID: 34158379
" 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
ID: 34158385
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
ID: 34158514
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
ID: 34158684
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
ID: 34289892
I didn't realize I had to run the program from scratch to see that the  <backstage> code I had worked....
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Omit After Update event 5 46
Menus 6 57
Intermittent OleDbConnection Error 20 53
Reoccurring Access Query 24 47
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of utilizing SQL Server functions 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 Ac…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

751 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