CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: dr223

Page 1 of 8 1 2 3 4

Search: Search took 0.03 seconds.

  1. Thread: JOIN Tables

    by dr223
    Replies
    2
    Views
    1,003

    Re: Compare Fields

    Sorry My mistake ..

    What I meant was the comparison between the two fields, and that should yield the results as shown above..

    Thanks
  2. Thread: JOIN Tables

    by dr223
    Replies
    2
    Views
    1,003

    JOIN Tables

    Hi,

    I have 2 tables TableA and TableB

    TableA


    MedicalCodeID EmisCode ReadCode
    1 EMISATT NULL
    2 NULL PCSDT
  3. Replies
    1
    Views
    1,435

    Expression Expected

    Hi,

    On my form I have a button on the click event; I have the following code;


    Process.Start("C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE"...
  4. Replies
    1
    Views
    2,351

    Application.FileSearch

    Hi,

    I am working with Microsoft Access 2010. I have an application which was developed in Access 2003 and is using the Application.FileSearch command.

    This command is not present in Access2010...
  5. Thread: Error Message

    by dr223
    Replies
    1
    Views
    1,133

    Error Message

    Hi,

    I have changed a data type of a field (fieldsize) from int to Bigint.

    Now, the problem is it generated the following error:

    Microsoft VBScript runtime error '800a000d'

    Type mismatch
  6. Thread: Update Statement

    by dr223
    Replies
    1
    Views
    998

    Update Statement

    Hi,

    I want to update my statement to read 2 values from what is available -

    1) user_full_name (concatenation of firstname and lastname) eg., firstname = John lastname= Smith user_full_name =...
  7. Thread: Send Email -

    by dr223
    Replies
    3
    Views
    1,524

    Send Email -

    Hi,

    I have the following code;


    Private Function findauthoremail(ByVal name As String) As String

    Dim ConString As String =...
  8. Thread: Checkbox value

    by dr223
    Replies
    2
    Views
    1,188

    Checkbox value

    Hi,

    Why when I click the checkbox and submit it stills submit a False value?

    Thank you



    Try
    query = "UPDATE TblChangeControlDet SET PeerRvwApp=@PeerRvwApp WHERE...
  9. Replies
    0
    Views
    887

    Duplicate values on dropdownlist

    Hi,

    I am having the follwing code;



    Try

    Dim PeerValue As New System.Data.SqlClient.SqlCommand(("Select PeerRvw From dbo.TblChangeControlDet WHERE ChangeID=@ChangeID"), conn)...
  10. Replies
    5
    Views
    4,727

    Re: Must declare a scalar variable

    please tell how to do it in one SQL update statement..


    Many thanks
  11. Replies
    5
    Views
    4,727

    Re: Must declare a scalar variable

    Ok Changed it to;



    nextconn.Open()

    Dim query As String

    Dim cmdB As New System.Data.SqlClient.SqlCommand(("Select RefNo From dbo.QryRefNo WHERE ChangeRaisedDate =...
  12. Replies
    5
    Views
    4,727

    Must declare a scalar variable

    Hi,

    I have the following code;


    Dim query As String
    Dim RefID As New System.Data.SqlClient.SqlCommand(("Select RefNo From dbo.QryRefNo WHERE ChangeRaisedDate = @ChangeRaisedDate"),...
  13. Replies
    7
    Views
    2,288

    Re: Error Prompted at RunTime

    Tried;



    Protected Sub btnsubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnsubmit.Click

    Dim strConn As String

    strConn =...
  14. Replies
    7
    Views
    2,288

    Re: Error Prompted at RunTime

    Tried that it gave same error message.

    Even tried to create another string;

    Dim nextconn As New SqlConnection(strConn)

    Then I opened and closed same location as you did in bold.

    Same...
  15. Replies
    7
    Views
    2,288

    Re: Error Prompted at RunTime

    How can you do the first one please
  16. Replies
    7
    Views
    2,288

    Error Prompted at RunTime

    Hi,

    I have the following code;



    Protected Sub btnsubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnsubmit.Click

    Dim strConn As String
  17. Thread: Datagridviews

    by dr223
    Replies
    1
    Views
    648

    Datagridviews

    Hi,

    I have a datagridview (DgvProductDet) it has 5 columns (data bounded)

    TruckModel
    ProductName
    Quantity
    Priceperitem
    Buy Now (Button Click)
  18. Replies
    1
    Views
    1,687

    Refresh Combo Box

    Hi,

    At button click on my form I have the code;


    Private Sub BtnChk_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnChk.Click


    ...
  19. Thread: Combo Boxes

    by dr223
    Replies
    4
    Views
    1,078

    Re: Combo Boxes

    It didnt work!!

    I even tried


    If CmbTruckTyp.SelectedIndex > -1 Then

    It never gives any error, however, both comboxes are visible regardless of "Daf" or "MEercedes-Benz" being selected.....
  20. Thread: Combo Boxes

    by dr223
    Replies
    4
    Views
    1,078

    Combo Boxes

    Hi,

    The following code gives an error - at run time

    InvalidCastException was unhandled
    Operator '=' is not defined for type 'DatarowView' and 'Nothing'


    If Not...
  21. Thread: Button Click

    by dr223
    Replies
    1
    Views
    648

    Button Click

    Hi,

    I have a button on click event I have the following code;



    Private Sub BtnChk_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnChk.Click

    If...
  22. Thread: Update Statement

    by dr223
    Replies
    3
    Views
    693

    Update Statement

    Hi,

    I receive the error -

    Incorrect syntax
    Unclosed syntax near 's'
    Unclosed quotation mark after character string ".


    query = "UPDATE dbo.TblPracExclude SET " & _
  23. Thread: Datagridview

    by dr223
    Replies
    1
    Views
    760

    Datagridview

    Hi,

    I have a datagridview (DgvPracExcl), on it I have a bounded field with a design name 'Notes' and columntype: DatagridviewTextBoxColumn.

    At runtime a user can type in text on this textbox...
  24. Replies
    5
    Views
    1,562

    Create a History table

    Hi,

    I have a datagridview (DgvPracExcl) which at runtime allows a user to update the records to a table in the database.

    Now, I want to save a history prior to the update. Therefore, create a...
  25. Thread: Sorting Data

    by dr223
    Replies
    0
    Views
    425

    Sorting Data

    Hi,

    I have a form with a datagridview - on form load I have;


    Dim irown As Integer
    For irown = 0 To DgvPracExcl.Rows.Count - 1
    DgvPracExcl.Rows(irown).Cells(0).ReadOnly...
Results 1 to 25 of 192
Page 1 of 8 1 2 3 4





Click Here to Expand Forum to Full Width

Featured