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 strongm 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. hijinx

    Identifying Missing Records

    Thanks for the guidance. Worked like a champ!! Gold Star for you!
  2. hijinx

    Identifying Missing Records

    I have seen some threads similar to this, but can't get any of them to work. I work for a financial company and all of our clients are supposed to make monthly deposits. At times, however, the client chooses to skip a deposit. I need to determine a list of clients and the months for which they...
  3. hijinx

    Prevent duplicate records using 3 fields - not table definitions

    Thank you for your responses. I will try them out today.
  4. hijinx

    Prevent duplicate records using 3 fields - not table definitions

    I have a small medical claims database that needs to check for duplicates on a combination of 3 fields: Date of Service, Amount, Medical Provider (example: 12/15/2004;$25.00,Jones Pharmacy. The problem is that the user needs the ability to override any warning and enter the "duplicate" record...
  5. hijinx

    New Records and Changed Records

    I'm trying to distinguish between a New record and a Changed record. I have a Y/N field hidden on my form called "Changed". Whenever a record changes, I want the YN field to be updated to True. I am currently using the form's Dirty property to do this. However, New records are being...

Part and Inventory Search

Back
Top