Hello,
I have problem with my HyperV virtual server, he minute after start was stopping with critical error.
Where in the system i can find more information about this error?
I have a problem with a specific user's computer running windows XP SP2 and Office 2007. Although she has the regional date setting in windows to dd/mm/yyyy, her office applications are still reverting to mm/dd/yyyy which is driving her (and me) nuts.
None of our other machines is doing this. Does anyone have a clue as to what to be looking for as the source of this irritating problem?
I am creating a form in Word 2007, using the controls available in the Developer tab.
On my first page, I have the user enter a name into a text control. I want to have a control on the second page to automatically fill in with the same text as the first one.
Is there any way to link these controls together?
I have an Excel sheet as follows:
NO NAME AMOUNT
1 A 50
1 B 50
2 A 100
2 C 100
3 D 70
3 B 70
4 A 30
4 F 30
5 C 150
5 G 150
.
.
.
.
There are let's say 10,000 rows.
I want to get a random sample from rows. There are 2 conditions:
1. Sampling must be based on "NO" column.
2. Size of the sample is determined by the user: it can be %5, %10 or %20.
For example, one decides to randomly choose %20 of total rows in the above example:
The result is like:
NO NAME AMOUNT
2 A 100
2 C 100
90 Z 500
90 E 500
.
.
.
.
There should be 2,000 rows.
I don't know whether my question is too specific. I am new to Excel VBA, and I faced a situation like this. Above process is about getting a random sample from an account ledger for auditing purposes.
Hello,
I'm in an odd situatuion here,
I've upgraded my network to a 2008 domain from a 2003 with out any issue, this works fine and all the FSMO are in one DC,
I was about to install a second domain on a 2008R2 and this error is coming up again and again.
I The problem is I keep getting an area telling me that I need to run adprep /domainPrep /forestPrep, but when I run it on the First DC, it tells me this has already been run and updated and it is aborted. Does anyone have any ideas on why I can't add a Server 2008 machine as a domain controller?
Windows 7 has a cool applet called Math Input Panel (http://blogs.msdn.com/e7/archive/2009/04/23/ink-input-and-tablet.aspx).
Does anyone know if a version of this is available for Windows XP?
I have data formatted like so.
1, 2, 3, 4, null, null, null
A, B, C, D, null, null, null
1, null, null, 4, 5, 6, 7
A, null, null, D, 8, 9, 10
I want to copy the data from row three into the missing "null" cells in row one, because there is a match on cell values one and four upon comparing row one and row three.
So far I have the following.
=INDEX(A2:AE346, MATCH(A351&F351&G351, A2:A346&F2:F346&G2:G346, 0), 2)
Here is a spreadsheet with some sample data so you can test your formulas.
I have a table which contains a column with different items which i would like to count by there type. For example the table looks like the following:
Id Type
1 Table
2 Table
3 TV
4 TV
5 Table
6 TV
7 TV
The result should looks like:
Type NumOfItems
Table 3
TV 4
I use the following code which doesn't work for my Access 2003:
SELECT Table1.Type, Count(Table1.Type) AS NumOfItems
FROM Table1
I created a dropdown list with values and assigned them to one of the columns in a table.
When I changed a few, then changed the name of items in the list and removed some I accidentally did some key combination somewhere around Ctrl+Z or Ctrl+Y and Excel highlighted cells in the table that had a value not on the list.
The highlighting looks like a red oval around each such cell. How can I toggle it on and off?
Title says it all realy. I'd like to apply square text wrapping to an Excel chart inserted into my document. The normal options don't seem to exist. Is there any way of doing this other than inserting the chart into a textbox?
I'm just getting used to styles (always did the formatting "manually") so this may be overly simple question to some.
I wish to modify styles once and for all, and then give that "design" to some of my coleagues, and they will use it to write ... whatever they need to write. But I wish to restrict them from modifying it.
I.e. they should be able to make new documents using the given design, but shouldn't be able to modify the design.
This make any sense? Any ideas?
We have 300 windows xp machines on cruddy old hardware across the company.
With extended support for XP ending April next year we're looking into our options.
Couple of options:
Replace the 300 PC's with full windows 7 PC's (£100k +?) - no use of terminal server (our current model)
Replace the 300 PC's with off the shelf thin clients & make use of our terminal server - Cheaper clients but Terminal Server CALS required?
Keep the 300 PC's, replace windows XP with linux thin client capable of connecting to our terminal server - no hardware costs, just Terminal Server CALS required?
Keep the 300 PC's - remove hard drives and make use of a PXE bootable "thin client" to connect to our terminal server
If we were to choose option 4, what our the options out there? Is there any official PXE bootable thin clients for terminal server out there? If so, what are the licence requirements?
Is there options we haven’t considered? There must be lots of companies out there in this situation - curious what the current trend is for this problem?
Edit:
Option 5 - Create a bootable Windows PE image with RDP auto start and use that as a "thin client" for our terminal server - is Windows PE licence free in such a model?
Hello all, Here is my scenario; Windows 2008 server on a VM Two VM disks; Disk1 OS Basic Disk2 Data and an Installed Application. Basic
Durng the weekend, I was playing with this VM, I wanted to add some space to the Disk2. Created a new disk (disk3), converted it to a Dynamic volum and added this to disk 2 (disk 2 also converted to Dynamic volume) and for some reason these now are spanned volumes. just like an IDOT, I haven't taken any snapshot of this before I've made the changes. My question, is there a way I can re-convert this again to Basic? I don't want to delete and recreate the disk volumes because of the application installed on the disk 2
Any solution or tips I can use?
I have developed a macro that does a whole bunch of things for me based on a few things.
(Importing files).
The file names are dated dd_mm_yyyy and right now I enter them into a sheet where the macro can call the information. Not really wanting this I designed a userform where the user could enter the "dd", "mm", "yyyy" and how many consecutive days of files there were.
Ex. Say
28_06_2011.txt
29_06_2011.txt
there would be one consecutive day.
I want to be able to call the information entered in the user-form (day, month, year, and consecutive days) to use in the macro and have been unsuccessful because I don't know how to call that information. Is it similar to referring to a range in a worksheet?
Thanks in Advance for any Help.
I recieve the following error when I try to configure SharePoint 2010 Server:
"Cannot connect to the database master at SQL server at [computer.domain]. The database might not exist, or the current user does not have permission to connect to it."
I run the following setup:
Windows Server 2008 R2 Standard with SP1 and all the updates
SQL Server 2008 R2 with SP1
SharePoint Server 2010 with SP1
Everything is installed on the same server (it's a testserver)
I have tried the following:
Rebooting the server
Checking the install account's DB rights (dbcreator, securityadmin - I even let it have sysadmin)
Opened up the firewall on port 1433 and 1434
Uninstalled both SQL and SP, then reinstalled the both
Enabled all client protocols in SQL Server Configuration
Made sure I used the correct account for installing SharePoint (local admin)
Useful links:
TCP/IP settings – http:// blog.vanmeeuwen-online.nl/2010/10/cannot-connect-to-database-master-at.html
http:// ybbest.wordpress.com/2011/04/22/cannot-connect-to-database-master-at-sql-server-at-sql2008r2/
Wrong slash - http:// yakimadev.com/2010/11/cannot-connect-to-database-master-at-sql-server-at-serverdbname-error-during-sharepoint-2010-products-configuration-wizard-and-installation/
Port error - http:// www.knowsharepoint.com/2011/08/error-connecting-to-database-server.html
It's not programming, but it's the paperwork you have to fill out ot get things to program.
When you have a list with an item that's two lines long, and text above pushes it down such that a page break should fall between the two lines, Word pushes the item down so that both lines are on the following page - this is called Widow/Orphan Control and is an option on the Paragraph menu.
When the list is inside of a table cell, however, this feature doesn't seem to work - which is what I'm looking to work around. Word doesn't push the item down automatically, so it breaks across two pages, as seen here:
Solutions that have been tried:
Playing with the options on the Paragraph tab: doesn't seem to do anything
Changing the margins or text: this is a template and will need to always work
Any ideas?
I keep a log of phone calls like the following where the F column is LVM = Left Voice Mail, U = Unsuccessful, S = Successful.
A1 1 B1 Smith C1 John D1 11/21/2012 E1 8:00 AM F1 LVM
A2 2 B2 Smith C2 John D2 11/22/2012 E1 8:15 AM F2 U
A3 3 B3 Harvey C3 Luke D3 11/22/2012 E1 8:30 AM F3 S
A4 4 B4 Smith C4 John D4 11/22/2012 E1 9:00 AM F4 S
A5 5 B5 Smith C5 John D5 11/23/2012 E5 8:00 AM F5 LVM
This is a small sample. I actually have over 700 entries. In my line of work, it is important to know how many unsuccessful (LVM or U) calls I have made since the last Successful one (S). Since values in the F column can repeat, I need to take into consideration both the B and C column.
Also, since I can make a successful call with a client and then be trying to contact them again, I need to be able to count from the last successful call. My G column is completely open which is where I would like to put a running total for each client (G5 would = 1 ideally while G4 = 0, G3 = 0, G2 = 2, G1 = 1 but I want these values calculated automatically so that I do not have scroll through 700 names).
I have to create Documents in about my project that is written in about Android.I use Word 2010 and I copy some lines of my code into the Word doc then I add my descriptions.My problem is huge number of error of spell checker of Word that arises in each paragraph(lines that I paste them from my code into Word).For example it may be used setSpan,removeSpan and ... in my codes and spell checker show red underline under all of them.You can see huge number of errors in a few lines that I paste them:
Is there a way to add all spell errors to word dictionary at once for selected area?
There are a ton of utilities for cleaning the html produced by Word. Some are online services and some are Windows desktop apps.
Does anyone have good experience with any? I am looking for one that does a very good job of maintaining the layout and text styles of the original document. The people using the tool know very little or no html which means they can't be spending time doing html editing to fix the layout.
I have this spreadsheet that started as a silly aid for a game (Mafia Wars 2), but grew into a tricky spreadsheet question.
In the game your character have 9 "slots" for weapons and armors, 1 for each "type": Light Weapon, Heavy Weapon, Body Armor, Head Armor, etc. So I made a list of all weapons and armors available in the game, 1 item per row. Example:
SHOP ITEM TYPE ITEM NAME ATK DEF PRICE EQUIPPED?
Marketplace Weapon Light Konrad Knife 16 5 5.500
Marketplace Weapon Light Ice Queen 19 6 8.200
Marketplace Armor Body Up Layered Polym 0 31 8.600
Marketplace Armor Body Up Full Shield 7 42 17.650
Marketplace Weapon Heavy Konrad Bullpup 53 25 24.500
Marketplace Weapon Heavy Full Moon Blow 73 12 24.500 x
Marketplace Armor Body Low Knee Pads 17 26 14.200 x
Marketplace Armor Body Low Army Boots 15 55 24.500
Bone Yard Weapon Light Bone Launcher 41 2 9.400 x
Neon Strip Vehicle Ground Supercharged 41 34 24.500
Dead End Weapon Heavy Sharp Sickle 21 5 24.500
Dead End Armor Body Low Unholy Boots 5 36 15.000
Dead End Armor Head Hockey Mask 5 18 15.900 x
Last columns is an indication of the items i have already bought and equipped (marked with "x"). What I need is a formula that, for each "slot" (item type), returns info related to the item of that kind that I am using. That would be:
ITEM TYPE SHOP NAME ITEM NAME ATK DEF PRICE
Weapon Light Bone Yard Bone Launcher 41 2 9.400
Weapon Heavy Marketplace Full Moon Blow 73 12 24.500
Weapon Special -- -- -- -- --
Armor Body Up -- -- -- -- --
Armor Body Low Marketplace Knee Pads 17 26 14.200
Armor Head Dead End Hockey Mask 5 18 15.900
Vehicle Ground -- -- -- -- --
Vehicle Water -- -- -- -- --
Vehicle Air -- -- -- -- --
The item types are fixed, so they can be hard coded. Each row for an item type.
So, for 1st result line, it would return data from the row where both 2nd column is "Weapon Light" and last column is "x". Basically I need a LOOKUP (or VLOOKUP, or anything else) that uses 2 criteria to find a given row, the item type and the X marker.
Question is: HOW?
I am using OpenOffice Calc 3.2.1, but since it shares so many functions with MS Excel, answers for Excel are also fine (as long as it only uses regular formulas, no VBScript or Macros or VBA etc)
Last but not least, suggestions / solutions for rearranging the data so it makes this problem easier to solve are also welcome.
Thanks!
I was following the steps in Scott Hanselman's blog post describing how to create a certificate authority and code signing certificate for PowerShell scripts.
Initially, I created the certificate authority and a personal certifcate and used it to sign a powershell script successfully. All went as described in the blog post.
The problem starts (as most do) when I did something that was (probably) stupid, although it seemed reasonable at the time.
I wanted to start over and repeat the process again with a clean slate, so from the mmc certificates snap-in console, I deleted the personal certificate and the certificate authority I created previously. After that any time I try to use makecert, (just as I did the first time around), makecert either hangs or faults (which prompts to end or debug).
Did I hose something up by deleting via the certificates snap-in? It didn't complain or warn me that it could be potentially hazardous. Is this just coincidence and something else entirely could be hosed?
I have Event Log entries from the times when makecert crashed, which all look very similar; here is one:
Log Name: Application
Source: Application Error
Date: 8/5/2009 3:55:04 PM
Event ID: 1000
Task Category: (100)
Level: Error
Description:
Faulting application makecert.exe, version 6.0.6000.16384,
time stamp 0x4545910b, faulting module ntdll.dll, version 6.0.6002.18005,
time stamp 0x49e03821, exception code 0xc0000005, fault offset 0x00067409,
process id 0xe58, application start time 0x01ca160efdf30625.
Anyone have any ideas as to what exactly caused this and/or what I can do to fix it.
I'm on 32-bit Vista Enterprise w/SP2.
Is it possible to float a table to the bottom of a page in Word 2007?
I am making a template for revisable documents for work (specs, routines etc) and I want the front page to contain the document title, and a table of revisions. I want to float this table to the bottom of the page. So as I add rows to it, it grows upwards towards the title (which is at top of page, and not middle.)
Is this possible?
I have a tab-delimited text file with all of the phone numbers I've called or received calls from in the past year. The phone numbers are all based in the US, so the format is ###-###-####. For tax purposes, I need to know which calls were personal and which ones were business-related. I could enter them all one-by-one into Google, but that will take forever because there are hundreds of numbers to check.
Is there a program, MS Office plugin, or website that I can use to look up all of the numbers at once? If not, is there some way to create an Excel macro to do the lookups for me?