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

    Excel Help

    definitely gonna do so once i show him how to do what he is asking for:) appreciate your guys help
  2. mitch37

    Excel Help

    thank you..will give it a go later. i know its not set up well, but its the boss's creation and cant change it immensely :)
  3. mitch37

    Excel Help

    :) i cant post now coz i am at work but thanks for the advice :) will log on this evening
  4. mitch37

    Excel Help

    Hey guys Please look at the attached file...this is gonna be difficult to explain...but e.g. look at row 35...each of the codes e.g. BD01, PD02 etc are breakdowns. I f we insert hours available underneath as i have done in row 36, and the look at the table starting in row 92, what formula could...
  5. mitch37

    Equipment Failure Tracking Database

    no rush...i am just playing around with the db...i think i am learnig as i do so...but we have a lot of other things happening on site that i am attending to, and the db gets back seat...it's kinda annoying but i am sure most people know what i mean?!?
  6. mitch37

    Equipment Failure Tracking Database

    Hi Maj I guess the one tink i wont be able to do now is the tree view? is it easy? Here is my current db. http://www.4shared.com/file/97010546/3db62cba/EquipHierarchyV4.html i am actually quite impressed with the way it's turning out and have u to thank for that
  7. mitch37

    Equipment Failure Tracking Database

    The above is my new relationships. Do you think it is sufficient? I am a little worried about 1 to 1 relationships that seem to be present, but i am keen to restart on forms. do not want to jump the gun, because this database must function properly.:)
  8. mitch37

    Equipment Failure Tracking Database

    DocumentRelations Name: tblComponentstblFailures_Components Table: tblComponents Foreign Table: tblFailures_Components PK: ComponentNumber_pk FK:ComponentNumber_fk Name: tblEquipmenttblComponents Table: tblEquipment Foreign Table: tblComponents PK: EquipID_pk FK:EquipID_fk...
  9. mitch37

    Equipment Failure Tracking Database

    DocumentTables tblAction ActionID_pk dbLong PrimaryKey Indexed Action01 dbText Action02 dbText Action03 dbText Action04 dbText Action05 dbText ActionDescription dbMemo FailureID_fk dbLong ForiegnKey Indexed tblComponents ComponentNumber_pk...
  10. mitch37

    Equipment Failure Tracking Database

    '''My assumption is that you have many plants, plants are divided into sections, (maybe domestic production, foreign production) and sections have lines, lines have major pieces of equipment, equipment has componenents.'''' I think it may be best to design for many plants, even if each plant...
  11. mitch37

    Equipment Hierarchies

    '''My assumption is that you have many plants, plants are divided into sections, (maybe domestic production, foreign production) and sections have lines, lines have major pieces of equipment, equipment has componenents.'''' I think it may be best to design for many plants, even if each plant...
  12. mitch37

    Equipment Hierarchies

    Hey Maj..how are you this week. I have tried to clean up my tables. Having a prob wit the relationship between equipment and components - it should be one to many. here is the documentation: DocumentTables tblAction ActionID_pk dbLong PrimaryKey Indexed Action01 dbText Action02...
  13. mitch37

    Equipment Hierarchies

    i understand. i am an excel guru myself (not being proud am i...haha), so access is new territory. i have actually done a basic course which explains basic relationships, but theory and practice is quite different.
  14. mitch37

    Equipment Hierarchies

    wow...i wish i could repay you somehow...it's a bit busy today but guess what i'll be doing this weekend? haha!! thank you!!!!!!!!!!!!
  15. mitch37

    Equipment Hierarchies

    sorry i posted the previous mail before i read your reply. there is a possibility of multiple plants in the future but i have decided for now i am going to set it up for the one plant.The section and assemblies part also seems a little strange to me, because the data i got shows something...
  16. mitch37

    Equipment Hierarchies

    Hi Maj I am battling quite a bit...would it be easier to start from scratch. Do I put a parentID in tblEquipment, tblLine and tblComponent?
  17. mitch37

    Equipment Hierarchies

    i have a couple of hours to spend on this this morning. as i said, i have had no VB training but will give this a go.... u seem like the biggest Access Guru!!!
  18. mitch37

    Equipment Hierarchies

    at the moment that is the exact structure. i guess in future it may go down to a subcomponent. how much more difficult would that be? if it's complex, the specified structure should be ok, seeing that is what i was asked to do? I think i owe you another six pack of Bud and a bag of chips.Ever...
  19. mitch37

    Equipment Hierarchies

    ok, i don't know how 2233 got there but i have fixed that. The relationship you suggested above is correct. Basically, if the user clicks on 'a plus sign' next to 'plant', it expands to show all the lines (that are not all listed in the database yet). if he clicks on the plus next to line1, it...
  20. mitch37

    Equipment Hierarchies

    by the way Maj, have I done okay with the db seeing i started with no experience...OR IS MY EFFORT COMPLETE AND UTTER CRAP? Lol

Part and Inventory Search

Back
Top