|
Templates
| Virus
Info | White
Pages | Yellow
Pages | Web
Search |
|
Password |
| Computer software for service based business |
|
|
|
||||
|
||||||
|
||||||
March 2008 In this edition
|
| ||||||||||
|
Survey Please note that there is no new survey this month. Feed back Want to say something or submit a good article or joke. The e-mail address is webmaster@am-win.com.au Stock code change - how to change the code and subsequent events You may change to a supplier who uses a different part number for the same item or you may need to change a code because the part number used previously has been superseded to a new number. Whatever the reason AM-Win not only lets you change the code but retains the previous code on all documents using the previous code and retains a record of the code change in the log file for security purposes. To access the stock code change open the stock menu and select "Code change"
Enter the stock code you wish to change into the Old Stock Code field. Alternatively click the select stock code button and your stock list will be displayed.
Select the code to be changed from your stock list, double click and the selected code will be entered into the code to be changed field
Type in the new number for the selected code and select update.
This will update the Stock file as well as the Sales & Purchase History of the Stock. Once the update button has been pressed, the Stock Code change window will be clear, and you may enter another stock code that you wish to change. Records of stock code changes are kept in the log file. You CANNOT CHANGE OR DELETE any of the information or records in the Log File. Nor can you “undelete” or restore them. More information about the log file can be found in the next article.
Log file on Delete The log file on delete is used to keep a record of records that have been
deleted or modified, why they were deleted or modified and when they were
deleted or modified. It is used whenever you delete a Customer Supplier, Job, Kit, Quote, Purchase Order, Stock Item, Job Item and others.
Business Information Six tips to improve financial health Make a budget Review your assets Assess super options Make a Will Review debt Bad debt is any debt that continually finances lifestyle or consumables and is not repaid promptly, particularly if the interest rate is in double figures such as for credit cards. Revisit personal insurance
Summary: One of the lesser-known drawing tools provided in Word is the drawing grid. You can easily turn this feature on and use it to help you create drawing objects that are uniformly sized and placed. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.) When you are working with Word's drawing tools, you might find it difficult to align objects. Fortunately there is a drawing feature that you can use to assist you in doing this. You can use the drawing grid to provide a temporary, nonprinting straight edge. In this way you can easily align other objects in your drawing. The value of the drawing grid depends on the version of Word you are using. If you are using Word 97, the drawing grid is not visible on the screen, but it remains there, acting as a "behind the scenes" force in helping to draw straight lines. If you are using a later version of Word, the grid is quite a bit more flexible, and can actually be displayed on the screen. If you are using a version of Word prior to Word 2007, follow these steps to make sure the drawing grid is turned on:
Word 2007 did away with the Drawing toolbar, so you should follow these steps, instead:
Summary: Want to correct the spelling of a word that Word thinks is improperly spelled? A quick way to do it is to right-click the misspelled word, as explained in this tip. (This tip works with Microsoft Word 97, Word 2000, Word 2002, Word 2003, and Word 2007.) As you are typing in your document, you may have noticed that some of your words are underlined with a red wavy line. These are words for which Word is questioning your spelling. You can quickly correct your spelling (assuming you agree that it may be incorrect) by right-clicking on the word in question. The resulting Context menu contains spelling suggestions that you can select. Word then replaces the word on which you right-clicked (the incorrect word) with the proper spelling. (See image below)
So many worksheets, so little space Have you ever had an Excel workbook with multiple sheets, those sheets having names other than the proverbial Sheet1, Sheet2, and Sheet3? An example of this is where business data is being kept in various workbooks, where tabs are corresponding to months, from January to December:
Rather quickly, you get to the point where you no longer can see all the tabs in one view. Of course, you can use the built-in tabs navigation buttons, and go the next, previous, first, or last sheet, but wouldn't it be great if there was a way to see all the sheets and be able to click on the one you want to work on? Well, there is one, and it has been there since Excel 4 (I think). Simply right-click the tabs navigation buttons and a floating list of all the worksheets in the workbook will appear, as pictured below. It is especially useful when sheet names are long. Now seems just the perfect time to also remind you of two great keyboard shortcuts: CTRL+PageUp activates the previous sheet in your workbook, while CTRL+PageDown activates the next one.
Adding a special character [Windows XP 0n] There are probably one or two special characters that you use regularly (for example, ® and ©). It can be a real time-waster to open your Character Map every time you want to insert one of these symbols. So don't! Open the Character Map by clicking Start, clicking All Programs, and then clicking Accessories. Click System Tools, and then click Character Map. Click the © symbol. Notice that the bottom-right corner of the Character Map shows the keyboard shortcut used to insert the special character. Write it down for later use. When you want to insert that character, here's the trick: Position the cursor where you want to insert the special character, then with NUM LOCK key on, hold down the ALT key and use the number pad keys to type the character value.
Whoops The following Whoops is from Ted Steward from AM-Win Queensland and for many "older" red blooded Australian males is the stuff that causes nightmares. The car is a genuine GTHO XY Falcon most of which are currently valued at between $100,000 and $250,000 depending on pedigree and condition. Apparently the car had just undergone a $95,000 restoration, and it was crashed on the way home by the owner. Hope he had Shannon's insurance - they'll understand! Gotta hurt
We publish the joke section of the newsletter by popular demand. Please note that some jokes may contain adult themes and could be considered by some as offensive. If you are offended by this type of humour please do not continue reading. We keep the joke section at the end of the newsletter and you will miss nothing by reading further. A man and his wife are dining at a restaurant when this stunning young woman comes over to their table, gives the husband an open-mouthed kiss and says she'll see him later. The wife glares at the husband and says: "Who the hell was that?" "Oh," he replies, "She's my mistress." "Well, that's the last straw!" says the wife, "I want a divorce." "I can understand that," replies her husband, "but if we get divorced it'll mean no more shopping trips to Paris, no winters in Barbados or Summers in Tuscany, no more Rolls Royce in the garage and no more yacht club. But it's up to you of course." Just then a mutual friend walks in with a gorgeous female on his arm. "Who's that woman with Jim?" asks the wife. "That's his mistress," says her husband. "Ours is prettier," she replies. Thanks to our good friend Sharon at Ebenreuter Diesel Services for the following "thoughts" What's the difference between an Australian zoo and a English zoo? How do you get a sweet little 80-year-old lady to say the F word? That's the guy I want to talk to A man owned a small farm. The cook's been here for 18 months, and I pay her $150 per week plus free room and board. Then there's the half-wit who works about 18 hours every day and does about 90% of all the work around here. He makes about $10 per week, pays his own room and board, and I buy him a bottle of bourbon every Saturday night.
He also sleeps with my wife occasionally." Daddy's gonna eat your fingers I was packing for my business trip and my three year old daughter was having a wonderful time playing on the bed. At one point she said, "Daddy, look at this," and stuck out two of her fingers. Until next month
| |||||||||||
|
| |||||||||||
C
