Recent content by Ashisht76

  1. A

    Solved checkbox placed in frame by a query, not responding

    Hi Everyone, First of all Im highly obliged to read my problem and thankful to try to help me to solve. In access I have table "TblOrder","TblGreyFabricOrder" and "SubTblGreyGabricOrder", "TblGreyFabricOrder" has form "FrmGreyFabricOrder" which also has frame ( SubForm /SubReport)...
  2. A

    "The section is greater than page width..."

    Point No. 6 Totally worked for me. Thx a ton for solving my issue.
  3. A

    Solved Retrieve value and not primary key from Data Access Objects (DAO)

    Thanks a lot. That was great help and educational one. I learnt is table level look up is NO NONO...
  4. A

    Solved Retrieve value and not primary key from Data Access Objects (DAO)

    To begin with I am tankful for your precious time to watch this and thankful for help in advance. Content1 is lookup field. This value coming from another table. In current table (i.e. TblQuality ) its showing value but in Debug.Print Stg its giving primary key. How can i retrieve value and...
  5. A

    Displaying records of continuous sub form in new column after every 12 records.

    Hi! majP. I am highly obliged that you have helped me so much. I have no way to thank you enough. I figured out your initial code because i just don't want to copy paste, and i will go thru all that codes that you have given above. If i have any issues i will definitely write here.
  6. A

    Displaying records of continuous sub form in new column after every 12 records.

    Hi Sorry for replying you late, I was busy on other projects. 1. I would prefer for Entry, Edit and delete purpose. but I am willing to show it only for display if I cannot achieve that. 2.Its going to be 60 records and 60 records only, not a single more..ever. 3. I believe its irrelevant 4. If...
  7. A

    Displaying records of continuous sub form in new column after every 12 records.

    Wow! I am amazed by getting so many replies and so many options. Thanks a ton everyone for responding. I am checking each and every reply in my database and will come up with result soon.
  8. A

    Displaying records of continuous sub form in new column after every 12 records.

    Hello Everyone and thanks in advance to everyone who will try to solve my issue. I have form and continuous subform that will show serial number and for each serial number I have some numbers (Picture attached). #1 ) Now I want to see this subform having 12 records in each column and next 12...
  9. A

    Add or Remove column from same report by selecting checkbox

    Hi Everyone, I have been searching for code that can add or remove column from same report based on check box is selected or not. Is it really possible or its not practical. Does .visible property works here and if so how, I will he very thankful if i get some hint or code example of the same...
  10. A

    Solved Navigation form requery subform

    hi. i will be highly obliged if you could give code for requery a combobox on a form that is in navigation form.
  11. A

    Solved Not allowing user to delete record in subform (datasheet view)

    You nailed it again, Thanks a ton for the help.
  12. A

    Solved Not allowing user to delete record in subform (datasheet view)

    I have been searching for solution on net and found similar issue in below site, Please also have a look at it that might make some sense. If i try to apply it here then according to it I will have to show my query in layout view but I dont know how can i do it with query in Subform/ Subreport...
  13. A

    Solved Not allowing user to delete record in subform (datasheet view)

    HI, Sorry i have to edit my previous comments as i tired it on wrong Form, so the thing is that as i have mentioned that this is query that sits in Form /Subform frame, hence there is no such options available in first place. Please find screen shot of the same. Thanks.
  14. A

    Solved Not allowing user to delete record in subform (datasheet view)

    Hello everyone! Thanks in advance for giving your precious time to read my post. My Form has subform that has its source Record a Query for showing conditional data, the problem is that user can select record and press delete button from keyboard to delete record from that which i don't want...
  15. A

    Solved Now allowing Sub-form to update table based on condition in subfrom

    I am closing this one as i have found solution, I have split code in two and one is for before update and rest in after update, that works. If any one is interested in codes kindly let me know, I will be glad to share. Thanks everyone to take your time and put efforts.
Top Bottom