Search Results - VBForums

Search:

Type: Posts; User: Jagjit

Page 1 of 11 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    5
    Views
    134

    Re: Method Open of Object_Recordset failed

    Hi

    Sorry I am using MS-Access
  2. Replies
    5
    Views
    134

    Method Open of Object_Recordset failed

    Hi

    Below code gives above error

    Dim rs As New ADODB.Recordset
    rs.Open "SELECT * FROM tblMembers Order by cast(Student_ID as int) ", cnn1, adOpenStatic, adLockReadOnly

    Thanks
  3. Thread: Index Records

    by Jagjit
    Replies
    4
    Views
    137

    Index Records

    Hi

    I have field studentid as text. I want that records should be ordered by studentid. Records are like this
    1,2,3,4,5,6,7,8,9,10,11,12 & so on . But it is displaying like this...
  4. Thread: Enter & Tab Key

    by Jagjit
    Replies
    9
    Views
    162

    Re: Enter & Tab Key

    message is not printed
  5. Thread: Enter Key

    by Jagjit
    Replies
    1
    Views
    102

    Enter Key

    Hi

    I have written the below code but when user presses Enter it is not going into the next field.

    Private Sub txtfirstname_keypress(KeyAscii As Integer)
    If KeyAscii = vbKeyReturn Then
    ...
  6. Thread: Enter & Tab Key

    by Jagjit
    Replies
    9
    Views
    162

    Enter & Tab Key

    Hi

    I have written the below code . If user enters ID & press tab key it is not going in the below if condition
    It is going only if Enter Key is pressed. I want that it should go in this...
  7. Replies
    2
    Views
    110

    Error 94 Invalid use of null

    Hi

    I have written the below query . Firstname & middlename are not blank . On this line it gives me error
    .TextMatrix(r, 2) = LTrim(RTrim(irec.Fields("mname")))


    sSQL = "select...
  8. Thread: No of Records

    by Jagjit
    Replies
    4
    Views
    133

    Re: No of Records

    yes. i have recreated the field & it is working
  9. Thread: No of Records

    by Jagjit
    Replies
    4
    Views
    133

    No of Records

    Hi

    I gave written the below query but it is returning no record whereas there are 2 records. Value in txtid is 1. Student Id is a string value
    When I remove the trim(txtid.text) condition then...
  10. Replies
    0
    Views
    118

    Image from Camera

    Hi

    I want to take photo of Vehicle No of vehicle from Front & Back . Which camera's are suitable . TCP/IP or Lan based. I have to same image in our software

    Thanks
  11. Replies
    4
    Views
    144

    How to get Quotient & Remainder

    Hi

    How to get Quotient & Remainder. If 3 is to be divided by 5

    Thanks
  12. Replies
    6
    Views
    192

    Background Image on MDI Form

    Hi

    How to display Background Image on MDI form & expand according to form size

    Thanks
  13. Replies
    1
    Views
    104

    Enter Key on Text Box

    Hi

    I want that instead of Tab Keys , enter key should behave like Tab Key

    Thanks
  14. Replies
    6
    Views
    192

    Re: Disable Tab on TextBox

    Hi

    I am getting runtime error . Permission Denied. Below is the code

    If (KeyAscii = vbKeyReturn) Then
    Set rsfind = New ADODB.Recordset
    If rsfind.State = 1 Then rsfind.Close...
  15. Replies
    6
    Views
    192

    Disable Tab on TextBox

    Hi

    I have textbox i want that when user press Tab or Enter Key it should perform same task

    Thanks
  16. Thread: Like in Query

    by Jagjit
    Replies
    3
    Views
    119

    Like in Query

    hi

    I have written the below code
    sQuery = "select book_id,title,author,no_request from tblbooksrequest where title like '%" & Trim$(TxtSearch.Text) & "%' order by book_id ;"
    ...
  17. Replies
    3
    Views
    175

    Re: Number Plate Through Camera

    Hi Arnoutdv

    Cameras may be installed at fixed location. They may be given TCP/IP . I cannot move camera . So how user will select that only Number Plate picture is taken.

    Thanks
  18. Replies
    3
    Views
    175

    Number Plate Through Camera

    Hi

    I want to get picture of Vehicle Number plate. Can anyone give idea how it can be done.

    Thanks
  19. Thread: Query

    by Jagjit
    Replies
    3
    Views
    193

    Re: Query

    Hi

    With Keyascii i am checking that only alphanumeric values are entered. Strglobal is a global variable as string.

    Public Sub shbook(MSFlxGd As MSFlexGrid)
    Dim r As Integer
    Dim irec As...
  20. Thread: Query

    by Jagjit
    Replies
    3
    Views
    193

    Query

    Hi

    I have written the below code . I want as user presses any character in txttitle textbox records should be displayed in flexgrid according to that

    Private Sub txttitle_keypress(KeyAscii As...
  21. Connection cannot be used to perform this operation

    Hi

    Error - connection cannot be used to perform this operation . It is either closed or invalid in this context.

    cnn2.ConnectionString = "Provider=MSDataShape.1;Data...
  22. Replies
    2
    Views
    115

    Sql Statement Error

    Hi

    Below statement is giving error
    str = "insert into tblUsers (userid,password) values ('admin','" & pwd & "')"

    Thanks
  23. Replies
    5
    Views
    236

    Runtime Error 30015

    Hi

    I have written he below code . It is giving me error Runtime Error 30015 Cannot remove last non-fixed row.

    Private Sub MSFlxGd_DblClick()
    MSFlxGd.RemoveItem MSFlxGd.RowSel
    End Sub
    ...
  24. Replies
    2
    Views
    197

    [RESOLVED] Index out of Bounds

    Hi

    In the below code it is giving me error on this line
    If lvwreturn.ListItems(intcount).Checked = True Then

    There are 2 records in ListView

    For intcount = 0 To lvwreturn.ListItems.Count...
  25. Replies
    1
    Views
    174

    [RESOLVED] ListView

    Hi

    I have written the below code . I want to get data from 2 tables & display them in listview with each row having checkbox

    Set rsfind = New ADODB.Recordset
    If rsfind.State = 1 Then...
  26. Thread: Sorting

    by Jagjit
    Replies
    7
    Views
    242

    Sorting

    Hi

    I have Text field . Data is stored like this.

    B1,B2,B3,B4,B5,B6,B7,B8,B9,B10,B11,B12,B20 . When i gave Order By then it shows like below

    B1,B10,B11,B12,B2,B20 etc

    But i wanted it...
  27. Thread: Sql Statement

    by Jagjit
    Replies
    2
    Views
    138

    Sql Statement

    Hi

    Below Sql Statement is giving me error when i added this code

    inner join tblbooks t2 on t1.book_id = t2.book_id

    Dim rs As New ADODB.Recordset

    rs.Open "SELECT * FROM tblmaster...
  28. Thread: Datagrid

    by Jagjit
    Replies
    11
    Views
    285

    Datagrid

    Hi

    I have command button & i want when clicked another form should open in which Data is displayed & when user double clicks on Datagrid row it should return values to parent form.

    Thanks
  29. Replies
    4
    Views
    239

    Presence of Train on Rail WeighBridge

    Hi

    Is there any sample code available how to detect the presence of train on Rail WeighBridge.

    Thanks
  30. Replies
    5
    Views
    225

    Re: In Motion Weighing

    Hi Datamiser

    Do you have any sample or logic for this
  31. Replies
    5
    Views
    225

    In Motion Weighing

    hi

    Does anyone has any idea how to weigh in motion vehicles like train etc. How to detect speed & direction of train.

    Thanks
  32. Thread: Time Difference

    by Jagjit
    Replies
    16
    Views
    401

    Re: Time Difference

    Hi Arnoutdv

    Is there any way . Kindly suggest

    Thanks
  33. Thread: Time Difference

    by Jagjit
    Replies
    16
    Views
    401

    Re: Time Difference

    Hi

    I am trying like this but it is giving me error "Type MisMatch"

    Dim dt1 As Date
    dt1 = Format(rs1.Fields("gtime"), "hh:mm:ss")
    dt1 = DateValue(rs1.Fields("gdt")) & dt1
    ...
  34. Thread: Time Difference

    by Jagjit
    Replies
    16
    Views
    401

    Re: Time Difference

    Hi Techgnome

    Can you please guide me if i want to separate DatePart from GDate & Time from Gtime then storing their value in another datetime variable.

    Thanks
  35. Thread: Time Difference

    by Jagjit
    Replies
    16
    Views
    401

    Re: Time Difference

    no it is new
  36. Thread: Time Difference

    by Jagjit
    Replies
    16
    Views
    401

    Re: Time Difference

    Hi Techgnome

    I have 2 fields in Database : GDate & GTime. In Gdate only date is stored 2015-02-18 00:00:00:000 & Gtime it is stored as 1900-01-01 14:37:11:000. How i should combine the 2 fields...
  37. Thread: Time Difference

    by Jagjit
    Replies
    16
    Views
    401

    Time Difference

    Hi

    Below is the code. Yesterday i have done entry in the afternoon. Gross Time is 1900-01-01 14:37:11

    Now in the morning i have done entry . ServerTime is 10:16:26 . It is showing hrs as -4....
  38. Replies
    2
    Views
    184

    [RESOLVED] Difference in Hours

    Hi


    MsgBox DateDiff("h", rs0.Fields("gtime"), ServerTime)

    GTime is a database field . Value Gtime is showing 1900-01-01 14:37:11
    Servertime showing value 14:43:33

    Result is showing -48 ....
  39. Thread: Query

    by Jagjit
    Replies
    2
    Views
    183

    Query

    Hi

    I have database which has fields ID,Customer,Vehicle No, Date&Time field . When a user enters data & Vehicle No Field i want that it should search database with that Vehicle No & display the...
  40. Replies
    6
    Views
    210

    Re: Automatic Detection

    Hi Arnoutdv

    I will revert back later . What i know Track Switches are installed & there are 2 Comm Ports .

    Thanks
Results 1 to 40 of 426
Page 1 of 11 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.