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 derfloh 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: *

  • Users: ngoz1
  • Order by date
  1. ngoz1

    Making the titles on my 3 page form fit on the screen

    no that doesent work. my title is already in the footer
  2. ngoz1

    Making the titles on my 3 page form fit on the screen

    Hi I have a 3 paged form. but each time i open it up, i find i have to use the vertical scroll bar to get the page titles to show. its quite annoying. does any one know how i can solve this ?
  3. ngoz1

    synchronizing my form

    Hi Jsteph Thank you so much for your reply.The reason i dont want to make further details a subform to subcase is because there are too many fields in it( further details) and so it becomes cumbersome for the user to have to keep scrolling horizontally to see or enter every thing within a...
  4. ngoz1

    synchronizing my form

    Hi I have a continous form called subcase. The primary key is subcaseID(autonumber) which is a foreign key in a form called 'further details'. i created a command button next to each record in 'subcase' which i hoped that on clicking opens up into a related record in the further details...
  5. ngoz1

    Automatic display of age when a date of birth is inputted

    Hi every one, I have designed a database which my organisation is using to store information on clients with learning difficulties. At the moment i input the date of birth(DOB) and age in the respective fields myself. But i would like the age of the client to be automatically calculated and...
  6. ngoz1

    Report writing

    I often see job descriptions that request for an Access database officer to have report writing skills or experience of writing statistical reports. does any one know what these terms mean. is it anything to do with creating reports in access?
  7. ngoz1

    VBA

    hi every one, i designed a database for a womens organisation which will be used to record both member and non member details, it will also be used to record all information on services that bring in income i.e member ship registration, training registration and payment details of these...
  8. ngoz1

    Securing my database

    Hi, The database i am building is going to be used by 3 to 4 staff and so is only going to be loaded on a single machine. Id like to secure the database so that only i, have access to the design views of the tables, forms etc. i understand that i have to set permissions, but how do i set it so...
  9. ngoz1

    Displaying a calculated control from a subform onto another main form

    Thanks a lot, it worked
  10. ngoz1

    Displaying a calculated control from a subform onto another main form

    Thanks for replying little smudge, I have tried using the full formula the way you explained, but its still not working but can you explain a bit more, what the difference is b/w txtCalculated and ctlsubMain. i seem to be confusing them and i think that might be were i am getting it wrong...
  11. ngoz1

    Displaying a calculated control from a subform onto another main form

    Hi, Could someone please tell me how to display a calculated value in a subform control onto another main form. By 'another main form' i mean, a main form that is NOT the main form of the subform in question. (I already know how to do that). Thank you ngozi
  12. ngoz1

    validating entry into a linked form

    hi, i have two forms linked by a command button. so that the form 1 only displays information relative to the particular client in form 2. therefore the foreign key in form 2 is the primary key in form 1(ie my underlying tables have a one to many relation ship) .i set the foreign key control box...
  13. ngoz1

    junction table confusion - pleeeeease help!!!!!

    Lets say i have three tables - a member table, a non member table( storing all contact details of a member or non member) and a profile table( storing all info about events performed in, by a member or nonmember,and their performance acts at that event etc) The member table has a one to many...
  14. ngoz1

    a problem with one to many relationships

    please dont get too hung up on my example it was just an example i created off the top of my head to expalin my question. all i am really trying to find out is "what is right thing to do in a one to many relationships were the many side is optional." let me give you a real life...
  15. ngoz1

    a problem with the rules of one to many relationships(urgent!!)

    please dont get too hung up on my example it was just an example i created off the top of my head to expalin my question. all i am really trying to find out is "what is right thing to do in a one to many relationships were the many side is optional." let me give you a real life...
  16. ngoz1

    a problem with the rules of one to many relationships(urgent!!)

    If you have a one to many relationship between two entities e.g employee and department. with employee being on the one side and department being on the many side. Lets say the many side is non obligatory(ie optional), will this type of relationship require 3 tables ie one for the employee...
  17. ngoz1

    a relationship that is non obligatory on the 'many 'side

    i think you may have misunderstood my question( though you also cleared some confusions i had about cascade joins) let me rephrase my question: i read some where that : a sperate relationship table is required for any many to many relationship(which i agree with) i also read that for a 1:m...
  18. ngoz1

    a relationship which is obligatory on the 'many' side

    i think you may have misunderstood my question( though you also cleared some confusions i had about cascade joins) let me rephrase my question: i read some where that : a sperate relationship table is required for any many to many relationship(which i agree with) i also read that for a 1:m...
  19. ngoz1

    a relationship which is obligatory on the 'many' side

    hi everyone, im new to this group :-) My question is -"If i want to create a one to many relationship between two tables. and i find that the many side is non obligatory ( i.e optional), do i need to create a join table between them? or is that just for many to many relationships"

Part and Inventory Search

Back
Top