Domain Web Center Forum » Recent Posts

Domain Web Center Forum » Recent Posts http://www.domainwebcenter.com/wp-content/bbpress/ Domain Web Center Forum en-US Sun, 20 May 2012 22:26:09 +0000 http://bbpress.org/?v=1.0.3 <![CDATA[Search]]> q http://www.domainwebcenter.com/wp-content/bbpress/search.php iwdy23 on "Perfect gift for mother's day" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=144#post-174 Sun, 13 May 2012 05:24:08 +0000 iwdy23 174@http://www.domainwebcenter.com/wp-content/bbpress/ Both the manufacturers and also the makers of your <a href="http://www.sepwatches.net/">replica watches</a> preserve on playing a cat and mouse game, it is possible to accretion them from a part of your affluence <a href="http://www.sepwatches.net/swiss-replica-watches-breitling-replica-watches-c-31_35.html">breitling replica watches</a> in our web site any time. iwdy23 on "Hot sale in BESTBUY" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=141#post-171 Wed, 09 May 2012 09:13:25 +0000 iwdy23 171@http://www.domainwebcenter.com/wp-content/bbpress/ If you willing to pay extra, a lot of the time, you might get <a href="http://www.wabuvwatches.com/rolex-rolex-submariner-c-447_458.html">rolex submariner replica</a> watches practically comparable towards the original Rolex, <a href="http://www.wabuvwatches.com/esprit-c-140.html">esprit replica</a> just isn't in a position to reach the similar evaluate for the originals. bakaleishik on "*** G u i d e for S a l e s ADS ***" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=137#post-167 Wed, 02 May 2012 21:42:35 +0000 bakaleishik 167@http://www.domainwebcenter.com/wp-content/bbpress/ If you want to place a SALES link here you need to follow these simple rules: SINGLE - Only one link per post; INFORMATIVE - Make your post informative and interesting to read; PERSONAL - Tell a few things about yourself and your baseness; PRICES - List your sample prices; SPAM - Place your post in the Spam folder; SHORT - keep the message short; SPELLCHECK - check your spelling and punctuation. All other posts will be DELTED. vladis on "Good and bad about the Permits" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=116#post-148 Sat, 21 Apr 2012 12:37:57 +0000 vladis 148@http://www.domainwebcenter.com/wp-content/bbpress/ Who would volunteer to collect the money? Who would collect people's driver's licenses? Who would fill out the application? Who would contact Newton Parks and Recreations? If you have answers for any of these questions - please proceed . . . with caution. postini on "Do not Sync Favorites folder" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=119#post-147 Sat, 21 Apr 2012 04:37:25 +0000 postini 147@http://www.domainwebcenter.com/wp-content/bbpress/ If you share your Favorites folder among several machines somewhere on the network, you might notice that you can't not to sync them. The option is disabled. To fix this, go to WinDir%\system32\gpedit.msc - User Configuration -> Admin Templates -> Network -> Offline Files and enable option "Do not automatically make redirected folders available offline". iwdy23 on "Present On valentine's day" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=118#post-146 Sat, 21 Apr 2012 02:17:25 +0000 iwdy23 146@http://www.domainwebcenter.com/wp-content/bbpress/ Better known for their <a href="http://www.louislvsale.com/">louis vuitton outlet</a> excellent type also excellent top quality plan, in the event you are like most girls, you must love the really feel and look of genuine designer <a href="http://www.louislvsale.com/louis-vuitton-for-men-louis-vuitton-briefcases-c-9_11.html">louis vuitton briefcases</a>. Alex the Great on "Good and bad about the Permits" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=116#post-144 Sun, 15 Apr 2012 08:32:43 +0000 Alex the Great 144@http://www.domainwebcenter.com/wp-content/bbpress/ We've got permits 3 times in the past. Only for Sundays. 2 years ago Vlad U. got us permit for Brown field number 2, and Alex got the permit for Warren youth soccer field. Procedure for Newton: Collect 16 current driver license copies from Newton residents Fill in the form <a href="http://www.newtonma.gov/civica/filebank/blobdload.asp?BlobID=41042" rel="nofollow">http://www.newtonma.gov/civica/filebank/blobdload.asp?BlobID=41042</a> Attach $75 and send to Newton Parks and Recreation Department Positive side of permit: Members who paid are always allowed to play even, if they are late. Non-paying player are asked to step down. That is the only way to provide old-timers a guaranteed place in the game. Negative side of permits: Permits only available for Sundays Permits only available for spring (April through June) and Fall (September through November) newSer on "How to Reduce the Size of Amazon EBS Volume?" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=113#post-143 Fri, 13 Apr 2012 08:59:14 +0000 newSer 143@http://www.domainwebcenter.com/wp-content/bbpress/ You are right. This is one tough problem. Here are the steps that I tried take to reduce my Windows EBS volume. I hope they will save time and effort in further experimenting: -01- Direct Copy You create an identical large volume, you create an empty volume of a desired (smaller) size, you attach both volumes to PROD and copy everything from a large volume to a small. Result: new instance will not pass second status check. -02- In-place Restore You backup your PROD into a separate drive and try to restore this content directly into a running Windows instance Result: it does restore, but all the locked files (registry) and skipped. -03- Volume Restore You backup your PROD into a separate drive and restore content into a smaller volume Result: new instance will not pass second status check. -04- Files and Folders Restore The same as previous, but you restore using Files and Folders option Result: new instance will not pass second status check. The only option left on the table is to launch a new instance and reinstall and reconfigure all the components one by one. What a pain! iwdy23 on "Gift For President Election" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=115#post-142 Sat, 07 Apr 2012 23:14:08 +0000 iwdy23 142@http://www.domainwebcenter.com/wp-content/bbpress/ Ask any one if they've heard about luxury <a href="http://www.replicawatchesuksale.co.uk/rolex-watches-c-42.html">rolex replica</a> and most of them will reply inside the affirmative, by trying the moment these watches, men and women who do not believe will start believing <a href="http://www.replicawatchesuksale.co.uk/omega-watches-c-79.html">omega replica</a> watches. dFrank on "How to Reduce the Size of Amazon EBS Volume?" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=113#post-140 Wed, 04 Apr 2012 13:56:10 +0000 dFrank 140@http://www.domainwebcenter.com/wp-content/bbpress/ There is no documentation on this on Amazon site. I have a small Windows instance, and I launched and configured an instance with 100GB EBS volume. Now I realized that I would have to pay $10 per month for this extravagance. I would like to reduce the size of my EBS volume down to 40GB. I do not want to start all over and reconfigure everything and reinstall everything into a new instance. Random articles of kindness I could find are about other-than-Windows instances. So far I tried this scenario: - Create an exact copy of my EBS volume (100GB); - Create a new 40 GB EBS volume; - Attach these volumes to my current instance; - Copy everything from 100GB to 40GB drive using ROBOCOPY; - Stop the instance and detach all volumes; - Attach new 40GB volume as a root device /dev/sda1 - Restart the instance. This being a perfectly nice plan, but instance didn't pass the second status validation check, and I had to return to my original 100GB volume. Any ideas on what I am doing wrong? iwdy23 on "Top Five popular on youtube" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=111#post-138 Wed, 28 Mar 2012 21:56:37 +0000 iwdy23 138@http://www.domainwebcenter.com/wp-content/bbpress/ Our <a href="http://www.rolexreplicaltd.org/breguet-c-179.html">breguet replica</a> watches as nicely might be employed to become worn as vogue accessories, <a href="http://www.rolexreplicaltd.org/omega-c-256.html">omega replica</a> watch is every single a superior invest in for you as well as a excellent gift for the lover, close friend or colleague. bakaleishik on "W2K8 R2: Could not create a Disk Cache Sub-directory for the Application Pool" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=106#post-133 Mon, 26 Mar 2012 11:22:14 +0000 bakaleishik 133@http://www.domainwebcenter.com/wp-content/bbpress/ This recipe is how to fix the error above on W2K8 R2 Server that runs legacy ASP pages. You might see just one error in the Event Log that appears every time anyone tries to access ASP site: <code>The Template Persistent Cache initialization failed for Application Pool 'Your Site' because of the following error: Could not create a Disk Cache Sub-directory for the Application Pool</code> You can fixed that error in the Event Log by changing Default Identity for the site in question from "ApplicationPoolItentity" to "Network Service", and giving user Network Service modify rights to folder C:\inetpub\temp\ASP Compiled Templates. It is nice to have a clean Event Log. bakaleishik on "WordPress Image Upload Problem on W2K8 R2 Server" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=103#post-130 Thu, 22 Mar 2012 09:31:26 +0000 bakaleishik 130@http://www.domainwebcenter.com/wp-content/bbpress/ Symptoms: You recently moved your WP (3.3.1) to a W2K R2 server, and now you can't upload images. You are getting this error message: <pre><code>Failed to upload due to an error: The uploaded file could not be moved to ...</code></pre> Solution: Forget for a second about permissions on folder wp-content\uploads. Instead, concentrate and fix permissions on folder wp_content. For an inspirational discussion on this topic see: <a href="http://wordpress.org/support/topic/file-upload-error-after-upgrading-to-33" rel="nofollow">http://wordpress.org/support/topic/file-upload-error-after-upgrading-to-33</a> All other tricks didn't work for me. I would suggest this material as a base for a new article. iwdy23 on "LV BIG SURPRISE" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=102#post-129 Thu, 22 Mar 2012 02:35:10 +0000 iwdy23 129@http://www.domainwebcenter.com/wp-content/bbpress/ Characteristics that will draw individuals includes Gucci's making use of <a href="http://www.louislvstore.com/women-louis-vuitton-handbags-c-1_3.html">louis vuitton handbags</a>, <a href="http://www.louislvstore.com/men-louis-vuitton-luggage-c-15_16.html">louis vuitton luggage</a> along with accessories increase to be able to represent individuality connected with customers. Udar Gromov on "Grab Your Replica! Louis Vuitton Fall 2012!" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=99#post-127 Wed, 21 Mar 2012 10:24:29 +0000 Udar Gromov 127@http://www.domainwebcenter.com/wp-content/bbpress/ Lessons Learned: - GOOD SPAM - We will allow an occasional interesting SPAM message on the site. Just make it informative and educations. Give some information, and hope for your link to attract attention of our visitors. Not too long, not too many links. Just right! - SPEED - Sluggish site is an annoying site. We are making all possible efforts to maintain a robust and responsive site. Starting from March 21, 2012 we upgraded all our servers with mode memory and more processing power. Enjoy the speed! Report problems. - COMMENTS - We can't allow irrelevant comments underneath an article. If you want your comment to go through, think about value your question or suggestion carries for others. All comments are welcome as long as they are relevant to the topic of the article. schmitd on "New Line Character in Excel Custom Format" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=100#post-126 Tue, 20 Mar 2012 18:58:35 +0000 schmitd 126@http://www.domainwebcenter.com/wp-content/bbpress/ Very short: One way I found to force a new line into Excel custom format is to press Ctrl+J while typing the format. I will write later more to explain. This method has two major disadvantages: - Excel doesn't recalculate the column width; - Only the first line of custom format string is visible. JAMIEKATE on "Grab Your Replica! Louis Vuitton Fall 2012!" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=99#post-125 Tue, 20 Mar 2012 08:22:12 +0000 JAMIEKATE 125@http://www.domainwebcenter.com/wp-content/bbpress/ <img src="http://kingpeter.blog.com/wp-content/blogs.dir/00/06/27/75/6277583/files/image/lvreplica1.png" alt="replica gucci handbags" /> Wow, two posts in the row! that is the attractiveness of the time of year, we arrive at provide a seem in any way outdoors of your new custom tote collections! This submit is brought for you by way of the exceptional <a href="http://www.wbrandbag.com/">Fake Louis Vuitton handbags</a>. i am exceptionally pleased to say that this handbag variety may effectively be my favored this season! maybe it is the custom luggage, maybe not, but I’m telling you the fact that crocodile hatbox is what drew me in to loving this collection. I imply – just look at out that green! I am often fired up to uncover what Louis Vuitton must offer, generally considering about which they in many cases are in the forefront outdoors of your style game. even though these are not all outdoors of your bags, I chose to place in most of my favorites! The only one which i need to converse in regards to the most, however, could maybe be the groundbreaking provide on Louis Vuitton monogram style. I phone call it the ‘sparkle-gram bag’ (featured above), and I really like that it arrives in so loads of colors! I’m particular that owning this tote would surely place the gloomy calendar months in check. Louis Vuitton are genius! Are you loving the synthetic Louis Vuitton custom collection? Comment under and preserve the discussion going! Tags: <a href="http://www.e4purse.com/">replcia gucci shoes</a>, <a href="http://www.e4purse.com/">chanel handbags</a> <a href="http://www.e4purse.com/">replica gucci handbags</a> mango on "How to install a legacy printer driver on Windows Server 2008 R2" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=98#post-124 Mon, 19 Mar 2012 20:32:59 +0000 mango 124@http://www.domainwebcenter.com/wp-content/bbpress/ When installing a printer driver for old printer, you do not want to press Windows Update button to pollute your system with thousands of legacy printer and device drivers. You want to install only your legacy printer driver. In this example we are installing Epson ActionLaser 1500 printer driver that happened to be HP LaserJet III printer driver. You need to have another Win 7 or W2K8 R2 instance, where these drives already installed. Load SYSTEM registry hive from parrallel instanse and either search for key word ("Laser") or navigate to this lokation: HKEY_LOCAL_MACHINE\QQQQ\ControlSet001\Control\Print\Environments\Windows x64\Drivers\Version-3\HP LaserJet III You are interested in a content of a key "InfPath". In my case it was pointing to: C:\Windows\System32\DriverStore\FileRepository\prnhp001.inf_amd64_neutral_081cf2b90ec9e6d5\prnhp001.inf Now, when installing a printer, use button "HaveDisk" and navigate to this directory. It worked in my case. Try it. iwdy23 on "Wear it in public place" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=96#post-122 Sun, 18 Mar 2012 23:43:35 +0000 iwdy23 122@http://www.domainwebcenter.com/wp-content/bbpress/ The <a href="http://www.rolexs2u.com/rolex-watches-submariner-c-1_7.html">rolex submariner</a> watches are generally copied, taking into consideration the actual placing as well as the dimension from the engravings as well as the fonts respectively, we are able to supply you the very best and many dependable <a href="http://www.rolexs2u.com/breitling-watches-bentley-c-97_112.html">breitling bentley</a> watches on present day markets. iwdy23 on "I'm lovin'it - OMEGA" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=95#post-121 Tue, 13 Mar 2012 23:00:21 +0000 iwdy23 121@http://www.domainwebcenter.com/wp-content/bbpress/ During the website it is possible to discover top quality duplicate <a href="http://www.omegareplicallc.com/omega-mania-c-16.html">omega mania</a> watches, these days, you'll find increasingly more folks tend to select different <a href="http://www.rolexexact.com/explorer-c-10.html">rolex explorer replica</a> watches. congoPongo on "RoboCopy: ERROR 1314 (0x00000522) Copying NTFS Security..." http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=87#post-113 Sat, 03 Mar 2012 22:43:33 +0000 congoPongo 113@http://www.domainwebcenter.com/wp-content/bbpress/ Usually you can use RoboCopy like this: RoboCopy R:\zS7-R2-W2K8R2-SP1\3R2DATA C:\3R2DATA /e /zb /COPYALL /r:0 /w:0 /xJ However, if you copy from one server to another, you will only copy directories. None of the files will be copied with this error message: ERROR 1314 (0x00000522) Copying NTFS Security to Destination Directory . . . A required privilege is not held by the client. I found a simple way to fix this problem by changing /COPYALL to /COPY:DATSO like this: RoboCopy R:\zS7-R2-W2K8R2-SP1\3R2DATA C:\3R2DATA /e /zb /COPY:DATSO /r:0 /w:0 /xJ I do not recommend to use a /MIR switch, because it skips (or even modifies) security information on a destination machine. papa on "Excel Macro to Move Completed Rows into Another Sheet" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=86#post-112 Thu, 16 Feb 2012 10:22:48 +0000 papa 112@http://www.domainwebcenter.com/wp-content/bbpress/ It took me good 40 minutes to figure this one out. To save "soul-searching" time in the future, here is a complete listing: <pre><code>Sub Archive_Completed() ' Archive_Complete Macro ' 2012-02-15 WE 17:21 Remove complete lines from INPUT sheet and ' move them to "Historical Staffing" sheet 'Make sure it is INPUT sheet Sheets("INPUT").Select 'Turn OFF calculation and screen updating to speed up the macro With Application .Calculation = xlCalculationManual .ScreenUpdating = False End With 'Select first data row Range("A4").Select 'Go through all rows until an empty row reached Do Until IsEmpty(ActiveCell) 'Move to column 8 - "Completed" 'Note columns are shifted - fix logic here ActiveCell.Offset(0, 8).Select 'Check if value in 8-th column is Yes If ActiveCell.Value = "Yes" Then 'Cut entire row Selection.EntireRow.Cut 'Go to Historical Staffing sheet Sheets("Historical Staffing").Select 'Go to the bottom on that sheet Range("A1").End(xlDown).Select ActiveCell.Offset(1, 0).Select 'Insert row of data Selection.Insert Shift:=xlDown 'Return back to INPUT sheet Sheets("INPUT").Select 'Delete an empty row Selection.EntireRow.Delete Shift:=xlUp 'Note: Delete moves selection one row down 'Just return to first column ActiveCell.Offset(0, -8).Select Else 'Move one row down to the first column ActiveCell.Offset(1, -8).Select End If Loop 'Turn ON calculation and screen updating With Application .Calculation = xlCalculationAutomatic .ScreenUpdating = True End With End Sub</code></pre> Each line of code has a comment. So, "No further question, your honor..." papa on "How to Apply Row Conditional Formatting in Excel" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=85#post-111 Wed, 15 Feb 2012 22:42:28 +0000 papa 111@http://www.domainwebcenter.com/wp-content/bbpress/ Ok. Ladies and gentlemen. In Excel you have a "driver" column that has a limited number of values: marks, ranks, status and like. You need to color entire row based on the value in that column. Conditional formatting is the answer. This example: - assumes your data starts from second row; - uses column C as a "driver" column; - add 2 conditions Less than 4 and Greater then 7. -01- Highlight the entire range of cells that need coloring (it means all rows and all columns that will be included in coloring). -02- Pick Conditional Formatting on Home tab, Styles section and pick New Rule. -03- Pick the last option - Use formula to determine witch cells to format. In the box "Format values where this formula is true" type this: <code>=IF($C2 < 4, 1,0)=1</code> Note: This formula is satisfied and evaluates to true, when value in your "driver" column "C" is less than 4. Missing dollar sign in fromt of 2 (in $c2) means that you want your condition to change for every row. -04- Set fill format to pink -05- Repeat the same steps for values greater than 7. Use formula: <code>=IF($C2 > 7, 1,0)=1</code> And set fill color to light green. You are done! Just look at your magnificent work. Note: if you need to set a rule for values between 4 and 7, use this more elaborate rule: <code>=IF($C2 > 3,IF($BC<7,1,0),0)=1</code> bag98jaege on "Useful Tips and Info for Finding Replica Handbags of All Kinds" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=82#post-108 Wed, 15 Feb 2012 01:41:24 +0000 bag98jaege 108@http://www.domainwebcenter.com/wp-content/bbpress/ Useful Tips and Info for Finding Replica Handbags of All Kinds As we all know that there are much benefits from a <a href="http://www.vip-bags.org" title="Replica Handbags">Replica Handbags</a>. No one of us want to miss the good chance to own a luxury handbag.<a href="http://www.vip-bags.org" title="Replica Handbags">Designer Replica Handbags</a> have been an important and necessary part for our life and which have brought so many beauty and leisure to our common life. A lot of women always change their clothes, shoes or handbags periodly, some of them possess serveral replica handbags for changing their image often. With the enhancement of strength of skin and finance, there is only one different aspect between the replica handbags and the original ones.Such as the <a href="http://www.vip-bags.org/replica-Miu-Miu.html" title="Miu Miu">Miu Miu handbags replica</a>, the manufacturer eyes on the quality and design, and they invest much on the research and development as well to make sure they can move forward in a more rapid speed.The different features and designs of <a href="http://www.vip-bags.org/replica-Miu-Miu.html" title="Miu Miu">Miu Miu replica handbags</a> are customized made for different women.In that way, every lady can find a bag interest to them. <a href="http://www.vip-bags.org/replica-Balenciaga.html" title="Balenciaga">Balenciaga replica handbags</a>,stylish and most young women's first choice <a href="http://www.vip-bags.org/replica-Coach.html" title="Coach">Coach replica handbags</a> and <a href="http://www.vip-bags.org/replica-Prada.html" title="Prada">Prada replica handbags</a> can frequently seen carried by Chinese super stars. The famous star Vicki is special engaging in Prada handbags, many street photoes of her is finding carrying a Prada bag. Most super stars is enjoying such a luxury life immersing in the sumptuous brand stuffs. bakaleishik on "Insert Year Field into PowerPoint" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=81#post-107 Tue, 14 Feb 2012 15:37:54 +0000 bakaleishik 107@http://www.domainwebcenter.com/wp-content/bbpress/ I found only this awkward way of inserting copyrighted Year and Company name into the footer: <pre><code>Sub InsertYYYY() '2012-02-14 TU 15:10 Sets all footers to "©2012 Company, Inc." For ii = 1 To ActivePresentation.Slides.Count With ActivePresentation.Slides(ii).HeadersFooters.Footer .Visible = msoCTrue .Text = "©" & Year(Now()) & " Company, Inc." End With Next ii End Sub</code></pre> This works both in PowerPoint 2007 and 2010. However, here are the problems with this code: - How to attach this code to "Open Presentation" event? - How to make footer textbox to appear in a desired place in the footer? - What about setting font size and color? schmitd on "Insert Year Field into PowerPoint" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=81#post-106 Tue, 14 Feb 2012 12:46:48 +0000 schmitd 106@http://www.domainwebcenter.com/wp-content/bbpress/ Can't figure out, how to insert fields into PowerPoint and how to update them. All I need is an updatable <code>© YYYY</code> in the footer of PowerPoint presentation. schmitd on "Using Excel with Visio" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=80#post-105 Sun, 12 Feb 2012 21:36:53 +0000 schmitd 105@http://www.domainwebcenter.com/wp-content/bbpress/ I came across 3 ways to use Excel with Visio: --- export hierarchical organizational charts; --- export network infrastructure charts; --- export custom shapes stored in Excel. What other usages of Excel can you discover? vladis on "Couple of New Format Tricks in Excel" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=79#post-104 Wed, 08 Feb 2012 10:56:04 +0000 vladis 104@http://www.domainwebcenter.com/wp-content/bbpress/ How to display thousands and millions format? You have a column of numbers (say population or territory) and the numbers are large. You want to display 1300000 as 130.0, and 230600 as 230.6. How to do that? To display rounded thousands (230600 as 231) use ##, format. To display thousands with one decimal (230600 as 230.6) use ##.0, format. To display millions with one decimal (230600 as 0.2) use ##.0,, format. How to display hours over 24 or minutes over 60? You a measuring duration of activities, and you want to display those durations in minutes or in hours. Obviously minutes could go over 60 and hours could go over 24. Ho to display duration of 600 minutes? To display duration of an activity in minutes over 60 minutes use [m] format To display duration of an activity in hours over 24 hours use [h] format. But can you display this with one decimal point? You can, but you need to use a formula: =HOUR(B7-A7) + MINUTE(B7-A7)/60 and use normal numerical format. bakaleishik on "Google Analytics Doesn't Work After WordPress 3.3.1. Upgrade" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=78#post-103 Sat, 04 Feb 2012 08:50:24 +0000 bakaleishik 103@http://www.domainwebcenter.com/wp-content/bbpress/ WordPress upgrade 3.3.1 gave a strange problem. Google analytics code wouldn't load properly in IE. After a brief investigation, we had to replace all ' (single quotes) with " (double qutes). That fixed the problem. schmitd on "Remove Links from Excel Column" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=77#post-102 Mon, 30 Jan 2012 12:48:32 +0000 schmitd 102@http://www.domainwebcenter.com/wp-content/bbpress/ Excel has a habit of converting emails into links. This conversion uses strange font and a strange size. The entire column looks ugly and out of place. When you finally fed up and ready to fix the problem, do this: -01- Copy any cell text cell with a good format; -02- Highlight entire email column; -03- Right-mouse click --> Paste Special --> Formats. mango on "How to do a conditional COUNT with T-SQL" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=76#post-101 Tue, 24 Jan 2012 21:55:11 +0000 mango 101@http://www.domainwebcenter.com/wp-content/bbpress/ In your TASKS database you have records in various categories. You need to produce a summarized report with 3 columns: Task Category | Tasks Open | Tasks Completed Regular count will not work. You have to use a conditional count. <pre><code>SELECT tkCategory AS TaskCategory, COUNT(CASE WHEN tkDoneYN = 0 THEN 1 ELSE NULL END) AS TasksOpen, COUNT(CASE WHEN tkDoneYN = 1 THEN 1 ELSE NULL END) AS TasksCompleted FROM TaskMaster GROUP BY tkCategory</code></pre> Note that field taskDoneYN is of type bool. mango on "How to compare date portion of SQL dates in C#" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=75#post-100 Tue, 24 Jan 2012 21:45:05 +0000 mango 100@http://www.domainwebcenter.com/wp-content/bbpress/ You need to compare, if 2 dates are of the same date. You want to ignore time portion of the dates. Here is how you do it in C#: <code>if (_DateDue.Date == DateTime.Today.Date)</code> In this example, we are comparing a variable _DateDue from database with today's date. bakaleishik on "Using Apple Magic Mouse with Windows" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=74#post-99 Sat, 21 Jan 2012 22:13:17 +0000 bakaleishik 99@http://www.domainwebcenter.com/wp-content/bbpress/ Yes! It is possible. You need a Bluetooth for mouse to work. If you want vertical scrolling to work, you need to install a driver () that creates a directory DIFX in your "Program Files". However, after each restart the pairing is forgotten and needs to be re-establishing again. I do not know how to enable horizontal scrolling. Here are some helpful links: <a href="http://www.lostintechnology.com/how-to/how-to-use-apples-magic-mouse-on-a-windows-pc/" rel="nofollow">http://www.lostintechnology.com/how-to/how-to-use-apples-magic-mouse-on-a-windows-pc/</a> mango on "Deleting Registry keys and values with REG file" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=73#post-98 Wed, 11 Jan 2012 12:56:20 +0000 mango 98@http://www.domainwebcenter.com/wp-content/bbpress/ Usually we are using REG files to add or replace things in registry. Do you realize that we can delete registry keys and even values by using this interesting trick. To delete a value: <pre><code>; This will delete "DeleteMe" string value [HKEY_LOCAL_MACHINE\SYSTEM\ To-Delete] "DeleteMe"=-</code></pre> To delete a key: <pre><code>; This will delete "To-Delete" key [-HKEY_LOCAL_MACHINE\SYSTEM\ To-Delete]</code></pre> Sources: <a href="http://support.microsoft.com/kb/310516" rel="nofollow">http://support.microsoft.com/kb/310516</a> vladis on "Services Required for iPhone to Synchronize on a PC" http://www.domainwebcenter.com/wp-content/bbpress/topic.php?id=72#post-97 Tue, 20 Dec 2011 16:53:57 +0000 vladis 97@http://www.domainwebcenter.com/wp-content/bbpress/ You do not have to run them automatically, but just remember to turn them on just before plugging your iPhone and running iTunes on your PC: - Apple Mobile Device - Bonjour Service