dcsimg

Search:

Type: Posts; User: brss

Page 1 of 9 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    7
    Views
    1,538

    Re: MS paint (Save As)

    Actually I'm using code below to launch MSPaint to save excel to PNG. I just want to know how to change path by vb6 code? I thank you all for stopping by.


    Dim strFilePathName As String
    ...
  2. Replies
    7
    Views
    1,538

    Re: MS paint (Save As)

    I just want to change directory path of save as form as you see in post #1 attached image, for example from E:\ to D:\Damagefolder
    Thank you for your stopping by.
  3. Replies
    7
    Views
    1,538

    MS paint (Save As)

    Hi all, I just wondering how to change the directory of save as form, as i point you in attached image by using vb6 code? for example. Thank you
  4. Re: VB6 - Automaticall save screenshot to MS Paint and save with a timestamp filename

    Now i got above post to work and it's working. Thank you again gor your awesome code.
    I just wondering how to change the directory of saved image path as i point you in attached image by using vb6...
  5. Re: VB6 - Automaticall save screenshot to MS Paint and save with a timestamp filename

    Thank you Rob. For your brilliant code. I have used it all work fine except it's not change File Name in Combobox? and i have do some code to see as below:


    '
    '
    '
    lHwndC =...
  6. Replies
    4
    Views
    1,381

    Re: Re-size and Position Image in Excel worksheet

    Hello and thank you for your reply s. What i mean my tring failed to re-size and position Image as you can see in Post #1. I can insert picture to excel but i cannot re-size and position to place it...
  7. Replies
    4
    Views
    1,381

    Re-size and Position Image in Excel worksheet

    Hi All, i try to re-size and position as you can see in attachment and code below but all my trying failed. please any suggest to do that? Appreciate your help and your time here. Thank you.

    Dim...
  8. Replies
    7
    Views
    920

    Re: Using Ctrl+C and ctrl+V

    It's real IE-Window. What is Spy++? No i'm not familiar with FindWindow/FindWindowEx. Thank you
  9. Replies
    7
    Views
    920

    Re: Using Ctrl+C and ctrl+V

    I have already done that and it's working. Now with (IE.Document) not working. That's why i mark (IE.Document) in read. Appreciate your assist. Thank you
  10. Replies
    7
    Views
    920

    Re: Using Ctrl+C and ctrl+V

    Thank you @Zvoni for your stopping by. So how can i accomplish this please? Is there better code to do this task? Thank you again
  11. Replies
    7
    Views
    920

    Using Ctrl+C and ctrl+V

    Hello All, I'm trying to use control key ctrl+c to copy from textbox and use ctrl+v to paste in webform field as following but code not paste text in webform field! please what I'm doing wrong? or is...
  12. Replies
    10
    Views
    1,255

    Re: Save Image to SQL DB and retrieve it?

    @Sam, Thank you for your feeling really its touch me in some how. i wish you all best DEARS. Thank you all
  13. Replies
    10
    Views
    1,255

    Re: Save Image to SQL DB and retrieve it?

    @Sam, a'm I doing wrong? Is it bad? Thank you
  14. Replies
    10
    Views
    1,255

    Re: Save Image to SQL DB and retrieve it?

    Thank you for your time spending here Sire. I'm using SQL server 2008. Thank you
  15. Replies
    10
    Views
    1,255

    [RESOLVED] Save Image to SQL DB and retrieve it?

    dears, I'm successfully save image to SQL DB and try to retrieve it but with error message as follow:
    ( Arguments are of the wrong type, are out of acceptable range, or are in conflict with one...
  16. Replies
    4
    Views
    756

    Re: Split the Data in Datagrid?

    I did found away to split the data as shown in code below". Thank you very much

    Dim intCount As Integer
    Dim iRow As Integer
    Dim iColumn, iLoop, iLoopCol As Integer
    Dim cnn As New...
  17. Replies
    4
    Views
    756

    Re: Split the Data in Datagrid?

    No it have two column 0 and column 1. Thank you for stopping by.
  18. Replies
    4
    Views
    756

    [RESOLVED] Split the Data in Datagrid?

    Hello all, Table A with field customer having 40 record, I usually displayed all 40 records in datagrid columns 0. Is it possible to split 40 record : 20 record displayed in columns 0 and rest to...
  19. Thread: Split data help

    by brss
    Replies
    6
    Views
    1,310

    Re: Split data help

    Any advice please? Thank you very much.
  20. Thread: Split data help

    by brss
    Replies
    6
    Views
    1,310

    Re: Split data help

    Looking forward for your advice Sam? Thank you very much.
  21. Thread: Split data help

    by brss
    Replies
    6
    Views
    1,310

    Re: Split data help

    Dear Sam, Thank you for your reply, i really enjoy apply your code i did make array and work such fine. I did not figure out how to add it to my project. I attach the source code with excel data and...
  22. Thread: Split data help

    by brss
    Replies
    6
    Views
    1,310

    Split data help

    Hi, Usually i used to transfer data from Excell multible column to access db. Now i have data in one column seperated by , as mention below. Please what should i change in code below to transfer data...
  23. Replies
    0
    Views
    511

    Generate Excel report

    Hi All, i generate excel report with 0 error, the issue i have it's just repeat value as shown below for example. please what i'm missing? Thank you for your time spending here.


    [Group Title] ...
  24. Replies
    3
    Views
    3,347

    [RESOLVED] Type Mismatch error!!!

    Dear sires, I got error 'Type Mismatch' as described in code below. Please what i'm missing. Appreciate your time to look at my issue.


    Dim i As Integer
    Dim blFlagCheck As Boolean
    blFlagCheck...
  25. Replies
    9
    Views
    1,061

    Re: Upload Excel to Access

    you can just add &"" to the code for example:


    strSQL = strSQL & "'" & Trim$(rs1.Fields(4) & "") & "')"

    That's will ignore the Null. Is that what you looking for?

    BTW, What you mean by...
  26. Replies
    4
    Views
    564

    Re: Barcode Issue?

    convert to a number then back to a string and check the length of the new string if less than 5 add the required number of 0s to the left.
    Yes correct that's what i'm looking for. i use replace but...
  27. Replies
    4
    Views
    564

    [RESOLVED] Barcode Issue?

    Hi everyone. I have a barcode scan thing. Anyway, my question is how can we remove or add the zero's in a barcode. In my case I have barcode read two different way as:
    1- 1234
    2- 001234
    ---> all...
  28. Replies
    9
    Views
    1,061

    Re: Upload Excel to Access

    Please check link and if you found it usefull please rate DOOGle.http://www.vbforums.com/showthread.php?683415-RESOLVED-Transfer-data-from-Excel-to-Access-DB
  29. Re: Transfer Data from Excel sheet to Sql DB?

    Thank you Doogle for your positive reply. Yes sure there is not because I provide it. Now I got error invalid use of Null on line

    StrSQL = strSQL & "'" & Trim$(rs1.Fields(4)) & "')"

    While...
  30. Re: Transfer Data from Excel sheet to Sql DB?

    Thank you for appoint me this. Now i got run time error as Invalid object name "sheet$"? I attach you the link in vbforums that contain the app,...
  31. [RESOLVED] Transfer Data from Excel sheet to Sql DB?

    Hello All, Usually i tansfer data from Excel sheet to access DB, this app developed by Doogle. All thanks to him. Now i upgrade my DB from Access DB to SQL server 2008 as you can see in code below...
  32. Replies
    5
    Views
    830

    Re: Performance is very slow running

    It's resoleved now. I figure it out, Missing ' next to dtpReceived. Thank you
  33. Replies
    5
    Views
    830

    Re: Performance is very slow running

    Thank you for your code. But it's only update Field6 (Customer) and NOT update Field4 (Date). What we missing please?
  34. Re: [RESOLVED] Pass Date from vb6 field to Web-Form Date field

    Gep, Sorry for late reply. I would be glad to help others. I did figure out and Max. that contract field have two field one above the others. My solution is as below and it's register Date now:


    ...
  35. Replies
    8
    Views
    1,104

    Re: problem in database

    Well, i provide below my connection code to Access DB. Hope you get benefits. Thank you.



    Public dbContact As Connection
    Public g_strDBName As String
    Public dbPath As String
    Public Constring...
  36. Re: SQL Server incorrect syntax near '#'?

    Thank you for your feedback DM.
  37. Re: SQL Server incorrect syntax near '#'?

    DataMiser, Thank you for mention that, I already did but I want to know is it possible to use 'BETWEEN' with 'LIKE'? As I used it in Post #1. Thank you
  38. Replies
    2
    Views
    552

    Re: Problem Filter Year with Between

    Hello, I think you should do something like below, assuming using MS Access DB.


    '
    '
    S_Date = ComboFrom.Text
    E_Date = ComboUpto.Text
    rsview.Open "SELECT DateofBirth FROM test where...
  39. [RESOLVED] SQL Server incorrect syntax near '#'?

    Hello All, I connvert my connection from MS Access to SQL Server 2008 with only two issue occured:
    1- Generating reports accorging to specific date FIXED by using like as shown below.
    Convert from:...
  40. Replies
    5
    Views
    830

    [RESOLVED] Performance is very slow running

    Hello All, Is there a better way than the code below to speed up the process of saving the data because the code below takes time up to 17 second to saved data? Please need your advice to recode it...
Results 1 to 40 of 335
Page 1 of 9 1 2 3 4



Featured


Click Here to Expand Forum to Full Width