Search results

  1. M

    Solved Demonstration database for Garry Robinson

    I understand difference between 2003 and current time ms access versions I mean to read gary's book as a code source for example your StartUpProps function in your demonstration database link, i found it in gary's book as is so that reading this book as a source of codes will be very helpful...
  2. M

    Solved Demonstration database for Garry Robinson

    Thanks alot isladog i read your link its very helpful Regardless user security part i advise you read this book because Garry Robinson techniques is different.
  3. M

    Solved Demonstration database for Garry Robinson

    inside book itself page 12 under title : How to Download the Demonstration Databases
  4. M

    Solved Demonstration database for Garry Robinson

    Dears Have a good day Anyone have download link to demonstration database for Garry Robinson that attached with his book real world Microsoft access database protection and security - 2003 Thanks in advance
  5. M

    combobox search for 2 fields

    Thank you But I don't know vba codes
  6. M

    combobox search for 2 fields

    Hello everyone I need your help in this problem I need to create a combo box as a search box Search about item name and its serial no. I need when I write in combo box The item name or serial number Display item name in a text box All in data sheet view I hope found solution for this in this...
  7. M

    2 foreigns keys referencing to 1 primary key

    thank for explanation but how can i merge recipe and steps tables in one table each table contains completely different data i you have an idea please tell me thanks
  8. M

    2 foreigns keys referencing to 1 primary key

    Dear am trying to make a database handle and management recipes my database has 3 tables one table contain recipes itself ingredients and quantities another table contain steps to prepare each item last table contain historical data about each recipe like creation date, recipe by,.... etc...
  9. M

    2 foreigns keys referencing to 1 primary key

    Hello everybody i have a question what i know the best practices 1 pk link to 1 fk can i link a primary key in a table with 2 foreign keys in two different tables and build queries and forms on that without any bugs in database after that thanks
  10. M

    retrieve and edit record set Form issue

    thanks alot thats what i need one more question please is this can work with tables in one to many relationships thanks
  11. M

    retrieve and edit record set Form issue

    I don't know what i say i am shy from you its not working also no tables or quires or forms ass attached file
  12. M

    retrieve and edit record set Form issue

    Thanks alot for your support but there a problem attached file .mdb i use .accdb so its not working also because unknown publisher Thanks
  13. M

    retrieve and edit record set Form issue

    No i don't duplicate records i enter records as for first time like First name second name address if address has been change i need to retrieve 3 records then change address but with same first and last name and add them to a tableA so in this case no duplicated records as example ID : 1...
  14. M

    retrieve and edit record set Form issue

    how can i do step No.2 after did No.1
  15. M

    retrieve and edit record set Form issue

    Dears I'm trying to upload access file but its invalid !!! Unfortunately id is auto number because its in relationship with another table how i can do it without change autonumber
  16. M

    retrieve and edit record set Form issue

    Dears I am not experts in vba codes like most of you so i need help in below issue i need to create a form to perform the following 1- retrieve record set using ID from table A 2- edit this records 3- save edited record set to Table A with new ID I know its will need queries or vba codes but...
  17. M

    Macro to link combo box with command button

    Hi every body please i need to know how i can use combo box to select a value and when i click command button open form based on combo box value using a macros because I DON'T KNOW VBA CODES THANKS
  18. M

    Planning new database

    Hi everybody I'm trying to planning new database based on food recipes so i need to though with all of u about this database i divide tables to tbl1ItemData: ItemPK, Item Name, Item description, Client tbl2RecipeIngredients: ItemFK, Ingredients, Brand, Unit, Qty tbl3RecipeSteps: ItemFk...
Back
Top Bottom