Search Results - VBForums

Search:

Type: Posts; User: firoz.raj

Page 1 of 13 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    3
    Views
    179

    Re: Microphone Array Iissue

    Hi, Nightwalker other software I have been using Jumblo . it is cheaper than Skype .

    https://www.jumblo.com/dashboard
  2. Replies
    3
    Views
    179

    Microphone Array Iissue

    Hi friends,

    all the time, when i am talking with skype or any other voip Software .Microphone array automatic decrease from 100 to 0 .and when
    it becomes 0 . opposite person don't listen any...
  3. Re: do i need to use here 2 where clause ?

    why don't you try datediff function .and you need to check diffdate is less than and equal to 1 .


    DiffDate = DateDiff("d", Date, EDate)
  4. Re: Error check in DataEnvironment.DEConnection.ConnectionString

    I would suggest not to use on error resume next .and together with this try to get the error in message box when it throws the error .
  5. Re: Problem : Generating Unique Number (too slow)

    another problem is why don't you restrict by proper where condition .it would be too slow .

    sqlCriteria = "SELECT MAX(REINPUT) AS CNUMBER FROM TBL_PAYROLL"
  6. Replies
    6
    Views
    962

    Re: Help need vb6

    problem is that when modal form is open . you even cannot close your modeless form . it even cannot go back of the modeless form . so form as a modeless . and you can resize it will go behind the...
  7. Replies
    2
    Views
    260

    Re: [RESOLVED] Password Protect Excel File

    you need to protect the worksheet .then it will work . try the following way .

    Hi

    I have written this but it is not working

    Dim xlApp As Excel.Application
    Dim xlBook As Excel.Workbook
    ...
  8. Replies
    5
    Views
    325

    Re: Type mismatch

    hi instead of passing tablename you need to write the complete sql statement .for me the following
    code is working fine .


    dim db as database
    dim rs as recordset
    dim SQlquery as string...
  9. Replies
    0
    Views
    934

    Wireless Connection Issue

    Hi Friends,
    today strange happens at my computer my wired Connection is Working Fine .and when I come at Manage Wireless Networks
    it is showing only icon . i have checked my lancard may be it is...
  10. Replies
    5
    Views
    307

    Picture in MDI Form Background

    Hi ,

    Friends is there anyway to make background picture in MDI Form Without Using Subclassing .
    i tried to using Picture property but picture is not coming in Full Screen . let me know please .
  11. Replies
    5
    Views
    264

    Re: Microsoft Excel msgbox problem

    Try the following hope it might help .

    Option Explicit

    Private Sub Form_Load()
    If File3.FileName = Left$(File3.FileName, 4) Then
    File3.FileName = File3.FileName
    ...
  12. Re: What is wrong in this expression

    if you have already declared
    Dim objXl As New Excel.Application then again declaring xlTmp as excel.application is also does not make sense . please read basic things like variable , object and...
  13. Replies
    8
    Views
    432

    Re: You Selected XXX Minutes from

    you need to use variable instead of const time .like the following
    =Datediff("s",Starttime,EndTime)
  14. Re: MS Access97 & Microsoft.jet.oledb in VB6

    following way you can connect to your mdb file . hope it might help .

    Private Sub Form_Load()
    Dim con As New ADODB.Connection
    con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data...
  15. Re: [RESOLVED] Only two Rows show in MSHFlexGrid using Recordset as source

    HI Sam ,
    it is really unnessary to open two object of recordset . and do nothing with very first recordset

    cnn.cursorlocation =aduseclient
    rs.Open "myTable", cnn, adOpenKeyset,...
  16. Replies
    4
    Views
    261

    Re: Package and Deployment wizard

    because you have hardcode the path in the project itself . before running the package and deployment wizard .
    check the hardcoded path in the vbp file .i have double about your connection string .
  17. Replies
    2
    Views
    218

    Re: grouping issue

    Hi Sam, sorry i am per sure you did not work neither on Sql server nor oracle database . value field is not a reserved keyword .and it does not make any issue . for example following query is...
  18. Replies
    2
    Views
    218

    grouping issue

    Hi friends,

    why the following sql statement gives wrong sum(A.value ) , let me know please .

    select
    --trunc(a.tran_datetime),
    B.STORE_NAME, A.day, A.store, sum(A.value), c.item, d.item_desc ...
  19. Re: how to display 2 SumS from 2 different tables in 1 text

    i don't see any reason to use two separate query . why they cannot link the table by inner join . with restrict data by where clause .
  20. Re: how to display 2 SumS from 2 different tables in 1 text

    no need to use two separate query .if you really want to get the data from two different table . just you need to use inner join in your query .and after that you want to just perform sum .you need...
  21. Replies
    0
    Views
    140

    between operator in Oracle Data

    hi friends ,
    data are available for May 7 . but when i run the following query it shows only yesterday data ? load_TS is date type field in Oracle database .

    select...
  22. Replies
    4
    Views
    272

    Re: Reminder forr Passport Expiry Date

    OK i Just Corrected a Bit and it is working Now .let me know if more suggestion

    Private Const Issuedate = #5/10/2013#
    Dim EDate As Date
    Dim DiffDate As Long
    Private Sub Form_Load()
    EDate =...
  23. Replies
    4
    Views
    272

    Reminder forr Passport Expiry Date

    HI, Friends i just want when password to be expired in 30 days .person needs to get notification each days .
    your password will be expired in 30..29...28......5 days daily . let me know suggestion...
  24. Re: need a little explanation about some loops

    While Not
    Do While Not
    Do Until


    All the above are loop . diffferenc is only syntax .

    The syntax for While
  25. Replies
    10
    Views
    772

    Re: Populating datagridView

    jmcilhinney

    Another point When dataadapter tries to Fill the DataTable .it says the following error Message . Can you let me know Please .why i am getting the following Message.

    The CLR has...
  26. Re: Filling all the lines of Datatable into Dictionary collection

    i have 500 of item in a dataset . When i will add the item in the collection whether it is dictionay,List or any type of collection .it needs to add Key like K1,K2,K3........k500 like the following ....
  27. Filling all the lines of Datatable into Dictionary collection

    Hi,
    friends i just want to store all the rows of datatable into dictionary Collection .
    let me know please .any help would be highly appreciated .

    Public Sub StoreStock()
    Dim SQL As...
  28. Replies
    4
    Views
    249

    Re: Server Connection

    Why don't use timeout Property of Cnn2.

    Private Sub Timer3_Timer()

    If cnn2.State Then cnn2.Close
    cnn2.ConnectionTimeout = 0
    cnn2.Open "Driver=SQL Server;Server=" & Svr & ";Database=" & "Test"...
  29. Replies
    10
    Views
    408

    Re: Why isnt this working

    problem is that did you debug .please debug step by step .anyway try the following . hope it might help .

    Private Sub Command1_Click()
    dim Con as new adodb.Connection
    dim sql as string...
  30. Replies
    4
    Views
    210

    Re: Do For Loop. ect

    Obvioulsly i it will skip and keep only latest data. so better way to do add all the receiving data into array .another things i have notice remove on error resume next.

    Private Sub...
  31. Replies
    10
    Views
    408

    Re: Why isnt this working

    other things i have notices lots of logical mistake .anyway try the following way . hope it might help.


    Private Sub Command1_Click()
    dim Con as adodb.Connection
    dim rs as adodb.recordset...
  32. Re: displaying a progress bar on a status bar doesn't seem to work

    try the following way . hope it might help .
    Dim ProgressPane As StatusBarProgressPane
    Set ProgressPane = frmMain.CommandBars.StatusBar.FindPane(ID_INDICATOR_PROGRESS)
    ProgressPane.Visible...
  33. Replies
    6
    Views
    382

    Re: Connection with server

    try the following way . hope it might help .

    If cnn2.State Then cnn2.Close
    cnn2.Open "Driver=SQL Server;Server=" & SvrName & ";Database=" & "test" & ";uid=" & Suid & ";pwd=" & Spwd & ";"
    ...
  34. Re: [RESOLVED] Application defined or object defined issue

    another point i have seen why you have used timer funciton here .T = Timer
    Debug.Print Timer - T. because i don't see any reason to use timer funciton here .

    Public Sub...
  35. Replies
    3
    Views
    292

    Re: assign variable powerpoint.presentation

    try the following way . hope it might help.

    dim pptAPP as object
    dim ppt as powerpoint.presentation

    Set pptAPP = createobject("Powerpoint.application") ' ppt
    pptAPP.Visible=true ...
  36. Re: [RESOLVED] Application defined or object defined issue

    problem is that it has 549210 lines in the recordset . and as i have seen all the lines are stores at Tmp 2d Array .
    and when altogether lines are copied by ArrFillFromTopLeft to the excel range...
  37. Re: [RESOLVED] Application defined or object defined issue

    Hi, Schmidt

    i just want to approach UDT Array as you suggested .as i did not work on UDT Array .
    so Kindly can you implement UDT Array for me my brother . any help would be highly appreciated .
  38. Re: [RESOLVED] Application defined or object defined issue

    Still waiting for some suggestion .
  39. Re: MDAC error (Windows XP SP3-VB6-ADODB-SQL-Jet

    really there is no any issue installing vb6 even on Wndows 8 .
  40. Thread: Loop

    by firoz.raj
    Replies
    5
    Views
    281

    Re: Loop

    you can do the following way .

    Option Explicit
    Private Sub BtTest_Click()
    Dim num As Integer
    num = 0
    Me.AutoRedraw = True
    Do
    Print num
    num = num + 1
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.