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 Chriss 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. Borian

    Printing a Report within a Date Range

    Thanks that worked for what I needed.
  2. Borian

    Printing a Report within a Date Range

    I'm hoping that someone can point me to a good walk through for printing reports with a user defined date range. I've seen this on several of the example databases with Access, but I can't seem to figure out how the go about setting it up. Thanks for any help, Paul
  3. Borian

    Simple Question.. I hope :)

    LOL Duane, The difference between the Northwind database and what I am looking to accomplish is this. In the orders database, there is really no reason to go back and look at the order detail records independent of the Order record. Without the Order Record the details have little to no...
  4. Borian

    Simple Question.. I hope :)

    Thank you Duane, I agree with your analysis on the situation, however the situation is different. There is a real need to view the parts associated with the unit irrespective of the service order which generated the replacement of the part. But having said that I have fixed the problem. If...
  5. Borian

    Simple Question.. I hope :)

    Looking at things through the service records will work for a while, however long term I'm not sure it will work. One of the units has already had 4 service orders on it, and they have only been using the database for 2 weeks. Longterm, A year down the road the service tech might have to look...
  6. Borian

    Simple Question.. I hope :)

    Well there is a method to my madness, not just madness. :) The thing I am looking to provide is the ability to quickly look at a parent record and see all associated grandchild records. Example why: Parent record = Unit 45 (a Tractor). Unit 45 needs a new clutch put in, but the mechanics...
  7. Borian

    Simple Question.. I hope :)

    I just wanted to thank Duane again for his help in this. I figured it out. My biggest problem was that the RepairID in Service Order Table was AutoNumber; RepairID in Parts Table was Text. They didn't behave the same. Any idea how to default the Unit Number to the parts table? Paul
  8. Borian

    Default values in fields

    Here's my scenario, I hope someone has figured out how to do this. Have a form with 2 subforms These forms built off a querry pulling in three tables Tables: Parent Table - Unit Information - Primary Key is UnitNumber (Text Field) Child Table - Service Orders - Primary...
  9. Borian

    Simple Question.. I hope :)

    Ok.. Fixed the duplication of repair ID's. Now I'm getting all parts replaced on all service orders for the particular unit. I'll check back tomorrow and see if anyone has any ideas about this one. Thanks for all your help Duane. This project is comming to an end finally *<|:-) Paul
  10. Borian

    Simple Question.. I hope :)

    Hmm seem to be getting 4 pages of same information. printed same repair id 17 times. Any ideas? Paul
  11. Borian

    Simple Question.. I hope :)

    OOops misunderstood what you were saying. Changed to this and think it's working, my report might not be working but I think the statement is. Here's how it looks ... Private Sub Command15_Click() On Error GoTo Err_Command15_Click Dim strWhere As String Dim stDocName As String strWhere...
  12. Borian

    Simple Question.. I hope :)

    I take the quotes out and it gives me a syntax error. I looked through some of the other parts of the program and saw that some of the fields were listed in quotes so gave it a shot. Not quiet sure what I'm doing wrong or right at this point. That and I'm a novice in Access. Anyway...
  13. Borian

    Simple Question.. I hope :)

    Thank you everyone and here's where I am at with it, though it is still not working. Perhaps someone can give me advice on what I am doing wrong. Using Access 2000 in case it matters. Private Sub Command15_Click() On Error GoTo Err_Command15_Click Dim strWhere As String Dim stDocName As...
  14. Borian

    Simple Question.. I hope :)

    Yes report is created Yes report is based upon single querry with all three tables Yes I am having a terrible time limiting the report to just record being diplayed. Yes there is a unique key for service order. Repair ID - Auto number - Long Integer - Indexed no Duplicates.
  15. Borian

    Simple Question.. I hope :)

    The information I am looking to print is as follows: Tractor or Unit information (Including year, make, model, vin#, ect.) This should be only for unit associated with service order. Service Order Information - This is the critical piece. I just finished entering in a service order and the...
  16. Borian

    Simple Question.. I hope :)

    Too much information? Not enough information?
  17. Borian

    Simple Question.. I hope :)

    Currently I have built a Service Management Database for the trucking company I work for. I figured out how to muddle through creating the forms and querries to make it work the way I wanted it. Now for my current problem. How do I make a report that will do the following...

Part and Inventory Search

Back
Top