Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: AzizKamal
  • Content: Threads
  • Order by date
  1. AzizKamal

    MS Word: Count Words for a Specific Portion of the Document

    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...
  2. AzizKamal

    style overriding in MS Word

    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...
  3. AzizKamal

    linking records based on two table fields

    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...
  4. AzizKamal

    deploy asp.net application with crystal reports on server

    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...
  5. AzizKamal

    using custom domain in office 365

    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...
  6. AzizKamal

    center-align menu item text

    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...
  7. AzizKamal

    center-align menu item text

    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...
  8. AzizKamal

    multilevel numbered headings in ms word

    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...
  9. AzizKamal

    Analysis ToolPak - Random Number Generation

    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...
  10. AzizKamal

    select maximum value based on condition

    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...
  11. AzizKamal

    Hyperlink to Reference List

    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...
  12. AzizKamal

    update changes in style set

    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...
  13. AzizKamal

    calculate annual tax

    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...
  14. AzizKamal

    outlook: display subject line in page setup header

    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...
  15. AzizKamal

    checking compliance

    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...
  16. AzizKamal

    download ms access file to client computer

    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...
  17. AzizKamal

    set width percent in nested table

    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>"...
  18. AzizKamal

    replace dot matrix printer with laser printer

    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...
  19. AzizKamal

    extract opening balance of loan

    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...
  20. AzizKamal

    connect to protected excel workbook

    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...

Part and Inventory Search

Back
Top