Search results for query: *

In an MS Word file, I need to count the number of words in a report from Introduction to Conclusion. The report also has some content before Introduction such as the cover page and Table of Contents, and it also has some content after Conclusion such as Appendices. The report has around 100...

I created a new file testone.docx in Microsoft Word 2013. I typed =rand(1,5) and pressed enter to generate a random paragraph of five sentences. Then I clicked Ctrl+A, selected Times New Roman, 12 points. In the paragraph, I selected one sentence and made it Italic. Now the total words in the...

I am developing a report in crystal reports 2008. The report extracts data from two peachtree/sage tables; JrnlHdr and JrnlRow. The tables JrnlHdr and JrnlRow are linked by a field called PostOrder. One PostOrder value in JrnlHdr can have multiple entries in JrnlRow table. I have to print all...

I have developed an ASP.NET web application in Visual Studio 2010 professional edition. When I was done developing the web forms, I right-clicked the project in Solution Explorer and selected Publish Website. It generated compiled files in a folder. I copied that files in the application folder...

I need to know about user restriction in office 365. I would explain my query through an example. Suppose an organization has its own domain (say myorg1.com) and hosting plan. The hosting plan allows the creation of 100 email addresses. After two years, the organization purchased office 365...

I am using Visual Studio 2010 Professional. I created a web form in ASP.NET showing menu items that allow the user to go to another aspx page. For this purpose, I used Menu control from the Navigation section in the Toolbox. The menu appears fine in the browser. However, the text of the...

I am using Visual Studio 2010 Professional. I created a web form showing menu items that allow the user to go to another aspx page. For this purpose, I used Menu control from the Navigation section in the Toolbox. The menu appears fine in the browser. However, the text of the MenuItem is...

In Word 2013, when I use headings with one decimal place such as 1.1, 1.2, 1.3 and try to shift it to the next first level such as 2.1, 2.2, 2.3, it works fine. Specifically, I can achieve the following results: 1.1 Heading one point one 1.2 Heading one point two 1.3 Heading one point three 2.1...

I am using Analysis ToolPak in Excel 2010. I added Analysis ToolPak by checking it in Add-Ins dialog box. My goal is to generate random numbers from 1 to 5 for 50 rows of one column. From cells B1 to C5, I made the table as follows: Column B Column C 1 0.2 2 0.1 3 0.4 4 0.1 5 0.2 Then...

In an excel file, I want to highlight a row conditionally. My columns are as follows: Column A: Serial Number Column B: Productivity Pages Column C: Cancellation Percentage Column D: Minimum Cancellation Percentage Column E: Maximum Productivity Pages My goal is to yellow-highlight that row...

I am working on a MS Word file, initially drafted by someone else. At the end of the file, there is a reference list. The reference list is designed in such a way that when I click on any reference, the whole reference list gets highlighted. When I right-click, and select Toggle Field Codes, it...

In Microsoft Word 2007, I created a new document testone. In this document, I entered Heading text, selected the text, and selected Heading 1. Then I centered the text, selected Times New Roman, 12 point, 0 spacing before and after, and double line spacing. Then I right-clicked Heading 1 in the...

I need to calculate annual tax based on a tax slab. To calculate the tax, I had to use sumproduct formula twice and one vlookup formula. I am not sure whether my approach is fine. May be it is a lengthy formula and it can be achieved with one formula?? Tax Computation Procedure is as follows...

In outlook 2007, I am printing an email from Sent Items. This email has both Message and Tracking information. When I printed the email, Message appeared on Page 1 with the word Tracking: written at the bottom of the page. Tracking information printed on Page 2. What I need to accomplish is...

In an Excel Workbook, Sheet1, I have authority matrix defined: Sheet1 4 columns with sample values: Min Perc Max Perc Authorizer Amount 1 25 Incharge 10,000 26 50 GM 20,000 Explanation of values: An incharge can approve from 1% to 25% of the Bill Amount or 10,000 whichever is lower GM...

In my asp page, there is a Download button. Clicking this button downloads data from oracle to an MS-Access (.mdb) file. This file is located on server at c:\Inetpub\wwwroot\HRIS\UploadFolder and filename is NewHRISDATA.mdb. When the data insertion in MS-Access file is done, datatoxs.asp page...

In Internet Explorer, I am viewing an HTML table, which has another table in it. This was my code earlier: Response.Write "<table border=0 width='86%' cellpadding=0 cellspacing=0>" Response.Write "<tr><td width='14%'>&nbsp;</td>" Response.Write "<tr><td width='51%'>Item Name</td>"...

In an asp application, there is a Print Receipt button. Clicking this button goes to a printerlocation.asp page. Here printer location is selected in the format \\computername\printersharename. Upon clicking the Submit button on printerlocation.asp page, it goes to printreceipt.asp page. This...

I need to extract opening balance of loan for employees. I am using CR version, which is included in VS 2008. I have the following tables: Table1 Loan: Fields: empcode,code,ldate,loanamt Sample Rows: 10012 204 100000 31/7/10 10012 206 90000 1/1/09 10012 207 10000 31/8/10 Table2 Period: Fields...

In an asp page, I call a function, ConnectXL with one argument. Argument is location/path of a macro-enabled (xlsm) excel file. ConnectXL function is: sub ConnectXL(filename) Set cnn = Server.CreateObject("ADODB.Connection") cnstr="Provider=Microsoft.ACE.OLEDB.12.0;" cnstr=cnstr & "Data...