Search Results - VBForums

Search:

Type: Posts; User: Jagjit

Page 1 of 11 1 2 3 4

Search: Search took 0.03 seconds.

  1. 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...
  2. Replies
    2
    Views
    95

    Sql Statement Error

    Hi

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

    Thanks
  3. Replies
    5
    Views
    203

    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
    ...
  4. Replies
    2
    Views
    185

    [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...
  5. Replies
    1
    Views
    161

    [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...
  6. Thread: Sorting

    by Jagjit
    Replies
    7
    Views
    228

    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...
  7. Thread: Sql Statement

    by Jagjit
    Replies
    2
    Views
    125

    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...
  8. Thread: Datagrid

    by Jagjit
    Replies
    11
    Views
    276

    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
  9. Replies
    4
    Views
    230

    Presence of Train on Rail WeighBridge

    Hi

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

    Thanks
  10. Replies
    5
    Views
    205

    Re: In Motion Weighing

    Hi Datamiser

    Do you have any sample or logic for this
  11. Replies
    5
    Views
    205

    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
  12. Thread: Time Difference

    by Jagjit
    Replies
    16
    Views
    381

    Re: Time Difference

    Hi Arnoutdv

    Is there any way . Kindly suggest

    Thanks
  13. Thread: Time Difference

    by Jagjit
    Replies
    16
    Views
    381

    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
    ...
  14. Thread: Time Difference

    by Jagjit
    Replies
    16
    Views
    381

    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
  15. Thread: Time Difference

    by Jagjit
    Replies
    16
    Views
    381

    Re: Time Difference

    no it is new
  16. Thread: Time Difference

    by Jagjit
    Replies
    16
    Views
    381

    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...
  17. Thread: Time Difference

    by Jagjit
    Replies
    16
    Views
    381

    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....
  18. Replies
    2
    Views
    161

    [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 ....
  19. Thread: Query

    by Jagjit
    Replies
    2
    Views
    165

    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...
  20. Replies
    6
    Views
    194

    Re: Automatic Detection

    Hi Arnoutdv

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

    Thanks
  21. Replies
    6
    Views
    194

    Re: Automatic Detection

    I am also trying first time . There are 2 RS232 ports . I don't know how actually it is done. I want to get weight & direction
  22. Replies
    6
    Views
    194

    Re: Automatic Detection

    Hi Arnoutdv

    Basically i want ti get the weight of each wagon of in-motion train on rail weighbridge.

    Thanks
  23. Replies
    6
    Views
    194

    Automatic Detection

    Hi

    How we can automatically detect Engine & Wagon of train .

    Thanks
  24. Thread: Time Difference

    by Jagjit
    Replies
    19
    Views
    446

    Re: Time Difference

    Hi techgnome

    Thanks
  25. Thread: Time Difference

    by Jagjit
    Replies
    19
    Views
    446

    Re: Time Difference

    Hi Arnoudtv/Zvoni

    o.k but if i want that if diff in Hrs is greater than 5 it should give message & it it should display like Hours / Minutes . For ex if diff between 2 times is 2 Hrs & 30 min it...
  26. Thread: Time Difference

    by Jagjit
    Replies
    19
    Views
    446

    Re: Time Difference

    Hi Zvoni

    I want time difference in Hours

    Thanks
  27. Thread: Time Difference

    by Jagjit
    Replies
    19
    Views
    446

    Re: Time Difference

    Hi

    I want time difference between current time & database field

    Thanks
  28. Thread: Time Difference

    by Jagjit
    Replies
    19
    Views
    446

    Time Difference

    Hi

    I have DatetIme field . I want to subtract this field from Current Time & check the difference . I fit is greater than 6 Hrs it should give message.

    Thanks
  29. Replies
    7
    Views
    359

    Run Time Error 13 Type MisMatch

    Hi

    In the below code it is giving me the above error

    Private Sub lvwitem_ItemClick(ByVal Item As MSComctlLib.ListItem)
    Dim strItemKey As String
    Dim strId As String

    strItemKey...
  30. Replies
    4
    Views
    375

    Runtime Error 13 Type Mismatch

    Hi

    In the below code on the following line i am getting above error
    Set itmX = lvwitem.ListItems.Add(, "A" & rstitem("icode"))


    Set rstitem = New ADODB.Recordset
    SetStdListViewLayout1...
  31. Thread: Time

    by Jagjit
    Replies
    4
    Views
    215

    Time

    Hi

    How to subtract 6 Hrs from time.

    Thanks
  32. Thread: View Data

    by Jagjit
    Replies
    2
    Views
    176

    View Data

    Hi


    I have software that is connected to attendance machine . When the user swaps card his time & other data is saved . I want User name to be displayed on another computer's screen at same...
  33. Thread: Query

    by Jagjit
    Replies
    9
    Views
    311

    Re: Query

    Hi

    What about other fields Date From , Date To , Time From & Time To . It is not only one user input Customer. Is it not possible without if conditions.

    Thanks
  34. Thread: Query

    by Jagjit
    Replies
    9
    Views
    311

    Re: Query

    Hi Techgome

    Suppose user leaves customer field blank then what will be the query . I don't think it will be simple select statement

    Thanks
  35. Thread: Query

    by Jagjit
    Replies
    9
    Views
    311

    Query

    Hi

    I have 5 fields From Date , To Date , From Time , To Time , Customer . User can fill all the fields or leave some fields . What should be the query string . Database is SQL .

    For e.g...
  36. Thread: Data to Tally

    by Jagjit
    Replies
    7
    Views
    363

    Re: Data to Tally

    Tally is used for accounting in India
  37. Thread: Data to Tally

    by Jagjit
    Replies
    7
    Views
    363

    Data to Tally

    Hi

    Is it possible that data is MS-Access be exported to Tally using Vb

    Thanks
  38. Re: unknown error 70 - Permission Denied

    Hi

    This is the below code . I have written the first 4 lines before i start creating Excel Sheet.

    fn = filename
    If Dir(fn) <> "" Then Kill fn

    fn = dfolder
    If Dir(fn) <> "" Then Kill fn
  39. Re: unknown error 70 - Permission Denied

    Hi Nightwalker83

    I have resolved it . I check for file existence before creating file & it works

    Thanks
  40. Re: unknown error 70 - Permission Denied

    Hi

    I have commented the file existence part i.e kill . It is working fine . It is saving on local computer & network computer also .

    When i try to kill then above error comes.

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



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.