Question: I added a field to my Access table but when I tried to modify a query and add that new field, it didn’t appear? What is happening?
Answer: If your query came from a table, then you should be able to add the field. If the query was actually created from another query, then that could be why the field doesn’t appear on the list. In looking at the query, it was coming from a query by the same name as the table. When we started a brand new query, the new field appeared on the field list.
Question: I am using Access 2010 and am adding criteria to a query. Every time I enter F or M for the Gender field up pops autocorrect function commands and if I press enter it replaces the F or M with a function, which I don’t want! I have found I can press the space bar after and it will keep the F. This happens all the time for other fields too, and I want to turn it off!
Answer: In checking online discussion groups, it appears this is a new “feature” of Access 2010, and there is no way to disable it. One person suggested placing quotes around the entry, but instead of typing 1 letter, you end up typing 3. Maybe if many people continue to complain about this “feature” Microsoft will make a way to disable it. If anyone learns of a way to disable it, please let me know!
Question: I have a table covering two pages which will be printed front and back. The outside border of the table needs to line up on both sides. I have the tables the same size and the same margins and have tried to move them around so they line up, but they are always off about 1/4 inch. Can you help?
Answer: If you select the table and go into the table properties from the Table Tools Layout tab in the ribbon, click Center align. The table should now be centered on both pages. If you have more than one table, you would need to Center align each one.
Question: My off campus email has changed its look. It is now blue instead of yellow and I can’t see the folders in my in box. Is there something I can do to get the old look and feel back?
Answer: I couldn’t come up with an answer right away for this one, so checked with our helpdesk who suggested she was probably using the “light” version of Outlook web access. She probably logged in using the “blind and low vision experience”, which is also called the “light version” of Outlook web access. You can turn this on or off by selecting the checkmark box on the login screen.
On the secure remote access site, this option directly on the logon screen is not available. To turn it off:
- Log into the secure remote access UNMC email site.
- Click on “options” in the top right corner.
- Click “see all options…” from the drop down menu.
- Select “settings” on the left hand side menu.
- Click “general” from the menu bar towards the top.
- Deselect “Use the blind and low vision experience.”
- Finally, click “Save” in the bottom right corner, to save the changes.
Question: When I logged on to Email this morning I found that the home menu was missing. I click on Home and the menu bar reappears, but the minute I do anything else it disappears. Is there something that I did to change the interface behavior? I prefer to seen the menu/icon bars visible at all times.
Answer: More than likely you may have double clicked on a ribbon tab, which “hides” the icons to allow for more space. Just double click on the ribbon tab again, and the icons will re-appear permanently. If you are using Office 2013, you may have inadvertently clicked on the collapse button ^ on the upper right side of the screen (even with the ribbon) that collapses the ribbon. To make it reappear, you can use icon on the upper right of the window next to the minimize _ button to autohide the ribbon, show tabs or show tabs and commands.
Question: I am trying to share my calendar with someone but am getting an error message that says, “Policy does not allow granting permissions at this level to one or more of the recipients. Please select another permission level and send the sharing invite again.” I am using the Share option from the ribbon.
Answer: I normally use the permissions to set up a calendar for use by another, but I tested this out with my calendar and it worked fine. But then I tried it by selecting a name that popped up from my suggested (or recent) contacts. When I tried sharing this way, I got a different type of error message. So I suggested that she try using the Address book to select the name and by golly, that did the trick! So when getting unusual error messages after selecting a name from the popup/suggested names, try selecting from the address book instead. I have noticed similar problems occasionally when sending emails to several people and selecting the suggested names.