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!

  • Congratulations Chris Miller 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: lilal111
  • Order by date
  1. lilal111

    Validating to ensure user selects an integer.

    Where would I institute this code? Would it be possible to place it in the while loop? Thanks Al
  2. lilal111

    Validating to ensure user selects an integer.

    I am working on a project and am stuck on something. The project calculates sales commissions from a company. The user inputs the persons first name,last name and then it prompts to collect the amounts of items sold in a variable called input. I am stuck on how to validate to ensure the...
  3. lilal111

    List box summary

    I have an application that has two list boxes, lstbox1 and lstbox2. lstbox1 allows the user to select items from lstbox1 and place them into lstbox2 .I would like to know if its possible to summarize the specific amounts of items individually from lstbox2? For Example: lstbox1...
  4. lilal111

    Populate a second listbox

    Hi there, I have actually figured it out with a bit of research. Here is a sample of the code I have used to make it work. This is under the click button for adding to list box If lstbox1.SelectedIndex > -1 Then lstbox2.Items.Add(lstbox1.Text) Else...
  5. lilal111

    Populate a second listbox

    I know it does not make much sense. It is not a real business case,it is an exercise. When the add button is clicked, items from lstbox1 should be added and displayed in lstbox2. The user should be able to select as many items as he wants and any number of one item can be added. thanks.
  6. lilal111

    Populate a second listbox

    I am currently using two listboxes (lstbox1 and lstbox2). My objective is to be able to select the same item mulitple times and populate that item in lstbox2 without it being removed from lstbox1 Example lstbox1 listbox2 apples apples oranges apples grapes...
  7. lilal111

    Message showing last item in a list box

    I am using a button to remove items from a list box. How do I create a message saying something like" This is the last item in the list" Thanks.
  8. lilal111

    populating a list box from an array

    I have a listbox(lstBox1) that I am clearing as part of a clear routine. Then I am trying to use the following array to populate the listbox again: Dim strlstMajor() As String = {"Geography", "Math", "Chemistry", "Physics"} Any help would be greatly appreciated!! Thanks!!!!
  9. lilal111

    migrating excel information into a sql server table

    I was asked if it is possible to use Microsoft Excel to input information into a table in SQL Server 2008. We have a Project Manager that is trying to use Excel as an interface to populate Assigned Hours and Estimated Hours. Any help would be so appreciated!!Thanks!!
  10. lilal111

    Using Excel 2010 to input information into SQL Server 2008

    I was asked if it is possible to use Microsoft Excel to input information into a table in SQL Server 2008. We have a Project Manager that is trying to use Excel as an interface to populate Assigned Hours and Estimated Hours. Any help would be so appreciated!! Thanks!!
  11. lilal111

    Problem with subreport and conditional formatting.

    Thank you very much Ibas !!!! it worked really well!
  12. lilal111

    Problem with subreport and conditional formatting.

    i am trying to compare two values in a report. One is a summary of hours called assigned hours and the other is actual hours. The actual hours is a subreport that is linked to the project and client. These are both placed in the details section of the report. What I am trying to accomplish is...
  13. lilal111

    Extracting numerical value from a varchar field

    I am working with an SQL Server Database that has a field name customvalue. This is a varchar field and has everything from text, dates, numbers ect... in it. I am trying to extract only the numerical values from the field. employee customvalue 112 12 112 13 112 JOE...
  14. lilal111

    SUMMING THE HOURS BY PROJECT, EMPLOYEE

    Thank you so much. I was stumbling on the context of the sql statement. I really appreciate it!!
  15. lilal111

    SUMMING THE HOURS BY PROJECT, EMPLOYEE

    I am trying to create a procedure in sql server 2008 that summarizes the hours by employee and project in one line from the following. For Example adding all the hours for project 1913 by employee in one line to say and so on. I would appreciate any help with this. Thanks!! project hrs...
  16. lilal111

    Suppressing data

    Thank you very much, this worked great....You made my day!!
  17. lilal111

    Suppressing data

    I am currently using a report with a sub report. I am trying to suppress the data in the sub report where it already exists in the main report between the two fields and only show the fields that don't match. Pardon the crude example below, but in essence it is what I am trying to accomplish...
  18. lilal111

    Uppercase month field

    I am trying to use the uppercase command with a datefield. I am trying to capitalize the Feb portion below. Could someone help me out? Example.... 08 Feb 09

Part and Inventory Search

Back
Top