Search results

  1. O

    Clear then Delete Code

    I have neither of those set, just enforce referential integrity
  2. O

    Clear then Delete Code

    They are all one to many relationships. The primary keys are in the Buyer/Planner tables and the foreign keys are in the Product table. If you are the buyer for an item number, then you are ALWAYS the buyer for that Item Number (hence the one to many)...
  3. O

    Clear then Delete Code

    I understood everything you was saying and while your take on it from what i've said is understandable to how you've come to that conclusion, i'm afraid it's not what i require (through my fault, not yours). I also agree with the historical records, and that they 'SHOULD' implement this (which...
  4. O

    Clear then Delete Code

    You guys know alot more than me, so maybe what i'm aiming to achieve isn't actually what i believe it should be (in clearing it first). I will try to be even more clear, and for my sake i hope i can be! lol I have a PRODUCTS table. This products table stores EVERY field inside the database...
  5. O

    The easiest problem you'll probably have to deal with!

    I feel kind of stupid asking this, but i just don't know! I have radio buttons on a form with the attributes of Active, Inactive or Proto-type. If you click it on the form then in the table it assigns a numeric value, but on the report i want it to display the text. I have it working for 2, so...
  6. O

    Clear then Delete Code

    Thanks for your replies, it seems to be referential integrity that is the problem yes. Let me try and be more clear about the issue. Right, I have 10 forms, each form has drop down boxes on them. Some forms may have the same drop down box on that form. For example a Buyer Drop Down Box, if i...
  7. O

    Clear then Delete Code

    I want to create a button that deletes a record from a table, but if a record is selected in a drop down within a form, then the error message appears basically that you can't delete the record as it is selected in the form. What i want to be able to do is to clear every field within each form...
  8. O

    Multiple Required Fields Behind Button

    works an absolute treat, thank you :)
  9. O

    Multiple Required Fields Behind Button

    Microsoft have offered support upon giving the VBA code for a required field behind an exit command button for 1 box. I'm very new and would like it to check behind multiple boxes. The code Offered was: Any help on having that for say 4-5 box checks? thank you!
  10. O

    Delete Query

    Could you perhaps talk me through the methods to take to do that please? Thanks
  11. O

    Delete Query

    Hey, i have a problem in as much sense as i'm not sure how to go about it more than anything but it's definatly going to be a query. I have a database with a main table called Products, then related tables coming off it. My forms are set up to read the drop down boxes from their specific...
  12. O

    Value on Report!

    Problem Resolved. Thanks for your help :D
  13. O

    Value on Report!

    Problem Resolved!
  14. O

    Combo or Text Boxes!

    I'm currently on work placement and am building a setting up product database. I have a desire that has been given to me but i'm not sure if it's feasibile but i'm convinced it must be. Basically there are fields such as Planners, Buyers, Class Codes, etc and they are linked to their own...
  15. O

    Setting Forms To Blank (Possible Structure and Relational Issues)

    I'm very new to Access and it's my first attempt of building such a database, so if there any any hints or tips you can suggest on-top of my questions PLEASE! feel free to add your comments. I have no idea how detailed you guys need me to explain it so i shall go quite thorough as i really need...
Back
Top Bottom