Recent content by directorz

MichaelRed, You should give it a shot. Dhookom has it nailed and until now I was at a loss. Perhaps enlarging the diagram as I did will give you more room to organize Directorz

Dhookom, That's the ticket! I used Snagit, capturing the full layout (set to scroll both vertically and horizontally). Saved it to a .tif format and plotted it on a xerox plotter 24" x 30". Great tip...thank you! Directorz

Dhookom, I've tried this without much success. If the printing appears on multiple pages, that's fine. I just physically cut and paste onto a board that hangs on my wall. Everything does not need to fit onto one page. I was thinking more along the lines of converting it then saving it to a PDF...

Has anyone ever printed a large relationships diagram that's too large to print from the relationships window? Did you use a third party software? Any suggestions? Thank you Directorz

Hello experts, I'm incorporating inventory into a db using the NorthWind inventory as a model and my db tracks equipment maintenance. When any maintenance is performed, a work order is always completed, thus I have a work orders table which needs to be tied to the inventory model. The work...

THWatson, Yes, that's it! I modified the existing with yours and everything work great. Many thanks. Directorz

password is ticket

Please note So I will need a maximm value in Tbl2 first. Then subtract Tbl1 to arrive at a total

THWatson, Thanx for the response. This returns a join error. For a better visual, I uploaded a sample at geocities.com. Login name is directorz2002. Password is ticket.Via file manager, you can download the sample and better see where I'm at...

Could someone assist with SQL in creating a calculated field. I need to show a meter total and I have 2 tables as follows: Tbl1 MeterID – pk InitialMeterRead Tbl2 MeterReadID – pk Ref_MeterID – fk to Tbl1.MeterID MeterRead Tbl1.InitialMeterRead is the start reading of a meter. Subsequent...

Willir, The more I see, the more I get confused. I’ve uploaded a sample at geocities.com. Username is directorz2002. Password is ticket. Access the file from file manager, look for metersample. The arrangement shows the following. 1. A vehicle can have many meters and a specific meter can...

One other thought. Check out MSWorks database. It's a cheapo but it does exactly what you want.

How about 4 tables tblStaff StaffID - pk Name tblCourse CourseID - pk StaffID - fk to tblStaff CourseName - fk to tblCourses / CourseName tblCourses Courses - pk tblDates ID - pk refCourseID - fk to tblCourse DateAttended

Willir This gets quite complex.. I do want the meter reading on work orders. When it comes to replacement meters, how is this handled. For example. if car 1 has 5000 hours and the hourmeter fails, it gets replaced. Now, I can't include a calculated value in the table. So, after a period of time...

Willir, I've been out most of the weekend and could not followup. The way you enclose "quotes" in boxes is very clear...how is that done? Let me address this bits at a time. <<<Does this mean you can bring in a vehicle, and it will have several meters, or have one meter one day and another...