Search:

Type: Posts; User: Mustaphi

Page 1 of 13 1 2 3 4

Search: Search took 0.10 seconds.

  1. Replies
    19
    Views
    1,557

    Re: [RESOLVED] Copy a column

    Million thanks Olaf
    it works like a charm
  2. Replies
    19
    Views
    1,557

    Re: Copy a column

    Thank you ChrisE
    I 'll try it tomorrow
  3. Replies
    19
    Views
    1,557

    Re: Copy a column

    Thank you ChrisE
    But as jpbro explained I want the first word of each row without numbers or dash..
    In the database some data start are like this:
    1- aaaaa bbbbb
    2- ccccc ddddd
    etc
    Others are...
  4. Replies
    19
    Views
    1,557

    Re: Copy a column

    Could you modify the code using this technique?
  5. Replies
    19
    Views
    1,557

    Re: Copy a column

    Thank you very much gentelmen

    INSERT INTO Tbl2 (Column1) SELECT CASE WHEN INSTR(LTRIM(Column1), ' ')=0 THEN Column1 ELSE SUBSTR(Column1, 1, INSTR(LTRIM(Column1), ' ')) END FROM Tbl1;
    This code...
  6. Replies
    19
    Views
    1,557

    Re: Copy a column

    Arnoutdv and jpbro
    Thanks a lot for you interest

    INSERT INTO Tbl2 (Column1) SELECT CASE WHEN INSTR(Column1, ' ')=0 THEN Column1 ELSE SUBSTR(Column1, 1, INSTR(Column1, ' ')) END FROM Tbl1;...
  7. Replies
    19
    Views
    1,557

    [RESOLVED] Copy a column

    Hello Vbforums
    I'm trying to copy one column from one table and insert it in another column of a new table.

    INSERT INTO Tbl2([Column1])" & _
    "SELECT Clumn1 FROM Tbl1
    But I need to...
  8. Thread: sending email

    by Mustaphi
    Replies
    15
    Views
    896

    Re: sending email

    Some years ago, I was able to send mails.
    Now, I get errors using the same applications.
  9. Thread: sending email

    by Mustaphi
    Replies
    15
    Views
    896

    Re: sending email

    189924
    189922

    189923
    189925
    I'm getting either of these messages

    Me too
    but I no longer be able to send emails now
  10. Thread: sending email

    by Mustaphi
    Replies
    15
    Views
    896

    Re: sending email

    I tested all of them but I failed to make anyone works
  11. Replies
    3,724
    Views
    1,846,859

    Re: CommonControls (Replacement of the MS common controls)

    Thank you Krool
  12. Thread: sending email

    by Mustaphi
    Replies
    15
    Views
    896

    sending email

    Hello Vbforums community
    I want to ask if there is a viable method for sendig email
    I tested many demos that I found on the net but none of them is working.
    thanks
  13. Replies
    6
    Views
    695

    Change the path

    Hello VbForums
    I"m saving the path of my pictures in database.

    E:\my pics\Pics\Image 10.jpg
    Now I need to change the path of all my pictures to:

    C:\Program Files (x86)\Log_pics\MyPics\...
  14. Re: French apostrophe is causing great trouble !!

    thanks but I need a query like this:

    SQL = "Select * From myTable Where Firstname = '" & Text1.text & "'"
  15. Re: French apostrophe is causing great trouble !!

    Olaf
    You are great
    your query worked.
    But for a spcial purpose I wonder if it is possible to use a a query like this.

    SQL = "Select * From myTable Where Firstname = '" & Text1.text & "'"
    I...
  16. Re: French apostrophe is causing great trouble !!

    thank you all for your interest and help
  17. French apostrophe is causing great trouble !!

    Hello VbForums community
    I'm using sqlite as database.
    When I'm trying to retrieve some strings that contain apostrophe (') from database, the applcation freezes.
    Is there a workaround to overcome...
  18. Re: impossible to install dll and ocx on system32

    During the process of installing the application I get a message error like:
    impossible d'enregisrer l'objet com(ActiveX)
    C:\Windows\system32\MSCOMCTL.OXC
    echec dans Loadlibrary (126)
  19. Re: impossible to install dll and ocx on system32

    thank you all
    But still no one told me why these ocx and dlls refuse to be installed on this special machine.
    IS there a way to force windows to accept installing these dlls in system32 or ...
  20. Re: impossible to install dll and ocx on system32

    I'm not sure but I think it is 64 bit
  21. Re: impossible to install dll and ocx on system32

    I'm using Setup Factory installer
  22. impossible to install dll and ocx on system32

    Hello VbForums
    On one of my clients system (W10 professional) I was unable to install VB6 common controls on system 32.
    I tried to copy them manually but impossible to register them by means of...
  23. Re: [RESOLVED] Is it possible to know if a file is saved at the root of the hard driv

    solved thank you
  24. Re: Is it possible to know if a file is saved at the root of the hard drive?

    thanks but is it possible to check if a file is copied on the root of the drive ?
  25. [RESOLVED] Is it possible to know if a file is saved at the root of the hard drive?

    Hello VbForums
    As the title indicates
    Is it possible to know if a file is saved at the root of the hard drive?
    I want the user to save the file in a folder.
    If the user saves the file at the of...
  26. Replies
    6
    Views
    817

    Re: update a field Sqlite and RC5

    What i mean by line is not row
    My fielld is text_type
    it looks like this:
    le: xxxxxxxxxxx

    aaaaaaaaaaaaaaa
    bbbbbbbbbbbbbb
    cccccccccccccccc
    The 1st line begins with "Le:"
    The second line is...
  27. Replies
    6
    Views
    817

    Re: update a field Sqlite and RC5

    Would please show me how to do that?
  28. Replies
    6
    Views
    817

    update a field Sqlite and RC5

    Hello VbForums community
    I want Vforums experts to help me in this point.
    I need to copy data from one field to another one except the two first lines.

    Cn.Execute "update Tbl1 set Result = '"...
  29. Replies
    12
    Views
    1,337

    Re: Count function and inner join problem

    It seems what I'm trying to reach is not possible
  30. Replies
    12
    Views
    1,337

    Re: Count function and inner join problem

    It seems complicated because Tbl1 may also have another join with a fourth table.
  31. Replies
    12
    Views
    1,337

    Re: Count function and inner join problem

    I need to display on a listview the name of the item (Main table) and other info in Tbl1 and Tbl2.
  32. Replies
    12
    Views
    1,337

    Re: Count function and inner join problem

    thank you sir
    You are great
    the code worked very well using two tables.
    But I still have one small issue.
    I have a third table (The Parent Table)
    How to include this table in the code above.
    ...
  33. Replies
    12
    Views
    1,337

    Re: Count function and inner join problem

    Thank you sir for your interest
    I tested your code
    I'm getting errror
    A join is required efore on
    Besides, I cannot use Limit because "Due" may have more than one occurence.

    Cnn.Execute...
  34. Replies
    12
    Views
    1,337

    Count function and inner join problem

    Hello experts
    I'm using Sqlite3 and RC5
    My tables look some how like these:

    Set Cnn = New_c.Connection(, DBCreateInMemory)
    Cnn.Execute "Create Table Tbl1(Item_ID Integer, BrandID Integer)"...
  35. Re: Sqlite delete from a table with primary key

    Thank you Moderator

    I still want to do it.

    SQL = "Select * from Item_tbl Where item_name =? "
    Set Rs = Cnn.OpenRecordset(SQL)
    With Cnn.CreateSelectCommand(SQL)
    .SetText 1,...
  36. Sqlite delete from a table with primary key

    Hello
    My table sqlite has 8 records.
    When I delete the first record then I add a new record , the new record takes an ID = 9.
    Is there a way that the new added record takes the ID of the deleted...
  37. Replies
    6
    Views
    1,121

    Re: Question to Eduardo

    thanks a lot Eduardo
  38. Replies
    6
    Views
    1,121

    Re: Question to Eduardo

    thank you Eduardo
    please let us know once the bug is fixed
  39. Replies
    6
    Views
    1,121

    [RESOLVED] Question to Eduardo

    Hello Eduardo
    I'm using your excellent BSPrinter printer to print my flexgrid.
    My only issue is Right alignement.
    The text in the grid is left aligned though I'm using Right to left property.
    Am...
  40. Replies
    0
    Views
    367

    print VbFlexgrid Right to Left

    Hello VbForums
    I use Krool's VbFlexgrid .
    On the form it shows Right to left
    I mean the "record Name " in the first column.
    but when I print , it is sorted Left to Right.
    The "record Name " is...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width