Search Results - VBForums

Search:

Type: Posts; User: SamOscarBrown

Page 1 of 13 1 2 3 4

Search: Search took 0.07 seconds.

  1. Replies
    9
    Views
    216

    Re: Read and write new csv file

    Then see dile's post
  2. Replies
    9
    Views
    216

    Re: Read and write new csv file

    But his attached files had an excel file in it, assuming THAT was what he wanted to use and then produce a CSV...maybe just my understanding.
  3. Replies
    9
    Views
    216

    Re: Read and write new csv file

    I guess that would work if he saved the Excel file to a .csv format (orig.csv), correct?
  4. Replies
    47
    Views
    585

    Re: Icons for file types

    I know there are some real smart and talented folks helping you with this, and I am only a novice at this game comparably, but, to answer your question, (maybe it was answered in this long thread...
  5. Replies
    14
    Views
    149

    Re: Listbox item select

    Roger! Have fun!
  6. Replies
    14
    Views
    149

    Re: Listbox item select

    Did you need your lbox to be multiselect 2?
  7. Replies
    14
    Views
    149

    Re: Listbox item select

    So, do you NEED it Multiselect in your program? If so, I'd have to relook it for you....
  8. Replies
    14
    Views
    149

    Re: Listbox item select

    ?
    sure does....
    I'll attach the simple demo.....129901


    EDIT: Put a debug.print list1.text before the end of the command button End Sub and it will print out each of the items in your listbox.
  9. Replies
    14
    Views
    149

    Re: Listbox item select

    and this?


    Option Explicit
    Dim itemClicked As Integer
    Dim booStart As Boolean
    Private Sub Command1_Click()
    If booStart = False Then
    booStart = True
    List1.ListIndex = 0
  10. Replies
    9
    Views
    216

    Re: Read and write new csv file

    Will this do what you need?


    Option Explicit

    Dim oExcel As Excel.Application
    Dim obook As Excel.Workbook
    Dim oSheet As Excel.Worksheet

    Private Sub Command1_Click()
  11. Re: how not allowed user input a space in the first word in the textbox ??

    WHY????????????? Maybe if we understand why you want to do whatever it is you want to do, then maybe we can better assist. Agree totally with DM...very strange request (without further...
  12. Re: [RESOLVED] How to get the number of items in one field

    Ah the olde defeatist attitude! :)

    I keep trying until I solve the issue (NORMALLY) with some method, otherwise I never learn. (QUIET dilettante!)
  13. Replies
    14
    Views
    232

    Re: Using a variable to open a form

    Okay, how about THIS method? The only thing that has to be done is make sure all forms OP wants loaded later are loaded at startup, then hidden. After that, variables (or...
  14. Replies
    14
    Views
    232

    Re: Using a variable to open a form

    Okay, say OP has 3 forms: frmMain, frmRed and frmBlue (name and filenames). How would you modify your code. I made the assumption (there I go again) that OP had some pre-existing forms (could be...
  15. Replies
    14
    Views
    232

    Re: Using a variable to open a form

    AHgree.
  16. Replies
    14
    Views
    232

    Re: Using a variable to open a form

    Here's and example...add a combobox, two commandbuttons and three forms in a new project. On Form1, insert this code:


    Option Explicit

    Private Sub Command1_Click() 'used to load combo1 with...
  17. Re: How to copy and paste formula values into a new worksheet

    like DM said....belongs in the Office Development Forum (although someone may quickly solve your problem here).

    I'll ask a Moderator to move this thread.
  18. Replies
    13
    Views
    166

    Re: MSHFlexGrid problem

    example:


    MSHFlexGrid1.Col = 1
    MSHFlexGrid1.Row = 2
    MSHFlexGrid1.CellBackColor = vbYellow

    EDIT: Sorry, here is an example of FORECOLOR
  19. Re: How to get the number of items in one field

    It's not that...but I can't advise much because of the lack of information. How is the data getting put INTO the table in the first place? WHAT data is getting put in? You MIGHT want to add a DATE...
  20. Re: How to get the number of items in one field

    That is what I thought...one field, value 141516, but if there were 4 'marks', it might be 14151619, correct? If so, totally agree with techg.....you probably need to do a little research on how to...
  21. Re: [RESOLVED] How Do I use 2 Where Clause In 1 Row

    wrong field NAME, right?
  22. Re: How to get the number of items in one field

    Obviously you need a simple count query...but I asked you before for a look at your database...(fields, type fields, data), but you haven't provided it. So, I'm outa here.
  23. Re: [RESOLVED] How Do I use 2 Where Clause In 1 Row

    resolved? How did you solve your problem?
  24. Re: How Do I use 2 Where Clause In 1 Row

    You get the error on that line?
    1-What does this look like when you debug.print the query? (Remember all the advice we have given you about checking out your queries before opening/running them?)...
  25. Re: How to get the number of items in one field

    If you want some code (rather than knowledge on how to do this), attach your table....or at least describe the fields and what are in them.
  26. Re: How to get the number of items in one field

    @TysonLPrice
    Normally, but without them, it is the same as =
  27. Replies
    4
    Views
    167

    Re: How to make 3D form from VB6?

    No---I guess I read it wrong...what do you mean by 'changes shape'? At what point do you want it to change? After so many pixels? not sure what you are asking.

    EDIT...do you need the form to be...
  28. Replies
    4
    Views
    167

    Re: How to make 3D form from VB6?

    Something like this (?????????????)

    129815
  29. Re: Is There a Way To insert To a table more then 1 record ?

    Here is a simple example of looping through a combobox and putting the 'rent' values (from the combobox) and the date values (advanced by a month each time) into a database:


    Dim mySql As...
  30. Re: Most examples in the CodeBank are profoundly difficult to understand ...

    Post this in the Discussion forums, not here.....
  31. Re: is there a way to convert a stored number in the table to its color

    So, you are saying that you have a numeric field to identify a color, that is, you have a 1 in there (for example) that you want to represent the color Black in your listview? Use a function with a...
  32. Re: Help: Inserting new row and updating existing row

    No, but you can put them BOTH in the click event of one button.

    A SELECT is a select; and UPDATE is an update. Two different 'statements'.
  33. Re: many controls in the screen How how do I fit

    Been designing (and inspecting others') user input screens for decades. A cluttered form like OP presented is NOT-user friendly. Hard on the eyes, confusing to the brain. Even if one uses a...
  34. Re: many controls in the screen How how do I fit

    I like that option....maybe I'll use it in one of MY projects someday...good suggestion.
  35. Re: many controls in the screen How how do I fit

    Not good at Portuguese, so don't fully understand the labels on your form. What it looks like to me is that you simply need to group certain functions/inputs into different areas and divide your...
  36. Re: Best way to empty an element of a multidimensional array.

    What do you mean 'empty'? At any time you can set individual elements of arrays to 'blank' (string arrays), or to 0 (numerical arrays).

    Difficult to understand what you are really trying to do...
  37. Re: many controls in the screen How how do I fit

    Depending upon what you are doing, the SSTAB control is probably a very good option....in your browser, notice how going from one tab to another gives you a new 'screen'...if you can group your...
  38. Re: many controls in the screen How how do I fit

    Multiple forms, hidden/unhidden frames/tabs....
  39. Re: [RESOLVED] Query not returning any record

    GOT IT!!!! You HAVE to use 'something', like % or _, but just ".... Like 'TEST'" ...... would not work.
  40. Re: [RESOLVED] Query not returning any record

    True, not true?

    I asked a similar problem the other day and ended up using the % sign as described by diletante and what I found eventually. I just retried that same query (which worked with the...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width