Search results

  1. S

    Question Asked for a parameter on form open...why?

    I discovered that as well. So I think I'm pretty much at the point I was hoping to get to. We ended up tackling a couple new items along the way, but that is how we learn huh. Thanks again for your help.
  2. S

    Question Asked for a parameter on form open...why?

    VbaInet, We are getting closer, but still double the amount that we should have. Let's look at the last project, (Project ID = 9) On the T - Project sheet which is where all of the information is entered we see the following: Unit Hours...
  3. S

    Question Asked for a parameter on form open...why?

    vbaInet, Thanks for taking a look. When I open my T - Project form I'm not getting asked for the parameter now, but did you notice that the Sum of Equipment price is WAY off now? The math should take the number of each unit and the amount of time we have shown for each unit and multiply it...
  4. S

    Question Asked for a parameter on form open...why?

    Thanks for taking a look at it for me vbaInet. I've attached the zipped db. I'm sure you will see the structure isn't the greatest, I'm a novice to say the least. I was actually pretty happy with what I was able to figure out.
  5. S

    Question Asked for a parameter on form open...why?

    Ok, that sounds like it has potential. I have a couple subforms on this form and reference the Project ID field to know what to include in their related fields. So this might be a silly question, but how to I control the opening sequence of the form. Right now I am just double clicking the...
  6. S

    Question Asked for a parameter on form open...why?

    I have designed a database for use in tracking our projects. I've made use of queries to perform calculations that I need and sub-forms and sub-reports to display these calculations. All of my routines and operations work perfectly except for this one strange detail. When I first open my...
  7. S

    Placing a Pie Chart in a Report

    I am building a database that will tie together the labor and material that are used on projects. I would like to have a report that displays among other things the following: Estimated Hours Hours Used So as the project goes along the "Hours Used" would steadily increase, while the...
Back
Top Bottom