Search results for query: *

Thanks that worked for what I needed.

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

Too much information? Not enough information?

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