User Profile

Collapse

Profile Sidebar

Collapse
nebula53
nebula53
Last Activity: Jun 5 '13, 10:20 AM
Joined: Aug 8 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • How to link three tables without Common primary Key

    I need to generate a report from three tables, these tables does not have common primary Key, how can I link them.
    See more | Go to post

  • Code:
    <asp:DropDownList ID="DropDownList1" runat="server" 
                      AutoPostBack="True" Height="21px" Width="484px" 
                       onselectedindexchanged="DropDownList1_SelectedIndex">
                      <asp:ListItem Value="1">SELECT WORK TYPE</asp:ListItem>
                      <asp:ListItem Value="2">work
    ...
    See more | Go to post

    Leave a comment:


  • Code:
    using System;
    using System.Collections.Generic;
    //using System.Linq;
    using System.Web;
    using System.Web.UI;
    using System.Web.UI.WebControls;
    //using System.Web.UI.ScriptManager;
    using System.Data;
    using System.Configuration;
    
    
    
            
    
    public partial class _Default : System.Web.UI.Page
    
    {
        public decimal lastScore;
    ...
    See more | Go to post

    Leave a comment:


  • Mudassir,

    Thank you for your Help I used your code

    1. if(DropDownList 1.SelectedIndex ==0) //it is used for the first value
    2. {
    3. //process your query here
    4. }
    5. else if(DropDownList .SelectedIndex= =1)//for the second value
    6. {
    But without else if statement only (if)

    And its work fine now
    See more | Go to post

    Leave a comment:


  • Code:
    using System; 
    using System.Collections.Generic; 
    //using System.Linq; 
    using System.Web; 
    using System.Web.UI; 
    using System.Web.UI.WebControls; 
    //using System.Web.UI.ScriptManager; 
    using System.Data; 
    using System.Configuration; 
      
    public partial class _Default : System.Web.UI.Page 
    { 
        public decimal lastScore;
        public decimal lastScore1;
    ...
    See more | Go to post

    Leave a comment:


  • Code:
    <td class="style2">
                  <font size="4">Work Type: <asp:DropDownList ID="DropDownList1" runat="server" 
                      AutoPostBack="True">
                      <asp:ListItem>SELECT WORK TYPE</asp:ListItem>
                      <asp:ListItem>Work type 1</asp:ListItem>
                      <asp:ListItem>work type
    ...
    See more | Go to post

    Leave a comment:


  • nebula53
    started a topic How to link combo box values to specific Code.

    How to link combo box values to specific Code.

    I developed one page application with C#
    1. It supposed to get me the percentage of the expatriates Man-hours
    This application contains drop down list with different departments and table with radio buttons
    After choosing the work type and doing the evaluation form the table when I hit the button it’s give me the percentage for the first department.

    What I want to do is :
    When I choose the second department...
    See more | Go to post
    Last edited by Frinavale; May 23 '12, 07:20 PM. Reason: Showed the image attached in the body of the thread.

  • nebula53
    started a topic Keeping the text with the postback

    Keeping the text with the postback

    When I write down my comments inside the text box, how can I keep the comments with the postback


    [imgnothumb]http://bytes.com/attachments/attachment/5401d1315208942/untitled.jpg[/imgnothumb]...
    See more | Go to post
    Last edited by Frinavale; Sep 8 '11, 01:32 AM. Reason: added picture

  • nebula53
    started a topic access 2007 Database read only

    access 2007 Database read only

    I have access 2007 Database

    Its installed in more than one BC and I need to make it read only or lock it so the other users cannot change the information, how can I do that
    See more | Go to post

  • nebula53
    started a topic Please Advise

    Please Advise

    I created one page Evaluation application with C #

    The final score code is

    Code:
    decimal finalres = res1T10 + res2T10 + res3T10 + res4T10 ;
            int FinalToRemove = PtoRemove1T10 + PtoRemove2T10 + PtoRemove3T10 + PtoRemove4T10 ;
            if (finalres >= 1 && finalres <= 20)
            {
                lastScoreT10 = 5;
            }
            if (finalres >= 21 &&
    ...
    See more | Go to post

  • nebula53
    started a topic Error running my ASP.net application

    Error running my ASP.net application

    I created ASP.net a web evaluation page with c# using visual studio 2010, when I tried to upload it to my company server it did note work the error I received is,


    Configuration Error
    Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

    Parser Error...
    See more | Go to post

  • nebula53
    started a topic How to Export Report to Excel.

    How to Export Report to Excel.

    Hi,

    1 - I created search criteria based in one input ( contract status “ Combo box”)
    I need to add to it another criteria (Vendor Number “ text Box” ) ( the number will be entered manually )

    This is the Code in the Search button.

    Code:
    Dim strCriteria As String
    Dim strReportName As String
      
    strCriteria = "[Contract Status]='" & Me![Contract Status] & "'"
    ...
    See more | Go to post

  • nebula53
    replied to Combo Box Search Criteria
    NeoPa
    Thank you for the explanation, its helps to understand more.
    See more | Go to post

    Leave a comment:


  • nebula53
    replied to Combo Box Search Criteria
    colintis

    I appreciate your help its working fine. Thanks
    See more | Go to post

    Leave a comment:


  • nebula53
    replied to Combo Box Search Criteria
    There is one thing I need to add

    I need to set the Combo box to (Select) as default and If I didn’t chose any of the other criteria ( Active, inactive) then the report should show all of the information in the table



    Code:
    Dim strCriteria As String
    Dim strReportName As String
      
    strCriteria = "[Contract Status]='" & Me![Contract Status] & "'"
    strReportName
    ...
    See more | Go to post

    Leave a comment:


  • nebula53
    replied to Combo Box Search Criteria
    mshmyob

    thank you for your help I really appreciate it
    See more | Go to post

    Leave a comment:


  • nebula53
    replied to Combo Box Search Criteria
    Please find the attached to understand the concept...
    See more | Go to post

    Leave a comment:


  • nebula53
    replied to Combo Box Search Criteria
    Jim there where Typo error when I copied the message.
    See more | Go to post

    Leave a comment:


  • nebula53
    replied to Combo Box Search Criteria
    The Combo box name is correct, when I changed the Me! To ME.
    I received this Error message (Method or Data member not found)
    See more | Go to post

    Leave a comment:


  • nebula53
    replied to Combo Box Search Criteria
    Private Sub Command141_Clic k()

    Dim strCriteria As String
    Dim strReportName As String

    strCriteria = "[Status]='" & Me!ContractStat us & "'"
    strReportName = "PMCONTRACT S"

    DoCmd.OpenRepor t PMCONTRACTS, acViewNormal

    End Sub

    the error is ( 2465 : Microsoft office can't find the field ' ContractsStstus ' referred to in your ...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...