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: 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.
Question: I have a long document and on the last page I have a table which has some numbers appearing at the margin which I cannot remove. Can you help?
Answer: This one I have never seen before, but since they could not be deleted and were not bulleted numbers, the only thing I could think was of Line Numbering. Even though there was no line numbering on the rest of the document, I went into the Paragraph options for that line (slanted arrow in the Paragraph group on the Home tab). I clicked on the Line and Page Breaks tab and checked “suppress line numbers,” and the number on that line disappeared. I tried this for the other two places the line numbers appeared, and either checked (and in one case had to uncheck) the option and the line numbers finally disappeared. Very strange indeed!