Search results

  1. J

    Criteria Across Two Fields

    Awesome. Thank you.
  2. J

    Criteria Across Two Fields

    Thanks, though I'm unable to tell if this works because when it runs it prompts me for a date. Let me try to re-explain. Say its all in one table (though in fact, the case names correspond to unique IDs in another table, and the dates correspond to unique IDs in a third table): Case Name |...
  3. J

    Criteria Across Two Fields

    Hello, I need help with what seems to be a basic problem. I'm going to try to cut out all of the superfluous elements and explain it in the following way: Say I have a query which is pulling data (in memo form) that records different language I have used to summarize different cases I am...
  4. J

    Subforms with Tabs

    I believe this is a simple question; it seems I'm just simpler. I've created a form that basically includes all of the fields of the central table of my small database. Each key-numbered entry in the main table belongs to one client. I created two separate tables for two different types of...
  5. J

    Editing Primary Key Help

    Hi, I've inherited the management of a relatively complex database (~15 related tables, union queries, &c.) that hinges on a few basic primary keys. I have split the database, and distributed the front end client to other users. The most important primary key is that assigned to each client...
  6. J

    Union Queries when Splitting Database

    Nevermind, thanks so much this was perfect.
  7. J

    Union Queries when Splitting Database

    What is meant by "import relationships"? Is this a separate operation?
  8. J

    Union Queries when Splitting Database

    Sorry, I didn't do exactly as you said. Give me a second.
  9. J

    Union Queries when Splitting Database

    So did what you suggested. There are two problems: (A) I wasn't given the option (or don't know how) to import relationships to the new front end. Though they appear to have been imported. EXCEPT that the table/query produced by the union query no longer shows up in design view, and the...
  10. J

    Union Queries when Splitting Database

    Hi, I am trying to split a fairly complicated database (~10 tables, with ~10 enforced relationships, etcetera). A big part of the design is a union query that mediates between two tables, into a third. I need to split the database so that I can distribute the front end around to other users...
Back
Top Bottom