|
Below is much of the feedback we've received during the last month. If you have a question or comment about anything you've read in TechTrax, feel free to click the Feedback link above and let us know.
Note, however, the feedback link is not intended for general support questions. If you need help, be sure to check out the MouseTrax.com Resource page at: http://www.mousetrax.com/Resources.html for suggestions of support groups where you can get your general support questions answered.
Feedback
A reader from Fort Worth, TX writes...
I'm trying to create a policy and procedure manual at my office. I can create an adobe acrobat file that uses the bookmarks and hyperlinks, but I'd like to find out how to make a word document work the bookmarks while it is locked. I have figured out how to make a hyperlink work in a locked document, but I can't seem to make it work with a bookmark that is hyperlinked.
Is there such a way to lock a document and make the bookmark work as well?
Dian Chapman, Editor of TechTrax and author of several forms courses and articles here, writes...
You need to write a routine that toggles the locking of the document. Then you call that routine just before you need to handle the bookmark info, which will open the doc for a split second. After you deal with it, you relock the form.
You can use this toggle procedure. Note that I have commented out the error handler, assuming yours might be different. Also note that the password portion is commented out...you would have to add that back in by removing the ' and moving the code back inline, if you have a password. And...of course...adjust the password.
I teach users all about this and other bookmark procedures in my AutoForm course that you can learn about here: http://www.mousetrax.com/techcourse.html. You can also join my free VBA support group to get more info from other users
here: http://groups.yahoo.com/group/Word_VBA. Lots of great folks to help, including many of my former students.
Sub ToggleFormLock()
'On Error GoTo Handler
Dim strErrorString As String
'**********************
'coded by dian@mousetrax.com
'**********************
'PURPOSE
'Toggles Form locking to allow for automated input of data
'uncomment password arguments when password is added to locked form
'**********************
If ActiveDocument.ProtectionType = wdAllowOnlyFormFields Then
ActiveDocument.Unprotect 'Password:="myPassword"
Else
ActiveDocument.Protect Type:=wdAllowOnlyFormFields, NoReset:=True ', Password:="myPassword"
End If
GoTo Done
Handler:
strErrorString = "Procedure: ProtectForm"
'ErrorHandler strErrorString
Done:
End Sub
Hope this helps. Sorry I don't have more time to explain this in greater detail, but you can get full info from my course or by joining my free support group and working through your VBA issues with the group.
Feedback
Jon from Massachusetts writes...
Office 2003 seems to have "fixed" our ability to use the rules wizard or the out-of-office assistant when not connected to Exchange. Is there a different, less easily discovered method to create rules if I'm not using Exchange with OL2003?
Linda Johnson, author of Make an Out of Office AutoResponder, using Outlook *Without* Exchange, writes...
Hi Jon...I'm not sure what you mean when you say Office has "fixed" your ability to make rules in 2003 without Exchange? I actually believe Outlook's rules have greatly improved in this version, and what I describe in my tutorial on making an out of office assistant, still works. Just go to Outlook's Tools menu and choose Rules and Alerts. In that box, click on the button at the top that says "New Rule", then on the next screen choose "Start from a blank rule", then follow my directions in the article from there...nothing is different really.
Linda
Linda's Computer Stop
http://personal-computer-tutor.com
Jon replies...
Linda - The problem is that one client of mine long ago added an account on their server for me to use at their site. Apparently if there's an Exchange account, Outlook makes you attach the rules to that account. I removed the obsolete account, and now everything is fine.
Sorry for the bother. - Jon
Linda replies...
OK Jon...I just got both your emails and I was going to reply to the first one asking if you had an Exchange account setup in this install of Outlook...but I was fishing LOL...good to know that you figured it out and now we BOTH know that if there is an Exchange account, it will not let you set rules for any account but that. Handy info for me to have for future troubleshooting...thanks for that.
And...it wasn't a bother at all...we both learned something :-)
Linda
Linda's Computer Stop
http://personal-computer-tutor.com
Feedback
A reader writes...
Re: Hard and Soft Asset Management with VBScript!
Hi Greg, Great tool! I am VERY new to scripting, but I would like to believe that my request is do-able. Is there a way to use your tool on an OU only (instead of the default domain scan)? If so, what changes would I need to make to get it to use the OU?
Greg Chapman, author of Hard and Soft Asset Management with VBScript!, writes...
Yes, that's doable but it's a bit of a tall order that I'm not quite ready to commit to. Here's what you'll need to know should you decide to pursue it though: - LDAP object structure; you know, items formatted as CN=yada,OU=yada-group, etc - Enumerating a top level LDAP return to more finite elements till you've found the OU you want - Taking what you've learned about LDAP structure and creating your own script elements to perform these processes (I'm expecting this would be a minimum of 5 functions and possibly a lot of recursive calls to 3 or 4 subroutines)
At some point, I'll move around to deciding how to do this and write some code to do it myself. A cheat would be to create a special command switch for DomainReportManager.vbs in which you could specify a specific OU and treat it directly. To help me with my own thoughts on how to do this, would you mind telling me a little about your network structure and why or how parsing by OU would meet your needs?
And thanks for the compliment on the scripts!
Greg Chapman
http://www.layer1wireless.com
http://www.mousetrax.com
Feedback
Jon from Massachusetts writes...
Re: Outlook Annoyances
Taking your last point, I have a view I'd like to apply to all of my OL2003 message folders. I'm not going to select each folder, navigate down four levels of menu, and apply the view one folder at a time. I'm looking to do this automatically.
Apparently OL2003 has no means to do this automatically. There were some posts in the news groups about /cleanviews and changing Messages locally vs. changing Messages globally. Procedures varied from post to post, and none of the variations worked for me. What will work?
Herb Tyson, author of Taming [a few] Outlook 2003 Annoyances, writes...
You start out by using the cleanviews switch to make sure that no views for any particular folder contains any variations. Then, you choose View - Arrange by - Current View - Define Views. There, you explicitly modify the Messages view — NOT CURRENT VIEW.
This view will now automatically apply to all folders that use the Messages view. It won't apply to Send Items, for example (unless you explicitly set that folder to Messages view).
From there on, you have to be careful what you do, lest you "corrupt" the global setting as it applies to any given folder. As a practical matter, it's very difficult to maintain a pure global setting unless you're extremely careful. Frustration leads to carelessness, and I don't think I've been able to maintain a pure global Messages setting for longer than a few days.
Good luck!
Herb Tyson
http://www.herbtyson.com
Feedback
A reader writes...
Can you please help me out, i need a shortcut key in ms word 2000 for Page Setup, is it possible to do this. Need it badly or how to create it - i tried everything.
Dian Chapman, Editor of TechTrax and Co-owner of MouseTrax.com, writes...
Sure. I have one. This article will tell you how to add a toolbar or menu command.
http://www.mousetrax.com/toolbars.html
You can just choose Keyboard from the Customization/Options dialog to add a shortcut keystroke. You'll find the Page Setup command under the Customization/Commands or just under the File menu. Hope that helps.
Feedback
Bob from Minneapolis, MN, writes...
Excellent article however it was missing a particular detail that I was specifically looking for and I am sure others would agree. The article mentions the importance of compressing digital images for PPT presentations, but it says nothing about the smallest pixel resolution appropriate. I will be showing digital images of Africa and I would like to reduce the resolution as much as possible without losing anything for the audience. You do mention the "Web/Screen" compression feature in PPT, but if I do it within other applications where I have more control, I need to know the final resolution limits.
Thanks heaps, Bob
Geetesh Bajaj, author of Using Photos In PowerPoint, writes...
Hi Bob,
PowerPoint makes it easy by providing the Web/Screen option - for other applications you might want to use 96 dpi because that's close to the resolution of your screen and would provide best results unless you want a high resolution print of your presentation.
You could also go down to 72 dpi but nothing below that would be good - in my opinion 96 dpi is best for this sort of stuff.
Geetesh Bajaj, Microsoft PowerPoint MVP
http://www.indezine.com
http://www.powerpointed.com
Feedback
A reader writes...
Cannot find the URL to get to your ARCHIVES page.(Recommended by Lockergnome. Tanx
Dian Chapman, Editor of TechTrax, writes...
Look on the same menu bar where you found this Feedback button and click the one that says ARCHIVES.
Feedback
A reader writes...
i need help on the registration code for sims online cuz my code wont work for me
Linda Johnson, author of The Sims 2 ~ Explained, writes...
If your sims online registration code isn't working, you will need to contact Electronic Arts....they are the only ones that can help you. You can read this FAQ from their website and see if this answers your question...otherwise you will need to contact them:
http://snipurl.com/9of3
I'm just a player in the game, like you. I can't help you with registration codes, etc.
Good Luck
Linda
Linda's Computer Stop
http://personal-computer-tutor.com
Feedback
A reader writes...
Wow! I just read your review of the Sims2 and loved it. I found it and your screen captures here http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=426. Anyway. I was wondering where you found, or if you made, those wonderful clothes for Linda TechTrax? Where can I get those?
Linda Johnson, author of The Sims 2 ~ Explained, writes...
Hi. If you go back and reread that review I wrote, you will see links to both the Sims2 Exchange and The Sims Resource. I download a lot of clothes from them...I think I got those outfits from The Sims Resource. I also custom make my own clothes using The Sims2 Body Shop and PhotoShop....but I didn't make those particular ones :-)
Happy Simming!!
Linda
Linda's Computer Stop
http://personal-computer-tutor.com
Feedback
A reader writes...
My if statement =if(m7>$l7,m7-$l7,0).
I want to copy this across and down on a worksheet I am working on, however it copies they I want it to, and it calculates across on the first row, but won't calculate on the next row going across. I have checked the if statement and they are correct. When I go to the fx paste command it says my statement is false. I am very confused as to why it is doing this. Could you help me?
Linda Johnson, author of Introduction to IF Statements in Excel, writes...
Remove the dollar signs from the formula...In formulas, Excel sees dollar signs as absolute cell references and not money, so the $17 is telling Excel to always look at row 17. Change your formula to =if(m7>l7,m7-l7,0) and then it should work fine. Then you can highlight all the cells with the IF statements in them and go to the Format menu and choose Cells, then choose currency as your format and Excel will add the dollar signs to the numbers now in those cells. Never add dollar signs manually...always choose the Currency format. You may also have to do this in M7 if you added the dollar signs manually there too.
Hope this helps.
Linda
Linda's Computer Stop
http://personal-computer-tutor.com
Reader replies...
I think you may have misunderstood my IF Statement. It is -IF(M7>$L7,M7-$L7,O). Is this correct if I want to copy this down and across my spreadsheet. I wanted to keep L column absolute. I need to create this down my columns and across to get a total.
Thank you for your help.
Linda replies...
Yes, you are right you originally wrote $l7 and I read that as 17 dollars, not cell L7...my error.
However, I really don't know what you are asking. Your original mail (which you did not include in this reply...please do that from now on so I can remember what you've said previously)...anyway, I found that and it said
"I want to copy this across and down on a worksheet I am working on, however it copies they I want it to, and it calculates across on the first row, but won't calculate on the next row going across. I have checked the if statement and they are correct. When I go to the fx paste command it says my statement is false. I am very confused as to why it is doing this. Could you help me?"
Where exactly in the Paste Function box does it say "False"? If it says "False" on the line where you have M7>$L7, that means that M7 is NOT greater than L7...that's what is false. Is M7 greater than L7? If not, then it SHOULD say False. $L7 means that your formula will always refer to L when you copy it across the row but the 7 will change to 8, 9, 10, etc. as you copy it down the column. If you want it to always say L7, then you need to make it $L$7. Or maybe it's the M that's the problem....is that supposed to always refer to column M? If so, make that $M7 also.
Unless you can give me more specific details, the only thing I can suggest is you send me a copy of the file and I'll take a look at it when I get a chance, but I'm very busy right now so I can't guarantee how soon that will be.
Take care.
Linda
Linda's Computer Stop
http://personal-computer-tutor.com
Feedback
A reader writes...
Love Techtrax, but I hate (read absolutely abhor) having to scroll from left to right on any web site. Like the majority of computer users (Langalist) my monitor is set for 800x600 resolution. I have been given to understand that webmasters can write a code that will adapt to any resolution the computer is using. Is this possible? It would make for a far more pleasant read for me.
Dian Chapman, Editor of TechTrax, writes...
We do try to setup the page so that it changes with the size of the monitor, however, some of the many screen shots that we add to aid the articles cause the pages to remain wider. And yes, there are probably ways that we could spend time to make the pages work a bit better, but please do realize that TechTrax is totally free...and we don't even make revenue from ads, since we try to spare our readers even that by enticing experts to volunteer their time. Time that we are not paid for! So spending yet more time to fine tune pages with additional code to get all the pages to fit, just isn't something we can afford to do. We do need to spend time working and making our own livings. So...sorry if not all the pages align. Know that you can order the doc version to read, although also know that all images are removed from that version for both size and ease of use by our many blind subscribers.
Feedback
A reader writes...
Found your web-site thru google search: favorite files.
Looking for information on putting my Favorities which I have many, in alphabetically order. I'm new at this computer world and would like to do this in the least confusing method.
Dian Chapman, Editor of TechTrax, writes...
HA! Funny you should mention this...I am LITERALLY writing an article on this for the November issue! I have a great method to easily handle Favorites, as I, too, have many...and I'll be explaining it in the November issue of TechTrax! Stay tuned!
Editor's Updated Note! See A Few of my Favorite Things to learn how to handle your accumulating Favorites.
Feedback
A reader writes...
I see by browsing Feedback that Linda Johnson is an expert in Front Page. Brother, do I need her. I am traveling in a motor home, using a laptop. At home on my desktop, I have a website through Front Page. It's updated continually, especially the first of each month. When I left home, I copied all the files to disc. I copied them all onto my laptop in the motor home. But I lost all my navigation bars, and I can't publish changes. I re-did the navigation bars while trying to mess with the publishing problem, but I just can't get it to recognize my files. My passwords and log-in info don't even work. A tech call was no help at all; they kept referring me to basic publishing methods, repeated steps endlessly....I give up. Sigh.
Linda Johnson, FrontPage guru, writes...
The reason you are having the problem is two things. One, you shouldn't have copied the files to your CD...you should have PUBLISHED the site to your CD. Also, when you copy the files from the CD onto the laptop, they are read only (CD ROM stands for CD Read Only Memory)...you need to right click on the parent (main) folder and go to Properties and remove the check from "read only".
However, since you didn't publish to the CD, you still won't have navigation. So, instead, the easiest thing to do is connect to the Internet via your laptop and go to your website in Internet Explorer...then in Internet Explorer, go to the File menu and choose "Edit with Microsoft FrontPage"...this will open your site inside FrontPage...you can either edit it Live from there OR, go to File>Publish Web and PUBLISH it from the internet onto your laptop.
You can't just copy a website...you need to PUBLISH it from one place to another in order to retain the navigation and other FrontPage features.
If you need more help, I recommend you join this group and ask your questions there....lots of helpful FrontPage experts here: http://groups.yahoo.com/group/FPlist
Good luck!
Linda
Linda's Computer Stop
http://personal-computer-tutor.com
Reader replies...
Linda, I can't tell you how much I appreciate your help. This has been so frustrating for me. I will try everything you said. If I still run into problems, may I contact you again?
Linda replies...
Sure, but I'm not sure if I'll always be available. Like I said, if you want to be sure to get an answer, you should subscribe to that free FPList....there are MANY people in there smarter than me when it comes to FrontPage, so you'd be more likely to get a good answer right off the bat.
But, yes, you can write to me again...I just can't promise I'll always have time to answer, but I will try.
Good luck
Linda
Linda's Computer Stop
http://personal-computer-tutor.com
Feedback
A reader writes...
RE: Automating the Installation of Windows 2000/XP
It was a great article and told you step by step how to do it.
But, it didn't work for me.
I put in the CD and the answer file disk but when it starts to load it says
please insert the disk entitled Windows XP professional CD-ROM in disk drive
A: etc..
I try to install even without the answer file and it still doesnt work. Any
ideas would be appreciated.
Dennis Roche, author of Automating the Installation of Windows 2000/XP (after several discussion emails with the reader...which we won't bore you with), writes...
Ahhh ok, now I know what happened. There are files that are hidden on the root of the Windows CD. (These: WIN51, etc) and they are used by Windows upon installing (I believe to determine what OS it is installing Server/Pro what have you).
The xcopy process copies these files and that is why I included it and you probably are aware that all the other directories are not necessary.
Hope this helped. Feel free to contact me with any more problems
-Dennis
Feedback
A fellow MVP writes...
Mike,
I tried the link to your series from one of you recent replies in the newsgroup. I was interested in the latest one on recording macros. I am more into the foreground processing afforded by working directly with Project objects but your article was very well written and should be very useful for new users (or seasoned user for that matter) who want to get their feet wet with VBA and make their work more efficient. I didn't go through the article in detail because it takes too long to load with my slow 56K modem but if the other articles are as good as this one, you have a very nice series. How about making reference to your series in the FAQs (if you haven't already)?
Mike Glen, author of an incredible training series for Microsoft Project, writes...
Thanks, it's nice to have an accolade from one's peers :)
Mike
Feedback
T.J. Fucci from Augusta GA. U.S.A., writes...
All the time!!! you have
Led Zep.!!! The Stones! witch is cool!!!but I'm an Floyd!!! Fan!!! and I can't find them!!!
I'm upset and crying!!! Sooooo please give me my Floyd!!,
Troy
Dian Chapman, Editor of TechTrax, writes...
WHY on earth are you telling us? You might have noticed that we are JUST a tech support magazine and have NOTHING TO DO with AOL or what stations they put in their applications! We simply wrote an article on AOL Radio.
If you want to complain about what they play on AOL radio...try writing to AOL not TechTrax!
Article Popularity - Top 10 Article for October - From 10/01/2004 to 10/31/2004
|
