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 gkittelson 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: *

  1. djugene188

    Conditional Order By

    Thank you so much for your help! I did not think about using NZ...
  2. djugene188

    Conditional Order By

    That did it. Thank You! A star for you.
  3. djugene188

    Conditional Order By

    I've searched the forums for a solution to this, but couldn't find anything quite for my situation. I have a client table that I need to sort in two different ways based on if the company field is null or not. If the company field is null then the rows need to sort by Last Name, First Name. If...
  4. djugene188

    Combine 3 tables in query with 1 field updateable?

    Duane, Wow --- that did the trick! Wow, I will remember this for future reference for sure. Something so simple... PHV, Thank you once again for your help. I just wanted to let you know that I've learned a lot from many of your posts. Have a great day guys! I can't thank you enough...
  5. djugene188

    Combine 3 tables in query with 1 field updateable?

    Duane, Thank you so much for your suggestion. It also pulled the right information, but I am still not able to update the results. Question --- When two inner joins are performed, is that supposed to lock the table? Once I took out the 2nd Inner Join on tblEmail, I am able to update the...
  6. djugene188

    Combine 3 tables in query with 1 field updateable?

    PHV, This almost worked. It returned the records properly, but I was not able to add any info to the fldsend. It looks like it locks the table once the 2nd join takes place. I tried the code with only the first join and I was able to make changes to the data available. If there is anything...
  7. djugene188

    Combine 3 tables in query with 1 field updateable?

    Thank you, PHV. I will give that a try. Djugene
  8. djugene188

    Combine 3 tables in query with 1 field updateable?

    Sorry to bother, but any help is truly appreciated. I have 3 tables: tblClient, tblRequests, tblEmail Relationship of tblClient to tblRequest is 1 to Many Relationship of tblClient to tblEmail is 1 to 1 tblClient -------- PersonID (PK) FName 1 Eric 2...
  9. djugene188

    Autokeys Glitches in form

    Thanks for the reply, TheAceMan1 ---- Unfortunately, Autokeys doesn't work for some reason unless I turn on the Key Preview and select the autokeys in the On Key Press event. (And then I also get all of the un-wanted keys). I can activate the Macro from the Objects listing page but not from...
  10. djugene188

    Autokeys Glitches in form

    First off, I want to thank the forum(s) -- this place has been a tremendous help with my project by searching for the answers. Here's something I can't find though.... I have a main form in Access 2000 that I have set to yes for Key Preview. The On Key Press event is set to autokeys. The...

Part and Inventory Search

Back
Top