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!

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

Search results for query: *

  • Users: ajetrumpet
  • Order by date
  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?

    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...
  6. 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...
  7. 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...
  8. 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)...
  9. 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...
  10. ajetrumpet

    Form Criteria

    Yes, I tried the Nz function and come up with blank results
  11. 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...
  12. 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?
  13. ajetrumpet

    Form Criteria

    Thus, the purpose of the Nz is....? Definition?
  14. 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...
  15. ajetrumpet

    Form Criteria

    Well, hello again PHV....this code is from a DB I made a while back for an invoice log.... [code]SELECT Invoices.ProjectNo, Invoices.Vendor, Invoices.PO, Invoices.InvoiceNumber, Invoices.Voucher, Invoices.Amount FROM Invoices WHERE ((Invoices.ProjectNo)=Forms![Search Form]![Project Number] Or...
  16. ajetrumpet

    Form Criteria

    Say I have 10 dropdowns in a form and a user can select any combination or all of them for the underlying query criteria. Do I need to manually write this query in design or SQL using [AND's] and [OR's], or can it be simplified? -J
  17. ajetrumpet

    The Future Computer

    Does it cost that much too?
  18. ajetrumpet

    Speak English 2

    Does anyone think that some of the support people might not know what's going on because some of the calls they get present problems that are out of the ordinary for normal operation of the software, hardware, or whatever you're calling about...? I'd like to hear the description of the problem...
  19. ajetrumpet

    The Future Computer

    Comments on the tech in Demolition Man anyone? I loved this things they knocked you out with. I think the cops are working on such devices now, so they don't have to shoot people anymore if they get out of hand...

Part and Inventory Search

Back
Top