Search:

Type: Posts; User: MildSeven

Page 1 of 2 1 2

Search: Search took 0.04 seconds.

  1. Replies
    3
    Views
    40,441

    Re: VB6 - Save Recordset to CSV format

    Thanks... very helpful!!!!
  2. Replies
    5
    Views
    832

    Re: ListView - Checkbox

    I can't post a screen shot from work :(

    while in development there's a little checkbox at the top left corner of the ListView... in runtime...it's gone :(


    here's where it load the list

    ...
  3. Replies
    5
    Views
    832

    Re: ListView - Checkbox

    thanks guys... I changed it directly in the properties.

    I see in the ListView... that a checkbox appears but in runtime when I load the records from Access... nothing :(
  4. Replies
    5
    Views
    832

    ListView - Checkbox

    Hello Boys and Gals...

    Amateur question: How do i make my first colum a check box?


    Public Sub LoadLsv(FRM As Form, lsv As ListView, MultiSelectChoice As Boolean)
    Dim itmX As ListItem, X As...
  5. Executing an SQL statement to read from a TabDelimited Text File

    While executing this code it returns the errors. "Run Time Error '3061': Too Few Parameters. Expected 53"

    In MS Access when I execute the same SQL it runs but pastes all dat in one column. It...
  6. Re: ListView capture value of first field (invisible)

    anyone?
  7. Re: ListView capture value of first field (invisible)

    here's the function to populate the ListView


    Public Sub LoadLsv(FRM As Form, lsv As ListView, MultiSelectChoice As Boolean)
    Dim itmX As ListItem, X As Long, Y As Long, MaxWidth(999) As Long...
  8. ListView capture value of first field (invisible)

    This is the code which load the ListView Box


    Private Sub LoadLTOListActivationsTab() ' LOADS TAB 2: LTO List Activations
    Set DB = OpenDatabase(ISPRDB) 'use DAO 3.6
    Set RST =...
  9. Re: VB: Excel - Subscript Out Of Range (On second run)

    thanks...


    added those pieces... the file exists... I'm still looking for a solution.
  10. Re: VB: Excel - Subscript Out Of Range (On second run)

    thanks...

    What do you mean by "exact description" I get "subscript out of range error 9.
  11. VB: Excel - Subscript Out Of Range (On second run)

    Hello... I'm having the following problem wondering if you guys can help.

    If I run this code twice it crashes on the...
    Set oWB = oApp.Workbooks(Dir(Left(txtNewFilePath, Len(txtNewFilePath.Text)...
  12. Replies
    20
    Views
    2,992

    Re: CSV to Excel (no '0' drop)

    Rock and Roll Anhn! it works!:cool:


    since you've been so helpful..and Ian't find the code anywhere... how do I find the last row (in the new excel file) which has data in it.... with a record...
  13. Replies
    20
    Views
    2,992

    Re: CSV to Excel (no '0' drop)

    They do have leading '0' I created the file to test... I'll re-check it again.
  14. Replies
    20
    Views
    2,992

    Re: CSV to Excel (no '0' drop)

    oh...sorry

    it runs through... no error... but still drops the '0' :(
  15. Replies
    20
    Views
    2,992

    Re: CSV to Excel (no '0' drop)

    anyone? :(
  16. Replies
    20
    Views
    2,992

    Re: CSV to Excel (no '0' drop)

    thanks anhn... I tried it out... but still no luck:(



    Private Sub Command1_Click()
    Dim oApp As Excel.Application
    Dim oWB As Excel.Workbook
    'Create an Excel instalce and open the...
  17. Replies
    20
    Views
    2,992

    Re: CST to Excel (no '0' drop)

    thanks guys..

    that's what I thought.

    anyone know any code for this.. I can open and format the new workbook no problem... but loading the CSV into the file will get me.
  18. Replies
    20
    Views
    2,992

    Re: CST to Excel (no '0' drop)

    but won't this mean that the file will already be saved.. thus it will have already lost the '0'

    maybe I'm just too newbie :p
  19. Replies
    20
    Views
    2,992

    Re: CST to Excel (no '0' drop)

    yes... but my concern is that if a cell should contain "012345" it will contain "12345" basically there are certain columns I would like to load as text so they keep the 0 (i.e. serial numbers).
    ...
  20. Replies
    20
    Views
    2,992

    CSV to Excel (no '0' drop)

    Hi Boys and Girls,

    I'm trying to create a .xls file from a .csv file. The following code does this... the only thing is (as expected) it drops ZEROs in from of a numerical value... ie. 012345...
  21. Replies
    11
    Views
    548

    Thanks!

    Thanks!
  22. Replies
    11
    Views
    548

    One last question. My video constantly plays....

    One last question.

    My video constantly plays. Is there a way to stop it after it plays once? (or only play once)

    Thanks again.
  23. Replies
    11
    Views
    548

    Thanks that helped! I should be using the...

    Thanks that helped! I should be using the ShockwaveFlash component instead.
  24. Replies
    11
    Views
    548

    What component should I add. I added Flash...

    What component should I add.

    I added Flash Document. "Play" is not there
  25. Replies
    11
    Views
    548

    Are you answering my question with a sarcastic...

    Are you answering my question with a sarcastic remark? or asking the same thing?

    If it's a answer can you tell me what Code I need?
  26. Replies
    11
    Views
    548

    Flash in VB 6

    I'm adding a flash movie (looped) to VB 6, but it doesn't play.

    I added the flash component. I made a little movie to test it(saved and published the movie)... Exited and returned to VB
    The...
  27. Replies
    6
    Views
    403

    sorry: good point. I'm in the moon. Private...

    sorry: good point. I'm in the moon.

    Private Sub cmdSave_Click()
    Dim DB As Database, RST As Recordset
    Set DB = OpenDatabase("E:\Telepath Project\DataModificationLog.mdb", , False) 'use DAO 3.6...
  28. Replies
    6
    Views
    403

    Oops in a DB, (MS Access).

    Oops in a DB, (MS Access).
  29. Replies
    6
    Views
    403

    List Box Question

    Hi guys, I have a problem.

    I have a list box (multiSelect) how do I store all the items chosen and seperate them by commas?


    store them in MS Access

    your help is much appreciated

    Thanks...
  30. Replies
    2
    Views
    439

    Thanks alot I really appreciate it. I couldn't...

    Thanks alot I really appreciate it. I couldn't attach my full project because of the size limitations. I can email you a zip file though. If it's not too much trouble. In the full project you can...
  31. thanks guys it wroks now... Solution: I had...

    thanks guys it wroks now...

    Solution:
    I had to use the Calander Control for Access 2000 (Microsoft Calander 8.0) had to use another pc to do this because when I added the component to VB. it...
  32. Replies
    2
    Views
    439

    please please HELP! (date related)

    here's my problem ... I'm a newbie :)

    now here's my real problem....

    It is supposed to take away a "available week" next to the calander coresponding to the date selected. but for February and...
  33. problem have to use calander control 9.0 for...

    problem have to use calander control 9.0 for Microsoft Office 2000
  34. I'm going to try that now, but I've noticed these...

    I'm going to try that now, but I've noticed these errors only ocur on NT machines.

    I installed VB6 on one of the PCs with this error and here's what happens.

    Run time error:
    Method 'year' of...
  35. I tried that still no luck. these are the...

    I tried that still no luck.

    these are the files I included.
    mscal.cnt
    mscal.dep
    mscal.gid
    mscal.hlp
    mscal.ocx

    note when I add mscal.ocx it sas it can't find any dependencies for this file.
  36. I mean install the package. I managed to get...

    I mean install the package.

    I managed to get it to work on the "PC 2" ?Win 2000 french pc. Just had to change the Language settings (there was a conflict with the language of the calander.

    I...
  37. Error when I install on other pcs (Resolved)

    NEWBIE HERE

    The application works fine on my pc, but when I install it on other pcs, I get a errors.

    My pc has Win 2000, Microsoft Access 2002 (it's english) works fine.

    Everything works...
  38. how do I make it long enough to fit everything?

    how do I make it long enough to fit everything?
  39. Scroll bar (form) question. Help me, dudes!

    I want to make a long form with a vertical scroll bar to scroll up and down, is it this posible? How?


    Thanks,
    ciao people,
    Anthony
  40. Replies
    4
    Views
    436

    I'll check it out thanks man!

    I'll check it out thanks man!
Results 1 to 40 of 43
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width