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 Chris Miller 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: bjj
  • Order by date
  1. bjj

    Incrementing with Dmax

    Hmmm...why should Job # be a primary key? I agree with Rewdee that this sounds like a job for relationships – the database will be a lot smaller and easier to manage, especially if there’s a lot in common between job 25A, 25B, and 25C. Having said that, there are a few issues. Incrementing a...
  2. bjj

    Writing a query in VBA to populate text box

    Is the employee ID a number? If it's a string, you need to include "'" characters before and after the text. So, you would type: bill = DLookup("[Billing ID]", "Billing", "[Employee ID]='" & Forms![Entry]!txtEmployeeID & "' AND [Project ID...

Part and Inventory Search

Back
Top