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 davidwv

  1. davidwv

    Trap Keypress or Keydown on database start

    Thanks for the tip. I agree with the "anti-macro" sentiment, btw. Before I got your tip, I "engineered" another solution. It wasn't clear in my question, although it was hinted at in the "subject", but I wanted to detect if the user was holding down a key during...
  2. davidwv

    Setting criteria in a query with VBA

    Do you have to have 2 queries? Without knowing more detail, it sounds like a single query could handle it (maybe -- sometimes Access doesn't have the flexibility you'd like). In "normal" SQL, it would be something like (Table2 is the table or tables that Query2 is based on...likewise...
  3. davidwv

    Setting criteria in a query with VBA

    I'm a little confused: Where does "field1" live? When you say "Open query2", do you mean execute it? And does "appends to the table" mean "by running query2"? Flesh it out just a little more and I'm sure we'll be able to help. -w
  4. davidwv

    Trap Keypress or Keydown on database start

    I'd like to be able to determine, in a module, if the user is pressing a certain key (doesn't matter which, can be normal key or shift/ctrl/alt or combo). I need to make this determination before anything else happens. I figured I'd have an Autoexec macro run my module, but from there I can't...
See more

Part and Inventory Search

Back
Top