Search results for query: *

definitely gonna do so once i show him how to do what he is asking for:) appreciate your guys 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 :)

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

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

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?!?

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

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

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

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

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

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

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

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.

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

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

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?

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

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

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

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