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!

Search results for query: *

  1. thuzinec

    Automatically Pick up the ContactID in a form

    Thank you so much! This is just what I’ve been wanting to do with several fields, as well as, buttons. Your terrific! Terra
  2. thuzinec

    Automatically Pick up the ContactID in a form

    On my frmContacts I have a button “Preview BOID Rpt” the button is linked to open a report that is based on the user entering the contacts ID number. I would like to have this button automatically pick up this number (the record that the user is currently on) when the "Preview BOID Rpt" is...
  3. thuzinec

    Combined Address

    I want to thank all of you for trying to help me resolve my problem. I found out a way to solve this problem and I'm listing the code below, just in case anyone else did not structure their database correctly. Thanks All! SELECT DefaultAdd.DefaultAddress , DefaultAdd.ContactID ...
  4. thuzinec

    Combined Address

    Ok, the first Union query worked. It list all of the address in one column, not just the default but all combined in one column "work" and "home". I am assuming that when you refer to "Contact" I should list it as one of the fields in my tblContacts? Like "ContactID" or should it be the name of...
  5. thuzinec

    Combined Address

    Thanks for your response, I tried that but it does not work. I designed a qry that uses the table tblContacts and I have calculated fields named "MainAddress": MainAddress: IIf([Forms]![frmContacts]![DefaultAddress]=1,[WorkAddress],[HomeAddress]) and "MainCity": MainCity...
  6. thuzinec

    Combined Address

    I have one tblContacts that has "Home" and "Work" address included within it, I also have an option button 1="Work" and 2="Home". I need to prepare a mailling report, but only for the defaut address. Someone suggested that I create a calculated field. I tried this but all that it is doing is...

Part and Inventory Search

Back
Top