Recent content by ChoiceTom

  1. C

    Learning Opportunities

    I have a background in DB work and programming, but it's been a bunch of years (crisis of faith, completely changed how I put a roof over my head). So what this amounts to is a fair degree of scrubbing the "rust" off and becoming current in tools and techniques. My thought was to focus on...
  2. C

    Learning Opportunities

    Thanks. Makes sense, I wasn't paying attention.
  3. C

    Learning Opportunities

    A sideline question, generated because of the knowledge demonstrated in your reply above. Is there an MS-Access set of classes from someone you'd either recommend, or at least have good things to say about? I'm having to build some tools to get things out of paper where I am at, and scraping...
  4. C

    Help on syntax for posting a form text field value to a field in the current row of the database

    I have a form. It is tied to a table. All of the fields pulled to the form from the "select fields" options post to their fields properly in the new record row in the database. There are two unbound text box fields that will be receiving data. These are unbound text box fields. When the new...
  5. C

    Help on syntax for posting a form text field value to a field in the current row of the database

    Probably very basic, but I'm missing the correct syntax to take the value from a text-box field on a form and assign that value to a field in the database, current row. The form properly opens to the next new row. This is a "child" form that opens when an "add record" button is pressed on the...
  6. C

    Assist requested. Providing a Query with criteria from a field on a form.

    Goal: To see a list of child-records populate a Listbox placed in a Tabcontrol on a form, with the Parent record information from a different table populating the main form fields. Problem Statements: 1) When the Training Form first loads, I'm getting a Query Parameter dialog asking me to...
  7. C

    How do I Count number of records based on Criteria in this scenario?

    :D Well, I'm going to feel silly if it's that simple. I appreciate the assist as I re-familiarize myself with the Access interface. I'll give this a go today, thank you.
  8. C

    How do I Count number of records based on Criteria in this scenario?

    Goal: To have a Button on a form that produces a summary list of Gage Types and how many of each is in the Item table. The button part is a non-issue, assigning either a macro or query is understood. Example: Surface Plates 27, Gage Block Sets 9, or even Micrometers 0. That there would be...
  9. C

    Greetings

    Hello, I'm a Quality Manager at a small manufacturing firm that has almost no "admin" or "quality" related personnel (I'm the only quality person on staff). As a result I am very slowly progressing the processes, software, tools, methods, etc., out of paper to something else. We do have a...
Top Bottom