Search Results - VBForums

Search:

Type: Posts; User: Jagjit

Page 1 of 9 1 2 3 4

Search: Search took 0.03 seconds.

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

    Hi

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

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

    [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
  6. Replies
    2
    Views
    201

    [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 =...
  7. Replies
    7
    Views
    1,961

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

    by Jagjit
    Replies
    1
    Views
    115

    Excel File

    Hi

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

    Thanks
  9. Thread: Menu Editor

    by Jagjit
    Replies
    2
    Views
    144

    Menu Editor

    Hi

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

    Thanks
  10. Replies
    1
    Views
    119

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

    by Jagjit
    Replies
    3
    Views
    205

    Valid Check

    Hi

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

    Thanks
  12. Replies
    3
    Views
    220

    [RESOLVED] Email

    Hi

    Can we send email using vb6 & attaching file.

    Thanks
  13. Replies
    5
    Views
    217

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

    Re: Server Connection

    Hi Datamiser

    can you help me with code what it should be

    Thanks
  15. Replies
    4
    Views
    219

    [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...
  16. Replies
    1
    Views
    200

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

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

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

    by Jagjit
    Replies
    0
    Views
    126

    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 &...
  20. Replies
    2
    Views
    182

    Connection to Server

    Hi

    To connect to server below is the code . If due to some reasons server is down it takes a long time to give error message . I am using Sql Server 2008R2

    cnn2 is to connect to server

    If...
  21. Replies
    1
    Views
    139

    Connection To Server

    Hi

    To connect to server below is the code . If due to some reasons server is down it takes a long time to give error message

    cnn2 is to connect to server

    If cnn2.State Then cnn2.Close...
  22. Thread: StatusBar

    by Jagjit
    Replies
    2
    Views
    128

    StatusBar

    Hi

    I am looping through records , i want at run-time in 2 panels of StatusBar it should show Total No Of Records in one Panel & in Second Panel the record no of record which is being processed...
  23. Replies
    6
    Views
    334

    Connection with server

    Hi

    I want if connection with server is o.k then it should do some task i.e Insert statement else it should give message.

    If cnn2.State Then cnn2.Close
    ...
  24. Replies
    8
    Views
    356

    Re: Stored Procedure

    Dear szlamany

    O.k don't waste your time . i will send you the code

    Thanks
  25. Replies
    8
    Views
    356

    Re: Stored Procedure

    Hi

    I am using Sql Server 2008

    Thanks
  26. Replies
    8
    Views
    356

    Stored Procedure

    Hi

    I have stored procedure for insert . I want if record is successfully inserted or not it should display message in form.

    Thanks
  27. Replies
    10
    Views
    524

    Re: Server Time

    Hi

    Thanks dilettante
  28. Replies
    10
    Views
    524

    Re: Server Time

    Hi

    This is also not working , it gives error Type Mismatch
    I tried Servertime as date & string variable.

    ServerTime = cnn1.Execute("SELECT CONVERT(VARCHAR,getdate(),108)")

    Thanks
  29. Replies
    10
    Views
    524

    Re: Server Time

    Hi DataMiser

    But this is not working

    ServerDate = cnn1.Execute("Select GETDATE()")(0)
    ServerTime = Format(ServerDate, "h:mm:ss tt")

    Thanks
  30. Replies
    10
    Views
    524

    Re: Server Time

    Hi

    It may be date but i want time only

    Thanks
  31. Replies
    10
    Views
    524

    [RESOLVED] Server Time

    Hi

    i want to get only server time through stored procedure in visual basic 6

    Thanks
  32. Thread: Time Part

    by Jagjit
    Replies
    1
    Views
    150

    Time Part

    Hi

    What is wrong in the below code , i have written in module .Problem is in second line

    ServerDate = cnn1.Execute("Select GETDATE()")(0)
    ServerTime = Format(ServerDate, "h:mm:ss...
  33. Thread: DateTime field

    by Jagjit
    Replies
    0
    Views
    219

    DateTime field

    Hi

    I created 1 field Datetime in sql server 2008 R2 . I display in crystal reports to display Time it shows O.K . When i change datetime field to Time(0) in sql then time is not shown in Crystal...
  34. Replies
    1
    Views
    185

    [RESOLVED] Time Field

    Hi

    I have one field Time(0) in sql 2008 R2 . If time is 7:29 (IST) in ms-access it shows same 7:29:35 PM but in sql it stores as 19:29 . Why is it so . Secondly this does not show AM/PM in...
  35. Thread: DateTime Field

    by Jagjit
    Replies
    1
    Views
    127

    DateTime Field

    Hi

    System Time is 7:05 PM when i store in MS-Access it shows like 7:05:35 PM , but in SQL it saves as 19:05:13.0000000 . Why is it so . I want in sql also it shows like MS-Access

    Regional...
  36. Thread: DateTime field

    by Jagjit
    Replies
    2
    Views
    261

    DateTime field

    Hi

    I have datetime field in sql . I am using SQL server 2008 R2 . I have 1 dtpicker field , format is 2-dtptime . In Sql Database it does not store AM/PM .

    In VB textbox it displays AM/PM...
  37. Replies
    2
    Views
    171

    error - string is required

    Hi

    This is the string

    str = "select transactionno,tdate,tarewt,taredt,taretime,grosswt,grossdt,grosstime,netwt,grossshiftdate,tareshiftdate,grossusercode,tareshiftcode,grossshiftcode from...
  38. Thread: No Of records

    by Jagjit
    Replies
    3
    Views
    239

    Re: No Of records

    hi Arnoutdv

    you are right

    thanks
  39. Thread: Date Format

    by Jagjit
    Replies
    2
    Views
    223

    Date Format

    Hi

    I am using Sql Server 2008 R2 . Regional Setting of server is MM/dd/yyyy.
    str = "select count(*) from temp where adate='" & (sdate) & "'"
    rs.Open str, con1, adOpenDynamic,...
  40. Thread: No Of records

    by Jagjit
    Replies
    3
    Views
    239

    No Of records

    hi

    I am using Sql Database . I count no of days for a particular date to generate Series

    str = "select count(*) from temp where adate='" & CDate(tmpdate) & "'"

    If for a particular day i...
Results 1 to 40 of 357
Page 1 of 9 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.