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!

Recent content by gazza75

  1. gazza75

    Combobox SelectedIndexChanged

    Hi I have a listbox that displays a list of employees. The list box is databound to a combobox. On selecting an employee from the listbox is changes the selected value in the combobox. The problem is that I want to activate some code when a different value is selected in the combobox by...
  2. gazza75

    Setting values

    Hi I am now doing the following below but is says that that there is no row at that position. I currently have 1 row in the datatable coming from the database and I am trying to add a second? Me.BindingContext(tEmployees).EndCurrentEdit()...
  3. gazza75

    Setting values

    Hi I have 3 tables in a sql server database. These are: tblEmployees tblEmployeeCosting tblUsers tblEmployees has a 1 to 1 relationship with the other 2 tables. I bring all 3 tables into the dataset and call them tEmployees tEmployeeCosting tUsers I then set-up default values for each of...
  4. gazza75

    Add to multiple tables

    Hi My stored procedure is setup to update the three tables. Here is a sample of my code: Private Sub fillDataSet() 'Create connection to database cn = New SqlConnection(connectionString) 'Create the sql statements to get the data from the database Dim...
  5. gazza75

    Add to multiple tables

    Hi I am trying a different approach, I am using 1 dataadapter to connect the 3 tables to the same dataset e.g. Dim sqlEmployees As String = "SELECT * FROM tblEmployees WHERE companyID LIKE @CompanyID; SELECT * FROM tblEmployeeCostingInfo; SELECT employeeID,userAccessLevel, userUsername...
  6. gazza75

    Add to multiple tables

    Thanks: CREATE PROCEDURE [spInsertTblEmployees] (@employeeID [int] OUTPUT, @companyid [int], @empNumber [varchar](50), @empActive [bit], @empType [varchar](10), @startDate [datetime], @leftDate [datetime], @title [varchar](10), @forename [varchar](30), @surname...
  7. gazza75

    Add to multiple tables

    Hi It returns a value okay it is just getting it into the child tables! Thanks Gary
  8. gazza75

    Add to multiple tables

    Hi I have 3 tables: tblEmployees tblEmployeeCostingInfo tblUsers tblEmployees has a one-to-one relationships with both tblEmployeeCostingInfo & tblUsers, they all have a field employeeID. I have a dataset that is filled by 3 seperate datatadapters. I created a stored procedure that updates...
  9. gazza75

    New to VS .Net - Application deployment missing keycodeV2.dll

    Hi I had this problem before and I think I solved it by adding the crystal licence key value to the RegWiz.msm in its properties. G
  10. gazza75

    Hi I have a subform called "frmS

    Hi I have a subform called "frmSUBFORM: Chargeable Project Expenses". In the parent form you can click a button that sets all the checkboxes in the subform to checked, I do this by changing the database values. The problem is when you manually press the checkbox in the subform an...
  11. gazza75

    expression is typed incorretly

    Hi I have a report that gives the user the option to run the report for all or just 1 Invoice, when i run it for 1 Invoice it works fine but when I run it for all I get the following error: This expression is typed incorretly, or is too complex to be evaluated My Query and Function are below...
  12. gazza75

    Query Order By

    Hi It is Date/Time! Thanks Gary
  13. gazza75

    Query Order By

    Hi My query will not appear in order of [05_TRAFFIC_RECORD_ENTRIES].TimeOfSailing, I cannot work it out. Any ideas? SELECT [04_TRAFFIC_RECORDS].DummyDateField, [04_TRAFFIC_RECORDS].Date, [04_TRAFFIC_RECORDS].VesselID, "*" AS VessCrit, [01_VESSELS].VesselName, "*" AS...
  14. gazza75

    Assigning values

    Hi The stored procedure below will not give jobFinalised the value of 0, what am I doing wrong? I even tried assigning the default value to 0 but it did not work either! JobFinalised is of type Bit. CREATE PROCEDURE spMoveJobToEstimate @nextEstimateNum int, @customerID int, @estId int...
  15. gazza75

    Databind Datagrid

    Help!!!!
See more

Part and Inventory Search

Back
Top