Search Results - VBForums

Search:

Type: Posts; User: Jagjit

Page 1 of 10 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    7
    Views
    253

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

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

    by Jagjit
    Replies
    4
    Views
    160

    Time

    Hi

    How to subtract 6 Hrs from time.

    Thanks
  4. Thread: View Data

    by Jagjit
    Replies
    2
    Views
    130

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

    by Jagjit
    Replies
    9
    Views
    231

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

    by Jagjit
    Replies
    9
    Views
    231

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

    by Jagjit
    Replies
    9
    Views
    231

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

    by Jagjit
    Replies
    7
    Views
    274

    Re: Data to Tally

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

    by Jagjit
    Replies
    7
    Views
    274

    Data to Tally

    Hi

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

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

    Hi Nightwalker83

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

    Thanks
  12. 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
  13. 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) <> ""...
  14. [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...
  15. Replies
    4
    Views
    226

    Re: Error on Creating Excel File

    m_var is "abc"
  16. Replies
    11
    Views
    503

    Re: [RESOLVED] Automatically copy

    Hi

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

    Thanks
  17. Replies
    11
    Views
    503

    Re: [RESOLVED] Automatically copy

    Hi Miser

    What i need to change

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

    filecopy filename,dfolder

    Thanks
  18. Replies
    11
    Views
    503

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

    ...
  19. Replies
    2
    Views
    228

    [RESOLVED] Copy File

    Hi

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

    Thanks
  20. Replies
    4
    Views
    226

    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 =...
  21. Replies
    1
    Views
    129

    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
  22. 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
  23. Re: Error : Microsoft Office Excel cannot open or save any more documents

    Hi

    Dim filename as string
    filename = "d:\" & txt_no.Text & ".xls"
  24. 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
    ...
  25. Replies
    6
    Views
    741

    [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
  26. Replies
    1
    Views
    367

    [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
  27. Replies
    2
    Views
    288

    [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 =...
  28. Replies
    7
    Views
    2,217

    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...
  29. Thread: Excel File

    by Jagjit
    Replies
    1
    Views
    184

    Excel File

    Hi

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

    Thanks
  30. Thread: Menu Editor

    by Jagjit
    Replies
    2
    Views
    206

    Menu Editor

    Hi

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

    Thanks
  31. Replies
    1
    Views
    164

    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
  32. Thread: Valid Check

    by Jagjit
    Replies
    3
    Views
    286

    Valid Check

    Hi

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

    Thanks
  33. Replies
    3
    Views
    309

    [RESOLVED] Email

    Hi

    Can we send email using vb6 & attaching file.

    Thanks
  34. Replies
    5
    Views
    278

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

    Re: Server Connection

    Hi Datamiser

    can you help me with code what it should be

    Thanks
  36. Replies
    4
    Views
    262

    [RESOLVED] Server Connection

    hi

    I have written the below code in MDI form . If network is dowm then sytem hangs for 15 seconds when the below code is trying to check connection to server . Is it possible that system should...
  37. Replies
    1
    Views
    229

    [RESOLVED] 2 connections

    Hi

    I have created 2 connections . One is for localhost & second is for server . I am using Sql server .

    What will be the state of server connection is system gets disconnected from network....
  38. Replies
    2
    Views
    239

    [RESOLVED] Connection Test

    Hi

    Below is my test connection . I want if it is successful it should return .T. else
    .F.

    Public Sub ConnectionTest()
    Set cnn2 = New ADODB.Connection
    On Error GoTo errhandler
    ...
  39. Replies
    2
    Views
    204

    Re: Connection to Server

    Hi szlamany

    It is taking more time if connection is failed , if it is connected then it is fast . How i can improve connection speed . It is taking more than 1 minute to give connection error...
  40. Thread: Localhost

    by Jagjit
    Replies
    0
    Views
    148

    Localhost

    Hi

    I want if connection to server fails then cnn2 should become localhost

    cnn2 is to connect to server

    If cnn2.State Then cnn2.Close
    cnn2.Open "Driver=SQL Server;Server=" & SvrName &...
Results 1 to 40 of 378
Page 1 of 10 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.