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!

  • Congratulations Mike Lewis 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. rdholdford

    What type query and how?

    I have an Access database with three tables, Family, Clients and Sessions. The Family table has an autonumber field, F_ID that identifies a particular family. The Clients table has an autonumber field C_ID that identifies all members of the family and includes sex, age, race etc. for each. The...
  2. rdholdford

    Table Relationships

    Thank you very much. This is just what I needed. I really appreciate the support
  3. rdholdford

    Table Relationships

    I am developing or rather amending an existing database for a non-profit and I am having difficulty visualizing table relationships The agency wants one master database. It has 12 programs (may add more) that serve families to prevent child abuse/neglect. Families can have members that are...
  4. rdholdford

    relationships and keys disappeared?

    Posted initially in other forum but this seems more appropriate. I have an Access 2003 database with about 10,000 records. On a network and used by several employees. The database has not been split. When attempting to amend or change data to one form, it won't accept changes and when I try to...
  5. rdholdford

    macro fails, table relationships disappeared

    I have an Access 2003 database with about 10,000 records. On a network and used by several employees. The database has not been split. When attempting to amend or change data to one form, it won't accept changes and when I try to close the form I get a message saying "The command or action 'Save...
  6. rdholdford

    text box displays odd value

    When I enter a value in a textbox such as "129" the value displayed on the form, after I tab to a new field, changes to "1.29E+02". The value recorded in my table is "129". Why is my form displaying this odd value? Howcan i make it display the entered value? Thank you
  7. rdholdford

    Add new table and form to split database

    I have a split database and want to add a new table and corresponding form but I dont't know how to link them. Please help!
  8. rdholdford

    Save results of calculated field to table /coping with reverse scores

    I have a form for a 75-item psychological test. I need to calculate totals for the entire test and also totals for subscales. The test is a true-false test with data entered as 0 or 1. I have made calculated fields that will score some of the subscales but I need the results to be saved in the...
  9. rdholdford

    Problem with Unrepairable Databases

    This may help or maybe not. You may have a corrupt record. The database will not compact if a record is corrupted. I have found corrupted records by going to my main table selecting a group of records and then right click and copy. I dont paste them anywhere, I just keep selecting records and...

Part and Inventory Search

Back
Top