Search results for query: *

My primary email account stopped working two months ago on Outlook 365, and after many vain attempts to fix it I rather hastily deleted and recreated the account. This fixed my email problem perfectly. However, I did not realize all my contacts and calendar entries would disappear. Is there...

I found code for a function that will alphabetize the characters in a string. If A2 is "TACO" then Sortletters(A2) returns "ACOT." What I'd like the result to look like is "A C O T" with a space in between the characters. A leading space before the first character is okay - I'm just looking...

Windows 7 home premium I access a free AOL email account via Chrome. Until recently when I received an email attachment I would click on the attachment and it would download and show as a button at the bottom of the page. I would click on the button and the file, usually a .pdf, would open...

Is there a function or addin for Excel (2013) that returns a unique number for each month, similar to how days are counted from 1/1/1900? I don't mean the Month function that returns "6" for June no mater what year it is. I need every month to have a unique, consecutive number. For example...

Using Office 365. This is basically a commission scenario. I have a Sales Table with: SaleIDAgentIDProductPrice and a Commission Splits Table: SplitIDSaleIDAgentIDSplit% I can populate the Sales table without problem The issue is populating the Splits Table. Depending on WHO made the...

Using Win 7 & Excel 2013 I'm totally new to VBA code, but I need some kind of code/macro/magic that will delete rows in Excel. Each month I import a financial statement with about 500 rows and I need to delete all but 350 of those rows. The rows I want to keep have an account number in Column...

I need to create reports that are heavy on text and light on data fields. Essentially these are contracts or agreements with several paragraphs and then a few name, address and dollar amount fields. Is it better to store the text in the report itself or import memo fields that contain the...

MS Office 2007 Professional. I have a set of linked Excel workbooks: Payroll, Commissions and Payables. The Payables workbook is linked to the other two and updates automatically. The client looks at this frequently to see how much cash he can take out of the business. I am building an...

Access 2007 I have a report with a subreport for payroll purposes. Each is based on a query and each query prompts for PAY DATE and for PAYEE. To run the report, I have to enter each parameter twice - once for the main report and once for the subreport. Is there a technique that would allow...

I have a form with an agent field that is connected to an Agent Table via a lookup. I type "S" and it brings up Smith, "W" brings up Williams, etc. It is a terrific time saver, in my opinion. But it also seems like I've seen some of you pros argue against lookups and even referred to a...

I have a form field that is a percent. When I format as a Percent it allows whole numbers to be entered and still displays them as percentages (e.g., entering "25" results in "25%" rather than 2500). However, when the value is zero I do not want to see "0". I would prefer to see see a hyphen...

Office 2007; Windows 7 I have what should be a simple task that is driving me crazy. In Access I have one table linked to an Excel table. I have one query based on that table and one report based on that query. The report fields: Name (last, first mi concatenated from three fields)...

Excel 2007; Windows 7 I searched for this and the answers seemed to apply to Excel 2003, so here goes again. I have a spreadsheet that tracks payables by week. The absolute easiest way for me to indicate that an item (there are perhaps 50 per week) has been paid is to change the text or fill...

Excel 2007 I have a worksheet from which I derive five different pivot tables. The worksheet has data added a row at a time at irregular intervals, but each time data is added I have to change the data source five times for the pivot tables. Is there a way to set this up so that I can change...

Using HP box with Windows XP Media Edition, SP 3, 1GB memory: Twice in the last week the PC has locked up so completely I could not even bring up the task manager to end programs. I used the on/off "eight-count" to turn off the computer. Upon restart, things seem normal. Each time it happened...

A friend has an old PC that was shipped with MS Word, but she was never given the actual installation disk. She's buying a new PC and would like to keep using this version of MS Word on the new machine. I feel like she already has the license and should be able to continue using it. Any...

Disclaimer: This is a repost - no responses in MS Office forum - wrong forum perhaps Outlook 2007. When I try to backup Outlook, I get the following error: "Cannot copy Outlook: The process cannot access the file because another process has locked a portion of the file." Even when I close...

Outlook 2007. When I try to backup Outlook, I get the following error: "Cannot copy Outlook: The process cannot access the file because another process has locked a portion of the file." Even when I close everything else I get the error. If it matters, I downloaded some fixit that put a...

I'm using the latest version of Firefox and I have accidentally hit something that made the taskbar at the bottom and the other bar at the top(with the back button, etc) disappear. I can view the top bar by pointing my cursor off the top of the page, but I can't ever see the taskbar. How do I...

Is it possible to draw diagonal lines using Word's drawing tool? I mean lines that, when printed, don't look the eroded side of a pyramid. Are smooth diagonal lines possible? What about in MS Paint? Or anywhere? Thanks, GS **********************^********************* I always know where...