Recent content by iattlakerod

  1. I

    repair/compact database

    thanks, I think. I'll look around and see what I come up with. The idea sounds like it'd work but hopefully I'll find the answer within the forum.
  2. I

    repair/compact database

    I am tired of having to manually [Repair & Compact] my database. I have been trying to figure out how to do this automatically when closing the database, both in a single and multi-user environment. I've tried a few things but haven't been successful. Any Tips?
  3. I

    Subform lookup control

    Rich, thanks a lot. I kept trying to put the subforfm control info there but only worked when the subform was open by itself. This will be a useful tip. Thanks for the help. Oh, it worked by the way.
  4. I

    Subform lookup control

    I've created a form with a subform on it. On the subform I'm looking at 3 fields. Form name is: RepairOrder Subform name is: RepairOrderDetails 1) Part#...........combo-box 2) PartName.....combo-box -updated when user selects part# 3) Warranty......check box-Yes/No After the Part# is...
  5. I

    Using Calculations on report from 2 queries

    hey hey hey. That solution worked great. You know even as little as I have worked in Access Databases I've seen that used, but the thought never entered my mind. Such a "No Brainer" fix. That was of course what I expected, that after getting my answer I'd say to self, "duh". Thanks a...
  6. I

    Using Calculations on report from 2 queries

    Multiple query used in Report fyi- still fighting with this dog!...This is one way i've set the queries. Now this works perfectly however I've preset the dates. [GetMiles] query SELECT DISTINCTROW Units.UnitYear, Units.UnitN, Max([speedometer])-Min([speedometer]) AS Mileage FROM Units...
  7. I

    Using Calculations on report from 2 queries

    thanks again for the tip. I am going to give it a try. I've not been one to hang around these forums and such but I can see where it can be of much help. I'll post a response about how it works after trying. again, thanks
  8. I

    Using Calculations on report from 2 queries

    Problem w/[startdate] andd [enddate] I tried this and it seemed to work however the one problem I'm having is the date criteria. The Main query pulls out all of the cost items I want using a [startdate] and [enddate]. This is not however for some reason effecting the subreport to capture the...
  9. I

    Using Calculations on report from 2 queries

    new question about same Thanks for the information.
  10. I

    Using Calculations on report from 2 queries

    thanks for the help, that is going to work for all my reports w/mileage. Much thanks
  11. I

    Using Calculations on report from 2 queries

    I've written a Maintenance database to capture Cost by (1) Repair Location, (2) Parts/Labor/Tires. Each time maintenance is done a specific unit is designated along with it's current mileage. I've written a query to select date period [startdate]&[enddate]. and it captures the Unit's...
  12. I

    Another "Null" Question

    Another "Null" Question The answer to my question seems to me to be quit simple. However I continue to struggle with this Null value issue. I've created a query based upon a Parts table that is divided into "Parts", "Labor", and "Tires". I run a query to determine the costs by P, L, or T. I...
See more
Back
Top Bottom