Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by ajetrumpet

  1. ajetrumpet

    Speak English 2

    Not anymore really...actually I think the speed of processors are keeping up quite well with the general demands of users. Heck, most of the processors nowadays can't process faster than we can think!! That really ought to be enough, wouldn't ya think?? But then again, how much more data are...
  2. ajetrumpet

    The Future Computer

    I see on QVC now that they are advertising vocal recognition for microsoft programs. I watching it today and this dude was speaking into the mike things like "close window", "new paragraph" and "open microsoft excel". Seriously people, that's a little bit TOO MUCH talking for me! Pretty soon...
  3. ajetrumpet

    What would make computing better?

    I've heard a lot about Linux lately...are they biting into Microsoft's market dominance like Apple?? That's all Microsoft needs...
  4. ajetrumpet

    Speak English....

    I had a person ask me one time, "so how is the weather in Iowa today"?? I said...WHAT!? I didn't even think of that JSTEPH! Great point...that's pretty pathetic, don't ya think?
  5. ajetrumpet

    What would make computing better?

    X vs. Y?
  6. ajetrumpet

    What would make computing better?

    Who keeps getting told?? Are you reading too many magazines?? I guess I don't know what you're talking about really... As far as something happening, it's a fact that noone really knows, but if you want my opinion...it'll probably be about money, whatever it is. Isn't that what moves the...
  7. ajetrumpet

    Speak English....

    Well, the initiator of this griping pool returns to the scene of the crime.... I was talking with a co-worker today who told me that Dell lost a whole lot of business or had many upset customers or something because of their outsourcing frenzy. And the issue was understanding of the tech help...
  8. ajetrumpet

    Quoting Messages

    Ya know folks, I love this forum for one big reason...it does NOT quote entire messages with our replies by default!!! I have been on some other forums and you wouldn't believe how long messages can get. It's not really worth the time threading or even trying to help others when you have to...
  9. ajetrumpet

    Form Criteria

    Yes, this is entirely at the user's discretion, and I have gotten the Nz code to work, and I understand it as well. If all combos are left blank though, the entire table is shown in the search (via the [ValueifNull] portion). I understand why but I don't want it (not that it matters anyway)...
  10. ajetrumpet

    Form Criteria

    Here is the one working (for any combo of criteria entered) SELECT Invoices.ProjectNo, Invoices.Vendor, Invoices.PO, Invoices.InvoiceNumber, Invoices.Voucher, Invoices.Amount FROM Invoices WHERE (Invoices.ProjectNo=Forms![Search Form]![Project Number] Or Forms![Search Form]![Project Number] Is...
  11. ajetrumpet

    Form Criteria

    Yes, I tried the Nz function and come up with blank results
  12. ajetrumpet

    Form Criteria

    I know where the profiles are as well. The purpose was to invite a bit of conversation, but if you're not into that, I apologize. You certainly don't seem to be.... From my understanding, Nz is meant to substitute a value for a control is the variant is Null. If THIS form control is Null, I...
  13. ajetrumpet

    Form Criteria

    PH, I know where the help menu is....you should know a little bit about me by now. I guess you don't say very much, how long have you been working with MIS?
  14. ajetrumpet

    Form Criteria

    Thus, the purpose of the Nz is....? Definition?
  15. ajetrumpet

    Form Criteria

    Maybe you can read it better this way... SELECT Invoices.ProjectNo, Invoices.Vendor, Invoices.PO, Invoices.InvoiceNumber, Invoices.Voucher, Invoices.Amount FROM Invoices WHERE ((Invoices.ProjectNo)=Forms![Search Form]![Project Number] Or Forms![Search Form]![Project Number] Is Null) And...
See more

Part and Inventory Search

Back
Top