Search:

Type: Posts; User: ganeshmoorthy

Page 1 of 13 1 2 3 4

Search: Search took 0.31 seconds.

  1. Re: Can't repaire or compress the database

    try this statement
    DAO.RepairDatabase ("MDBFileName.mdb")
  2. Replies
    3
    Views
    684

    Re: Webbrowser control

    one option would be to have control array
  3. Replies
    15
    Views
    1,223

    Re: Sharing data between 2 vb programs

    Im not sure whether it will be a good practice todo like this...anyway just give a try to using environ variables; set the value from one vb prog and access it from the other...you can search lots of...
  4. Replies
    3
    Views
    580

    Re: problem loading and saving file

    To check whether if the file exists and write, you can use just the Append mode as below

    Open "G:\test.txt" For Append As #1
    Print #1, "abcdefghi"
    Close #1

    it will take care of...
  5. Replies
    15
    Views
    1,223

    Re: Sharing data between 2 vb programs

    may be you can use a common public file to store the values you want to access from other program...may be you can generate a txt file and write your values from com1 and from com2 access it.

    or...
  6. Replies
    10
    Views
    1,193

    Re: How Does Progress Bar Work?

    to move it you need to increase its value ....ProgressBar1.Value = ProgressBar1.Value + 1

    but you need to have proper value to increase the value..for example if you are executing a set of...
  7. Replies
    8
    Views
    1,045

    Re: Print question

    To print a file anyhow you need to get the full file name....
    how do you find that this 1234567 is linked with a specific file name...do you have any database to fetch this details....

    after...
  8. Replies
    5
    Views
    4,988

    Re: List1.AddItem

    no probs as you both posted at the same time without your knowledge...it happens at times...;-)
  9. Replies
    2
    Views
    7,641

    Re: ADO equivalent of DAO "nomatch"

    Can you try opening the recordset with a query to see a record exists...
    Sql = "Select * From tbl_Table Where Field1='Field1'"
    rs.Open Sql, Cn, adOpenKeyset, adLockOptimistic
    If rs.EOF Then
    ...
  10. Replies
    6
    Views
    779

    Re: Problem with DAO and MS Access

    Or use a query to return values like this
    Set mrs = dDB.OpenRecordset ("Select * From [Available]")
  11. Re: How do I allow the user to enter a desired number of variables?

    yes, by copying you can create an array of controls as mentioned in the previous post, else try the below
    1. Set the index of the first text box to 0 (for ex. set txt1.Index = 0 'at design time)
    2....
  12. Re: VB6 - Terminating VB after program execution

    do you have any unload commands for unloading any of your forms when you are done...
  13. Re: Search question (Stored Procedure)

    Use the Query like the below...
    Select * From YourTableName
    Where [Name] = '" & txtUserInput.Text & "'
    Or [Address] = '" & txtUserInput.Text & "'
    Or FaxNumber = '" & txtUserInput.Text & "'"
  14. Replies
    6
    Views
    2,110

    Re: return recordset from PL/SQL

    Do you have any specific requirement to use the cursor from VB, If not why dont you use just SQL statement from VB to get the result...

    sSql = "Select FN1, FN2, FN3, FN4 FROM MY_TABLE Where FN2 =...
  15. Re: Testing for Existing Records to avoid duplication

    Using recordset...
    rs.Open ("Select * From glActivity Where CheckFieldName = ValueToBeCheckedFor")
    If rs.EOF Then
    MsgBox "Not processed earlier !"
    Else
    MsgBox "Already Processed !"
    End...
  16. Replies
    7
    Views
    1,367

    Re: select top 100 percent

    Could you post some example data of what you have and what you need to get from the table...this will help us to understand you clearly...from your thread I have understood that you want to get top...
  17. Re: Encoding and decoding with Magnetic Card Writer / Reader

    For reading from the magnetic card you dont need to write any code as its just a keyboard wedge. When placing your cursor and swipe the card in the reader will get the value from the card to the...
  18. Replies
    28
    Views
    5,417

    Re: Problem with GetAsyncKeyState?!

    this function expects an argument (a key name) to be passed to it...so try with passing a key from the keyboard, for example GetAsyncKeyState (vbKeyEnter)
  19. Replies
    11
    Views
    1,074

    Re: Web browser Combobox problem

    are you not able to click on an item in the combo box or when you click on an item in the combo nothing happens...whats the actual problem...
  20. Replies
    20
    Views
    1,289

    Re: ComboBox help Again

    what do you want to do after you remove an item from the combo box...if possible please post your code here, so that we can understand it better..
  21. Replies
    20
    Views
    1,289

    Re: ComboBox help Again

    you have to assign the .Text again to have the display, probably you can do like this Combo1.Text = Combo1.List(0)
    but the combo should have atleast one item to display without any error
  22. Replies
    10
    Views
    1,745

    Re: Reading INI Files

    you can use ReDim and Preserve to reassign the number of elements in an array....I did go thru your full thread...this is just for the last reply...
  23. Replies
    1
    Views
    1,669

    Re: OleAut32.Dll for Windows 98

    Dont worry, I have fixed it by downloading msrepair.exe from microsoft site. It has fixed the prob.
  24. Replies
    1
    Views
    1,669

    [RESOLVED] OleAut32.Dll for Windows 98

    I have installed a project which i have developed on an XP system, onto a windows 98 PC. It replaced the oleaut32.dll file to a latest one and due to that now, Im getting an error, oleaut32.dll can...
  25. Replies
    13
    Views
    1,646

    Re: runtime error 13 on update...

    can you just try removing the resume next statement and make it as On Error GoTo ExecuteSQLa_Errorand then tell us which line it gives error
  26. Replies
    9
    Views
    1,051

    Re: Table Object

    Im not sure how to call the macro for SAP, but if you can execute the same steps in vb, you can get it done. Like Object.<YourMacroStatement1>
    Object.<YourMacroStatement2>
    'and so on
  27. Replies
    13
    Views
    1,646

    Re: runtime error 13 on update...

    Can you point out on which line this error occurs
  28. Replies
    9
    Views
    1,051

    Re: Table Object

    Do you have any macro in SAP to do this task
  29. Re: Populating Flexgrid in Different way

    Use a Group By Query and when each group changing add a row to the flex grid and then add the employees' names. Hope you understand this.
    Dim sPostName As String
    Sql = "Select EmpName, PostName...
  30. Re: Importing Data From MS Excel to MS Access Through VB6

    Use an ADODB connection and bind it to your access database. Then run Connection.Run statement with this sql, it should help you to do what you wanted to do.
    And for the common dialog use it like...
  31. Replies
    9
    Views
    776

    Re: update query for birth year

    Yes, the post in number 7 would solve you issue,
    Just out of my curiosity, how these values got saved into your database..
  32. Replies
    6
    Views
    671

    Re: if.. to query as rowsource

    Smitas,
    you need to add a reference of your required database object to your project.
    What database you are using and what is the technology you want to use...
    If DAO then select Microsoft DAO...
  33. Replies
    6
    Views
    1,005

    Re: Get range date picker

    If I have understood you correctly, you want to construct a query from two dates selected from the listview...
  34. Replies
    1
    Views
    553

    Re: Visible frame problem

    penyakittable.Open "Select * from penyakit where [Nama Penyakit] = '" & Combo1.List(Combo1.ListIndex) & "'", conpenyakit, adOpenDynamic, adLockOptimistic
    If Not penyakittable.EOF Then
    If...
  35. Replies
    42
    Views
    2,632

    Re: HEY look at this code

    if you want to copy a specific form then just use FileCopy App.Path & "\Form2.frm", "C:\Form2.frm"
  36. Re: Sql server 2000 changing data type

    this will convert it to date...CDate(24026)
  37. Re: format$(NUMBER, "#.##") vs format$(NUMBER, "0.00") vs format$(NUMBER, "Currency")

    if you try with 00000.00 or #####.##, then you will see the difference
  38. Re: VB - How to send a file using the Winsock control

    The user on the server decides what to send to client...
    My bad....
  39. Re: VB - How to send a file using the Winsock control

    ppita,
    thank you very much for your work...let me check the code and get back to you..
  40. Re: VB - How to send a file using the Winsock control

    Thank you very much for your interest in making a sample for me !!!The user will select multiple files from a flexgrid and click on the send button.
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width