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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mattpar

  1. mattpar

    Help using query results as variables

    .... That is a very good point. Though took that bit out and it still doesn't work, so I'm guessing that wasn't affecting it and was just extraneous. Thanks for pointing that out though.
  2. mattpar

    Help using query results as variables

    to cycle through the location records in the Status_Anomaly_Count table.
  3. mattpar

    Help using query results as variables

    Very true, should have given a bit more info. I guess to begin I made the code, by request of my supervisor, because we will eventually have other criteria to also count. Also I used the Status_Anomaly_Count table to query for the data as we may also filter out some locations. So I made the...
  4. mattpar

    Help using query results as variables

    Thanks for the quick reply, I had thought of just using queries like that but my supervisor wanted the code (dont ask me why). Still, I tried your suggestion and it now gives me an error "Operation must use an updateable query".
  5. mattpar

    Help using query results as variables

    Hello, I have been trying to get this code to work for a bit now and just can't figure it out so I could really use some help. A quick note as to what it is that I'm trying to do is basically count records in one table, with criteria, and then put that count into another table. So I have 2...
  6. mattpar

    Module no longer working when migrated to an accdb

    Thanks for the advice, I'll keep that in mind as I go through the rest of this DB.
  7. mattpar

    Module no longer working when migrated to an accdb

    Thank you very much dhookom that solved it. though I still find it odd that the code worked when in an mdb but suddenly not when moved to an accdb. Oh well, it's fixed and again thank you.
  8. mattpar

    Module no longer working when migrated to an accdb

    Okay, I'm currently stumped on a coding issue I have. Right now I am migrating a database from an mdb to an accdb and an important bit of code now no longer works. essentially what the code does is take data from fields in 2 separate table, adds file extensions to them and then combines this...
See more

Part and Inventory Search

Back
Top