Search results

  1. I

    Report shows the uniqueID value instead of the text

    I have my table set up to lookup value from another table and have created the relationships. Both tables have unique IDs (autonumber) as the primary key. When i add the field to the table, the unique ID appears, and not the text value. Is there a way to fix this, or did I set up my...
  2. I

    How to correct an incorrectly-setup db

    I am working with a database that was created weird and I am trying to fix it. 2 Main Issues: 1. Many tables, all of which contain some similar information (i.e. Product, Lot, StartDate). How can I create one separate, "live" table or query to list these 3 field from all tables? (By live...
  3. I

    How to prevent duplicate entries - combination of 3 fields

    I am trying to prevent duplicate entries, but the record is only duplicate if 3 fields are identical between records. For example: CC# (unique) Number (*) Title FromRev (*) ToRev (*) Changes Void If [Number], [FromRev], and [ToRev] match another record, the user should not be allowed to go...
    • InDFW
    • Thread
    • Replies: 2
    • Forum: Forms
  4. I

    Database Title Changes to db1, then db2, then db3, etc. What's Happening?

    It makes copies of itself - some can be opened, some cannot. I try to delete the smallest-sized ones before anyone does any work in any of them, and my department has accepted the fact that our database does this and our database is named "db1" or whatever number is the current one for the...
  5. I

    Need a Side 2 of report, but it is has no data

    I have a report that is many pages long. When it prints, it is supposed to have a back-side for each page that is that same back-page for each report page. How can I do this without running it through a printer/copier a second time? Also: Front Side = Page 1 Back Side = Page 2, etc.
  6. I

    One Line Item per Report Page

    How can I manipulate the formatting of a report to only print one row/line item per page?
Back
Top Bottom