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 Chris 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. geolemon

    Need to create multi-table form with "update or insert" logic

    Something I'm not understanding - it seems like the combobox isn't behaving like I expected it to: (the form is currently built with reference to a stored query - a simple "select * from..." all the tables I listed above, joined by PKs to the Inventory table.) If I open my new form, and start...
  2. geolemon

    Need to create multi-table form with "update or insert" logic

    I actually have a pair of tables ("process" and "transaction log") that I'm using to record not only the last change date/time, but to allow me to record a history of changes that could track through a customer or ISO (or internal) audit. I actually didn't want to have a timestamp in the...
  3. geolemon

    Need to create multi-table form with "update or insert" logic

    My table structure is pretty simple - these are pretty preliminary at this point, I may have a column or two more in a few as I review requirements. The Inventory table is a central table. The remainder are dimension-style tables joined to the Inventory table by their primary keys (to matching...
  4. geolemon

    Need to create multi-table form with "update or insert" logic

    Thanks, that's beautiful info! Bear in mind, *all* information I'm sure lives in Access books - in discrete form. To contrast, the question that I'm asking about is a composite application: 1)creating a form 2)using a stored query (thanks for that piece) to handle multiple tables 4) using a...
  5. geolemon

    Need to create multi-table form with "update or insert" logic

    I have a feeling that detail is several layers beyond where I am at... and/or Access can't create a multi-table form? A combo box, in my experimentation so far, doesn't appear to be a control that I can use (doesn't seem to do what I want): What I want to do essentially is create an updatable...
  6. geolemon

    Need to create multi-table form with "update or insert" logic

    New development effort here, seeking advice on the best way to pull it off. I'm more familiar with SQL Server and DB2, but this is perfect app to get me some experience with Access: In this, I have created an "inventory" table with relationships to several other [dimension type] tables...
  7. geolemon

    What is the best way to document an Access Database?

    The risk with documenting outside of your database instance is this: What happens if your documentation file is lost, or perhaps simply someone using the database doesn't know it exists, or inadvertantly moves it, etc? Not to mention, if you use comments (just like you do with C++) in VBA...

Part and Inventory Search

Back
Top