Search Results - VBForums

Search:

Type: Posts; User: Jagjit

Page 1 of 10 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    3
    Views
    142

    Presence of Train on Rail WeighBridge

    Hi

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

    Thanks
  2. Replies
    5
    Views
    187

    Re: In Motion Weighing

    Hi Datamiser

    Do you have any sample or logic for this
  3. Replies
    5
    Views
    187

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

    by Jagjit
    Replies
    16
    Views
    314

    Re: Time Difference

    Hi Arnoutdv

    Is there any way . Kindly suggest

    Thanks
  5. Thread: Time Difference

    by Jagjit
    Replies
    16
    Views
    314

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

    by Jagjit
    Replies
    16
    Views
    314

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

    by Jagjit
    Replies
    16
    Views
    314

    Re: Time Difference

    no it is new
  8. Thread: Time Difference

    by Jagjit
    Replies
    16
    Views
    314

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

    by Jagjit
    Replies
    16
    Views
    314

    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....
  10. Replies
    2
    Views
    150

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

    by Jagjit
    Replies
    2
    Views
    147

    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...
  12. Replies
    6
    Views
    170

    Re: Automatic Detection

    Hi Arnoutdv

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

    Thanks
  13. Replies
    6
    Views
    170

    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
  14. Replies
    6
    Views
    170

    Re: Automatic Detection

    Hi Arnoutdv

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

    Thanks
  15. Replies
    6
    Views
    170

    Automatic Detection

    Hi

    How we can automatically detect Engine & Wagon of train .

    Thanks
  16. Thread: Time Difference

    by Jagjit
    Replies
    19
    Views
    391

    Re: Time Difference

    Hi techgnome

    Thanks
  17. Thread: Time Difference

    by Jagjit
    Replies
    19
    Views
    391

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

    by Jagjit
    Replies
    19
    Views
    391

    Re: Time Difference

    Hi Zvoni

    I want time difference in Hours

    Thanks
  19. Thread: Time Difference

    by Jagjit
    Replies
    19
    Views
    391

    Re: Time Difference

    Hi

    I want time difference between current time & database field

    Thanks
  20. Thread: Time Difference

    by Jagjit
    Replies
    19
    Views
    391

    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
  21. Replies
    7
    Views
    343

    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...
  22. Replies
    4
    Views
    359

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

    by Jagjit
    Replies
    4
    Views
    208

    Time

    Hi

    How to subtract 6 Hrs from time.

    Thanks
  24. Thread: View Data

    by Jagjit
    Replies
    2
    Views
    171

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

    by Jagjit
    Replies
    9
    Views
    300

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

    by Jagjit
    Replies
    9
    Views
    300

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

    by Jagjit
    Replies
    9
    Views
    300

    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...
  28. Thread: Data to Tally

    by Jagjit
    Replies
    7
    Views
    346

    Re: Data to Tally

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

    by Jagjit
    Replies
    7
    Views
    346

    Data to Tally

    Hi

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

    Thanks
  30. 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
  31. Re: unknown error 70 - Permission Denied

    Hi Nightwalker83

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

    Thanks
  32. 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
  33. Re: unknown error 70 - Permission Denied

    Hi Nightwalker83

    This is the code , before fn excel sheet is created . What i feelis error is coming while killing file . What should i do

    fn = filename
    If Dir(fn) <> ""...
  34. [RESOLVED] unknown error 70 - Permission Denied

    Hi

    I have written the below code , it gives me above error.
    File is saved on local computer but when i try to save on Network Computer this error comes.
    Secondly when i check for file exists...
  35. Replies
    4
    Views
    273

    Re: Error on Creating Excel File

    m_var is "abc"
  36. Replies
    11
    Views
    567

    Re: [RESOLVED] Automatically copy

    Hi

    Secondly i want if file exists in Target Folder it should overwrite

    Thanks
  37. Replies
    11
    Views
    567

    Re: [RESOLVED] Automatically copy

    Hi Miser

    What i need to change

    filename = "e:\" & "abx.xls"
    dfolder = "\\comp1\Shared Folder\"

    filecopy filename,dfolder

    Thanks
  38. Replies
    11
    Views
    567

    Re: Automatically copy

    Hi

    I have written below code but it gives me this error , 'Unknown Error 70 " Permission denied

    FileCopy filename, dfolder

    dfolder = "\\comp1\Shared Folder\"

    ...
  39. Replies
    2
    Views
    303

    [RESOLVED] Copy File

    Hi

    How to copy file from local computer to shared folder on network using vb code

    Thanks
  40. Replies
    4
    Views
    273

    Error on Creating Excel File

    Hi

    In the below code i am trying to save file on network computer shared folder. But it gives me error :- Method '~' of object '~' failed.

    dim filename as string
    filename =...
Results 1 to 40 of 398
Page 1 of 10 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.