Recent content by netnewb

  1. N

    further discussions about parameterized queries (PQ)

    That doesn't follow at all from what I said. Total non-sequitar. Doesn't even make sense, much less answer my argument. Rants are no substitute for reason. Yep, and it doesn't amount to much in most cases. Certainly not enough to evoke an edict (much less ranting). Indeterminate. You need to...
  2. N

    further discussions about parameterized queries (PQ)

    John, "Never (never ever!)" are very strong words. You give no reason or explanation. Passed parameters are a feature in ADO, which talk to a feature in (generic) SQL server. Just because the features exist doesn't make an imperative to use them. As I see it, SQL is an ancient language which was...
  3. N

    Solution: How to use a UID field in a toolstripcombobox

    True, of course. But the purpose of this thread was to indicate to other Access/VB developers how to swiftly use multi-field comboboxes. And I was correcting you correcting me when you said that .net is as RAD as can be.:D
  4. N

    further discussions about parameterized queries (PQ)

    There are times when parameter queries won't work. They are not very flexible. Let's say you make a custom query dialog, for flexible reporting. User enters one/more parameters: one/more customer names, a dollar amount, less than or greater than (e.g. order amounts <$100, or >$100), and one of...
  5. N

    Solution: How to use a UID field in a toolstripcombobox

    Re: building SQL strings, you missed my point/example. For a simple thing like looking up a uid, I can understand generally how your code is more formal/correct. But when building a multi-part user-customized query, such as for a report (e.g. choosing 1/more customers to include, and/or gt/lt a...
  6. N

    Solution: How to use a UID field in a toolstripcombobox

    Thanks for the feedback I appreciate the pointers, corrections, and markup. And the links too (I'll be busy for a while now!) My intention was to leave a breadcrumb for the next guy that comes along with similar background/intentions. My background is strongest in Access, more than vb6. Your...
  7. N

    Solution: How to use a UID field in a toolstripcombobox

    I'm posting this for archive, for benefit of other beginners, because I had trouble finding a solution to this. I'm coming from solid Access background, trying to rebuild an access database application, struggling with .net's strange new hoops. In previous versions of VB (i.e. Access, VB6...
  8. N

    ToolstripComboBox

    YES! That works! JohnH, thanks! That worked. Just use toolstripcombobox1.combobox.datasource, .valuemember, and .displaymember I search about 6 google hits before I found this.
Top Bottom