Can I add a second table (high-level) of contents and show only H1 headings? When I tried to add a second TOC, it seemed to just scroll down to the bottom of my existing TOC.
I have a list of text entries and I want to count how often each entry appears in the list.
e.g.
Berlin
Paris
London
London
Paris
Paris
Paris
The result would be
Berlin 1
Paris 4
London 2
This result easy do to achieve with an pivot table in MS Excel (see:
Count Items in Excel).
My data not in spreadsheet in Excel but in a MS Access database table. So in order to avoid constant switching between Access and Excel and I would like to handle everything in Access (either Access 2007 or 2010).
I know there are pivot tables in Access and I know how to display one, but I was unable to find out how to count the number of occurrences.
Thank you!
I have several similar SharePoint sites (running on WSS 3) and I have saved one of the sites as a template. I now want to make a different site (which already exists) have the same structure as this site--the same lists, document libraries, views, etc.
I know I can delete the existing site and then recreate it based on this template, but is there a way to apply this template to my existing site, so that it gets rid of its existing lists, etc., and replaces them with the ones from the template? I don't have any content in the site, and I don't want to keep any of the existing structures, so I don't care if anything gets swept away.
I may need to do this with a bunch of sites in the future, so being able to apply the template rather than recreating from scratch might be very helpful.
Hey there,
I'm finding it difficult to get MS reporting working to what I'd like to show.
What I'm trying to do is:
a) In my database store a URL file (HTTP external file), that is a .jpeg. I'd like to use that URL to call the image on the report sheet. I have tried to use 'Control source' on the data panel, but with no success. Any way I can get Dynamic Images to show up on each database.
Also, I have a couple of Relational Databases.
One Defines Values:
For Example:
DefinePets('petID','Name of Pet')
The other one links the Main DB with the 'DefinePets' database.
Eg:
connect('petID','mainID','extraFeild')
I'd like my report to Go into the "connect" Table, where the the currently viewed Record Value = mainID, then find petID and return Name of Pet.
There is a many to many link between definePets and the main Table. (Therefore connect is joining them up)
Or is that too much to ask from a simple package like Access?
Thanks.
Hello,
I have problem with my HyperV server, he minute after start was stopping with critical error.
Where in the system i can find more information about this error?
I'm stuck using word 2007 at the office. It has options for retaining formatting, pasting as plain text, and pasting text to match the destination's formatting. That last option is the one I want, but word is blatantly ignoring it.
I copy some text from a PDF, paste into word, and it retains the PDF's formatting... even though I went into options -- advanced -- changed all the dropdowns to "Match Destination Formatting". It also ignores "text only" option... It retains the exact mix of bold, italic, normal text & fonts.
I can work around it by pasting to a plain text file, then pasting into word. Or I can do paste special -- unformatted text. But this is so irritating... I just want to ctrl+V and not hassle with it every single time. Is there a better fix?
I have data in a range of cells (say six columns and one hundred rows). The first four column contains data and the sixth column has a limiting value. For data in every row the limiting value is different. I have one hundred such rows. I am successfully using Conditional formatting (e.g. cells containing data less than limiting value in first five columns are made red) for 1st row. But how to copy this conditional formatting so that it is applicable for entire hundred rows with respective limiting values.
I tried with format painter. But it retains the same source cell (here limiting value) for the purpose of conditional formatting in second and subsequent rows. So, now I am required to use conditional formatting for each row separately s
i'm looking to become really really good at understanding my machine. this includes hardware, software, firmware, the internet, creating my own network, troubleshooting problems, etc. I have an aerospace engineering degree so i'm technically inclined, but i want to really delve deeper in becoming a techno guru.
what literature should i start reading? books, textbooks, journals, articles, papers, etc. anything would help, thanks!
Hello:
I have a custom toolbar associated with some VBA macros in Word 2003. I want this toolbar to alway be visible, independent of the doc or template open.
Is there any way of doing it?
Thanks in advance.
Hi all
In Word 2007 I have a Page which had to be changed to vertical mode. Now when I look at the page it's vertical but the header/footer are still horizontal is there a way to change them to the existing alignment?
How do I change the font used by numbers, or numerics, in a Word 2007 document?
For the rest of the document, they would be using another font for the letters and such, but I would like the numbers to be in a different font altogether.
If this is possible, how do I set it?
Folks/Mates,
I need some advise and assistance regarding the testing of Hyper-V.
Here is my h/ware configuration:
1) Intel i5 processor (i5-750)
2) Intel M/B DP55WB
3) 6 GB DDR3 RAM
OS = Server 2008 R2 Standart (evaluation copy).
I installed 2008 r2 on my machine and added hyper-v role to it. I created 2 VMs and installed OS. But after finishing the OS installation the VMs are not booting up.
After finishing the OS installation, the VM reboots automatically (normal behaviour) and shows "preparing your system for first time" after that it reboots and didn't come online.
Few things to notice, when I am running "securable" on my server 2008 R2 OS it shows that processor is not supporting h/ware virtulization, but (since my desktop is dual boot) when I am running "securable" on my windows 7 OS, it shows that process "does" supports hardware virtulization. VT option is already enabled in BIOS.
Any help and suggestions are highly appreciated :)
Thanks in advance.
Pradeep Rawat
I have auto recovery on my Excel program and I save my work several times a day. Tonight, I turned on the computer and it had shut down down for some apparent reason. When I pulled up my Excel program it only showed one auto recovery file form 8am this morning even though I worked/added onto my Excel sheet for several hours this afternoon.
Is there any way to recover my work I did this afternoon?
I'm using Java to read a form that is in an Excel spreadsheet that the user fills in with information about geometric shape. Ex:
Shape :_________
Color :_________
Area: _________
Perimeter:________
So far the code I have can I can read what I want in the form and print out the values of Shape, Color, Area, Perimeter.
public class RangeSetter {
/**
* @param args
* @throws IOException
*/
public static void main(String[] args) throws IOException {
FileInputStream file = new FileInputStream(new File("test2.xls"));
//C:\Users\Yo\Documents
// Setup code
String cname = "Shape";
HSSFWorkbook wb = new HSSFWorkbook(file); // retrieve workbook
// Retrieve the named range
// Will be something like "$C$10,$D$12:$D$14";
int namedCellIdx = wb.getNameIndex(cname);
Name aNamedCell = wb.getNameAt(namedCellIdx);
// Retrieve the cell at the named range and test its contents
// Will get back one AreaReference for C10, and
// another for D12 to D14
AreaReference[] arefs = AreaReference.generateContiguous(aNamedCell.getRefersToFormula());
for (int i=0; i<arefs.length; i++) {
// Only get the corners of the Area
// (use arefs[i].getAllReferencedCells() to get all cells)
CellReference[] crefs = arefs[i].getAllReferencedCells();
for (int j=0; j<crefs.length; j++) {
// Check it turns into real stuff
Sheet s = wb.getSheet(crefs[j].getSheetName());
Row r = s.getRow(crefs[j].getRow());
Cell c = r.getCell(crefs[j].getCol());
if (c!= null ){
switch(c.getCellType()){
case Cell.CELL_TYPE_STRING:
System.out.println(c.getStringCellValue());
}
}
}
}
What I want to do is to create a method that gets the that information and another that sets it.
So far I can only print to the console
A colleague of mine organizes her data using MSAccess. she outputs the table and pastes it into an excel file (same headings/ columns,,,,). The excel sheet then does some calcs and outputs a summary sheet.
Is there a way to automate this process?
I need to write a macro to manage ranking and calendar for curling turnament.
The event will follow the Shenkel system
first match determined by general draw
after that every team has played one match is possible to determine the first ranking
second match determined by the rule: 1st vs. 2nd - 3rd vs. 4th - 5th vs. 6th and so on
after that every team has played two matches is possible to determine the second ranking
and so on until the end (3 to 5 matches normally).
Another rule is that from the second match is not possible to play against a team that I played before!
I was thinking to use MS-excel but also Calc (both LibreOffice/OpenOffice) should be fine. Thanks in advanced
I'm wondering if anyone knows of a plug-in for MS Word which can handle key-presses of surrounding keys when typing at speed (rather like iPhone or Android autocorrect)?
My use case is in transcribing interviews where I need to type quickly (even with the playback at half speed) - but I don't do this often enough to become a proficient touch typist. I will also be paying close attention to the text produced in subsequent analysis so I have a reasonable expectation that I'll catch any "hilarious" autocorrect errors.
Any pointers to plug-ins which work at either a system level or within MS Word would be great. Even in an open source word processor at a pinch, though I'd miss the MS Word environment and my macros.
Thanks.
Hi all!
I'm using MS Word 2007
Is it possible to replace the newline character (I mean \n) with some other character?
What about vice-versa? (replacing a character with newline)
Hi Team,
While preparing a Word 2007 document, I made a mistake. (Not to say I don't have any other copy of the document)
While formatting (as a try) I applied the style "Apply Style to Body to match selection". This caused the document to go totally in a wronfg format - having numbers even in tables.
Have you ever faced this? Could you please tell how to correct it?
Thanks
Lijo
Good Day to Everyone!!
Just wanna ask if there is a setting in MS Access 2007 to ignore all error messages, when i ran my application in MS Access 07 there are annoying messages that pop-ups. All I want is to ignore all those message without changing my code.. Thanks
I am trying to cleanup a text and for some reason every line duplicated 3 times am i able to get ride of duplicates with regex or tricks or do you know a software which could do that , text file is like this
Party Started 10:17 (89/1/2)
Party Started 10:17 (89/1/2)
Party Started 10:17 (89/1/2)
Jessica At Dinner 17:54 (89/1/2)
Jessica At Dinner 17:54 (89/1/2)
Jessica At Dinner 17:54 (89/1/2)
How can i clean it up , and get ride of duplicated lines , it's about 69,587 lines
Am currently using Outlook 2013.
Several times, when a mail is forwarded to me, i only see the First/Last name of the person in the forwarded mail, not the email id. Is there a way to make Outlook always display the email id.
I get these mails from people, who are also using Outlook but different versions.
One solution which we have to resort to, is to attach the mail, rather than forward, that way it retains the email address, but this is cumbersome, and I cannot ask everyone to do this.
This is similar to this question, but the answer selected does not work for me.
I want to create a hyperlink to the location of my Word document. The document is on an web server so its path is like http://myserver.com/folder/worddocument.docx.
I can use the field code "FILENAME" and the field code "HYPERLINK", but I can't figure out how to use them together.
File name:
{ FILENAME \* Lower \p \* MERGERFORMAT }
Hyperlink:
{ HYPERLINK "http://myserver.com/folder/worddocument.docx" }
In Excel 2003, when you created a XY chart using time as an axis, you could set the scaling of these axes by typing in the date. In Excel 2007, you have to use the decimal version of the time (eg. How many days since some arbitrary earlier date). I was wondering if there was a way to avoid having to make such a calculation?
A developer posted on a blog that this issue would be fixed in a future release, but all versions of Excel 2007 I have tried have not resolved this issue. The relevant quote:
Those of you familiar with this technique of converting time to a decimal may recall that Excel 2003 allowed you to enter a date and time like “1/1/07 11:00 AM” directly in the axis option min/max fields and Excel would calculate the appropriate decimal representation. This currently does not work in Excel 2007 but will be fixed in a subsequent release.
When I copy some drawing in Illustrator, it stores it in clipboard in 3 formats: bitmap, device independent bitmap and enhanced meta-file.
If drawing contains text, then meta-file version has no anti-aliasing.
Below are examples in MS Word
OneNote has no "Paste Special" so it always paste in EMF. Is it possible either to tell OneNote to paste not in EMF, or tell Illustrator to use anti-aliasing while storing picture with letters?