dcsimg

Search:

Type: Posts; User: jPaulB

Page 1 of 3 1 2 3

Search: Search took 0.05 seconds.

  1. Replies
    2
    Views
    512

    VB Script What would this snippet do?

    Hi Folks,

    I found this piece looking at a web page through the "View Source" window, and want to know what this could/would do?

    <a class=prodnase href="doorknobs.asp">Door Knobs</a>

    Thanks...
  2. Replies
    4
    Views
    469

    Re: a "REAL" beginners' question

    Hi,

    I've been using a worksheet to do all this for well over a year, so I have the what well placed in mind.
    I'm just getting tired of the layout because the spreadsheets do carry from column "A"...
  3. Replies
    4
    Views
    469

    a "REAL" beginners' question

    Hi Everybody,

    I am using Microsoft Excel (2003) to manage my business. I drive a taxi in Canada.
    Each day I enter stuff like beginning and ending kilometers, gas used, revenue earned, etc. etc....
  4. Replies
    5
    Views
    774

    Re: TreeView & Relationship Keys

    Holy Smokes...

    Thank you both, Ellis Dee and Merri, for your help.
    I am so facinated with the TreeView control. Strangly, very little "fun" stuff seems to have been done with it, at least in...
  5. Replies
    5
    Views
    774

    [RESOLVED] TreeView & Relationship Keys

    Hello everybody,

    I've been kicking this TreeView issue to death, and keep banging around in the "how to use Relationship Keys" theory I need to complete child nodes. I clearly don't understand...
  6. Thread: Using an Array

    by jPaulB
    Replies
    2
    Views
    444

    Using an Array

    Hi Everybody,

    I'm building a treeList from a recordset drawn from a MDB table. This recordset is always SORTED alphabeticaly.
    A problem THAT creates is that several of the recordSet names will...
  7. Replies
    15
    Views
    883

    Re: I need some help on a TreeView issue please

    Hi jcis,

    Yep, there is an account "A".
    It contains a number... a 1 would refer to a Revenue account and a 2 will refer to an expense... and a 3 for Equity and so on.
    The field I use for an...
  8. Replies
    15
    Views
    883

    Re: I need some help on a TreeView issue please

    Thank you so much, folks. Ity'll take me a bit to get the logic understood, that's for sure.

    JCIS... if I use your code, I will get a new error. 35601 Element not found.

    I've tested everything...
  9. Re: VB - A demonstration of how to generate unique keys for a TreeView

    Thanks for all the help, people... but I am still missing something... something critical.
    If all of the keys are all unique... how do the child-elements know which parent to attach to?

    -Paul-
  10. Replies
    15
    Views
    883

    Re: I need some help on a TreeView issue please

    I'm not sure what you mean leinad31. I've added a new autonumbered field to the table and made it the primary...

    But the code still doesn't seem to work.

    I don't understand.

    Thanks,
    Paul
  11. Replies
    15
    Views
    883

    I need some help on a TreeView issue please

    Hi Everybody,

    I'm trying to manage filling a treeView from the contents of a table, but I'm getting lost using the "key" element of the TreeView.Nodes.Add procedure.

    The recordset used for the...
  12. Replies
    6
    Views
    453

    Re: a TreeView "key" question

    Ahhhhhh Nuts!
    Nuts!
    Ahhhhhh Nuts!

    Ok.. well that's that! I'll go stare at the dataBase-table for a while. Figure something better.

    Thanks jcis,

    -Paul-
  13. Replies
    6
    Views
    453

    Re: a TreeView "key" question

    Thanks Guys...

    Perhaps I'm screwing up on the notion of the "key" property then?

    These are all treeView.ADD elements and I'm trying to attach several records matching the "key"
    [position 3 ......
  14. Replies
    6
    Views
    453

    Re: a TreeView "key" question

    I don't understand what you mean. Several of the records will meet each conditions. The code ought to be building several treeView nodes.

    Paul
  15. Replies
    6
    Views
    453

    [RESOLVED] a TreeView "key" question

    Hi Everybody,

    Im building a simple treeview... but I trip over a run time error that tells me that: Key is not unique in collection

    What am I missing? (the Key ought to be the third element of...
  16. Replies
    3
    Views
    424

    Re: How does a comboBox "know" ...

    Thanks PMAD!!

    Thats such a simple solution... so simple that I wouldn't have thought of it for another six months!

    The K.I.S.S. principal in action!

    Thanks again,
    Paul
  17. Replies
    3
    Views
    424

    [RESOLVED] How does a comboBox "know" ...

    Hi Everybody,

    I have a couple of comboBox controls that are filled from a table. Users are able to add to any of the list properties of those controls.

    I would like to capture any new item that...
  18. Replies
    3
    Views
    2,965

    Re: "comboBox.ItemData" help please

    Thanks RhinoBull,

    Naw, the fieldname "acct_head_id" does exist in the table, but I had mispelled it.

    I'm sorry.. this was such a silly-assed issue and I should have caught it myself

    Paul
  19. Replies
    3
    Views
    2,965

    [RESOLVED] "comboBox.ItemData" help please

    Hi Everybody,

    I'm trying to fill a comboBox from a table. The table is simple, just a category "Name" in text and "index key" an integer. I am trying to include the index key in the ItemData...
  20. Replies
    2
    Views
    362

    How do I accomplish something like this?

    Hi Everybody,

    I've been trying to resolve this kind of issue through a comboBox for a while, and have turned so many circles that I've disappeared! I need to start over and restate the problem:
    ...
  21. Can I load two or more columns to a comboBox

    Hi Everybody,

    It's occured to me that the comboBox control would be so much more versatile if I could attach a second "column" to a comboBox list contents.
    That way, I could attach an index key...
  22. Replies
    3
    Views
    447

    Re: "comboBox text entry" problem

    Thanks Hack, for your reply.

    The comboBox is loaded from a table, as follows:



    Public Sub FillAcctType(pCmb As ComboBox)
    Set rsData1 = New ADODB.Recordset
    sSql = "SELECT acct_title...
  23. Replies
    3
    Views
    447

    [RESOLVED] "comboBox text entry" problem

    Hi everybody,

    I have two comboBox controls on a form, and one of these controls isn't behaving itself!
    I believe I need to find and eliminate code that tells the control how to accept data. When...
  24. Replies
    2
    Views
    754

    "Where" do you lock/unlock a record?

    Hi everybody,

    Stepping into a new world of ADODB connections is WAY better than DOS and clipper... but strange nonetheless:

    User "A" opens a recordset from a shared table... and then wanders...
  25. Re: Can I do "this" in a MsgBox (strPrompt)?

    Thanks DayJo

    Fits perfectly

    Paul
  26. [RESOLVED] Can I do "this" in a MsgBox (strPrompt)?

    Hi Everybody,

    I wonder if I can manage a multi-line strPrompt (perhaps even formatted?)in a message box? Something along the way of:

    Attention
    The Power has been turned off

    Many...
  27. Why is this making me NUTS? (how do real programmers do it)

    Hi everybody,

    This issue is making me nuts, and I'm 100% sure most of the members here have fixed their conflict. I hope you'll help me.

    I have a comboBox that I fill from a City-Name table....
  28. Replies
    7
    Views
    472

    Re: a comboBox "event" question

    Thanks Guys,

    I guess "keyPress" is it. I'll work my code into that if the key was the <Enter> key.

    Thanks again all
    Paul
  29. Replies
    7
    Views
    472

    Re: a comboBox "event" question

    Thanks for the tip Pasvorto, but LostFocus() doesn't trigger from an <Enter> key either.
    KeyPress() would, but only because <Enter> is one of a couple hunderd keys. I'm trying to isolate just the...
  30. Replies
    7
    Views
    472

    [RESOLVED] a comboBox "event" question

    Hi everybody,

    I'm planning to fill a comboBox with city data retreived from an Access database table.
    A user will select, or add, their city from the comboBox list.

    Either way, folks will...
  31. Replies
    1
    Views
    288

    [RESOLVED] an SQL construction

    Hi everybody,

    I wonder if someone will tell me where I've gone wrong building the following SQL statement:

    sSql = "SELECT * FROM tbl_acct_title WHERE acct_title = " & cmbAcct_Type.Text & " ;"
    ...
  32. [RESOLVED] Parsing a string until a specific character is found

    Hi everybody,

    I have in mind to parse a string for the first couple of characters, like:

    "12..This is a string" or "12...This could be another one" and "12345..This is yet another"

    What I...
  33. Replies
    1
    Views
    554

    Form disappears on Min Button

    Hi Everybody,

    I have forms placed inside an MDI form. When I use the "minimize button on any of the child forms the form will disappear from the MDI form space. (The form will be apparant only...
  34. Replies
    1
    Views
    404

    event selection via TreeView nodes

    Hi everybody,

    I'm asking if I could trigger an event by clicking or double-clicking on a node in a TreeView.
    I imagine such a thing is possible, I can see it work in explorer and other directory...
  35. Re: Why this "35610 Invalid Object" violation in highlighted line

    You know, I've added keys like you suggested si_the_geek, but my whole notion requires that I pass this Key around by reference.

    rsData2!acct_title like this:

    Parent Node:
    tvExpenses.Nodes.Add...
  36. Re: Why this "35610 Invalid Object" violation in highlighted line

    WOW!!

    Thanks for the .ADD tip, and super thanks for the link you've provided.

    Interesting to notice that aikidokid is also new to "Access and Databases (and limited ability with VB6 as well)"...
  37. Re: Why this "35610 Invalid Object" violation in highlighted line

    Thanks for the help,

    You're right, re_turner_jr, I had not included that line. I would have had a forever loop if you hadn't noticed and mentioned it. Thanks.
    I guess KEY might be the part I need...
  38. Why this "35610 Invalid Object" violation in highlighted line

    Hi everybody,

    The following code ought to fill a TreeView with Parent, Child and GrandChild nodes but fails (on the highlighted line) with a "Run Time Error 35610". Other than refering to an...
  39. Replies
    1
    Views
    391

    [RESOLVED] How do I state this?

    Hi everybody,

    How should I state this:



    FOR EACH record IN recordSet
    :::
    NEXT
  40. Replies
    7
    Views
    454

    Re: Treeview Code confusion

    Thanks Fellows,
    I'm actually getting somewhere, even if that's only half way there.
    This is what I've learned so far. My code allmost works, but I am probably missing a comma or something simple...
Results 1 to 40 of 85
Page 1 of 3 1 2 3



Featured


Click Here to Expand Forum to Full Width