Search Results - VBForums

Search:

Type: Posts; User: Jagjit

Page 1 of 10 1 2 3 4

Search: Search took 0.02 seconds.

  1. Thread: Time Difference

    by Jagjit
    Replies
    19
    Views
    245

    Re: Time Difference

    Hi techgnome

    Thanks
  2. Thread: Time Difference

    by Jagjit
    Replies
    19
    Views
    245

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

    by Jagjit
    Replies
    19
    Views
    245

    Re: Time Difference

    Hi Zvoni

    I want time difference in Hours

    Thanks
  4. Thread: Time Difference

    by Jagjit
    Replies
    19
    Views
    245

    Re: Time Difference

    Hi

    I want time difference between current time & database field

    Thanks
  5. Thread: Time Difference

    by Jagjit
    Replies
    19
    Views
    245

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

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

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

    by Jagjit
    Replies
    4
    Views
    185

    Time

    Hi

    How to subtract 6 Hrs from time.

    Thanks
  9. Thread: View Data

    by Jagjit
    Replies
    2
    Views
    153

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

    by Jagjit
    Replies
    9
    Views
    273

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

    by Jagjit
    Replies
    9
    Views
    273

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

    by Jagjit
    Replies
    9
    Views
    273

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

    by Jagjit
    Replies
    7
    Views
    319

    Re: Data to Tally

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

    by Jagjit
    Replies
    7
    Views
    319

    Data to Tally

    Hi

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

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

    Hi Nightwalker83

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

    Thanks
  17. 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
  18. 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) <> ""...
  19. [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...
  20. Replies
    4
    Views
    253

    Re: Error on Creating Excel File

    m_var is "abc"
  21. Replies
    11
    Views
    547

    Re: [RESOLVED] Automatically copy

    Hi

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

    Thanks
  22. Replies
    11
    Views
    547

    Re: [RESOLVED] Automatically copy

    Hi Miser

    What i need to change

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

    filecopy filename,dfolder

    Thanks
  23. Replies
    11
    Views
    547

    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\"

    ...
  24. Replies
    2
    Views
    263

    [RESOLVED] Copy File

    Hi

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

    Thanks
  25. Replies
    4
    Views
    253

    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 =...
  26. Replies
    1
    Views
    143

    Append Record in Excel when saving data

    Hi

    I am inserting record in Sql Database . I want when i save record it should also append record in Excel file also.


    Thanks
  27. Re: Error : Microsoft Office Excel cannot open or save any more documents

    Hi

    There is enough disk space
    Records cannot be more than 200
    System has 2 G.B memory

    Thanks
  28. Re: Error : Microsoft Office Excel cannot open or save any more documents

    Hi

    Dim filename as string
    filename = "d:\" & txt_no.Text & ".xls"
  29. Error : Microsoft Office Excel cannot open or save any more documents

    Hi

    I am exporting report to excel like this

    Dim xlApp As Excel.Application
    Dim xlBook As Excel.Workbook
    Dim xlSheet As Excel.Worksheet

    Set xlApp = New Excel.Application
    ...
  30. Replies
    6
    Views
    794

    [RESOLVED] Maximum Interval of Timer

    Hi

    what is the maximum interval of timer . If i want that it should execute after 15 minutes , is it possible.

    Thanks
  31. Replies
    1
    Views
    391

    [RESOLVED] Timer

    Hi

    I have timer on MDI form & some code written . I want if error occurs it should stop , it should not execute further

    Thanks
  32. Replies
    2
    Views
    319

    [RESOLVED] Password Protect Excel File

    Hi

    I have written this but it is not working

    Dim xlApp As Excel.Application
    Dim xlBook As Excel.Workbook
    Dim xlSheet As Excel.Worksheet

    Set xlApp = New Excel.Application
    Set xlBook =...
  33. Replies
    7
    Views
    2,366

    Re: password protect excel file

    Hi

    I have written this but it is not working

    Dim xlApp As Excel.Application
    Dim xlBook As Excel.Workbook
    Dim xlSheet As Excel.Worksheet

    Set xlApp = New Excel.Application...
  34. Thread: Excel File

    by Jagjit
    Replies
    1
    Views
    191

    Excel File

    Hi

    I am creating Excel Sheet through coding . I want it to be password protected when file being generated.

    Thanks
  35. Thread: Menu Editor

    by Jagjit
    Replies
    2
    Views
    231

    Menu Editor

    Hi

    How we can create pop using menu editor in non-mdi form

    Thanks
  36. Replies
    1
    Views
    178

    Printout Authentication

    Hi

    I am taking a printout of Slip . How i can authenticate that it has been generated through software. Slip can be easily created in Microsoft Word etc.

    Thanks
  37. Thread: Valid Check

    by Jagjit
    Replies
    3
    Views
    303

    Valid Check

    Hi

    I want only alphabets,numeric,space should be entered in text box , anything else should be invalid

    Thanks
  38. Replies
    3
    Views
    327

    [RESOLVED] Email

    Hi

    Can we send email using vb6 & attaching file.

    Thanks
  39. Replies
    5
    Views
    290

    Connection State

    Hi

    I have written the below code in MDI Form . Suppose while doing transactions system disconnects from network , below code still shows cnn2.state = 1 . How i should check in between whether...
  40. Replies
    4
    Views
    283

    Re: Server Connection

    Hi Datamiser

    can you help me with code what it should be

    Thanks
Results 1 to 40 of 383
Page 1 of 10 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.