Search results

  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

    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...
  3. 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...
  4. 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...
  5. 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...
  6. A

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

    Hello Everyone! Thx in advance to read and reply my question and thanks to this site for providing opportunity for getting help. I have main form (FrmFabricReceive) and subform (SFrmTblFabricPieceEntry), I have set code in Subform so that if condition not met it will not run update code, But I...
  7. A

    Solved runtime error 3021 no current records

    I am getting said error in case when my loop is hitting situation having no data in table feild, i have searched on net and found that i need to insert if statement to check the set value is null. I tried but I am unable to find solution, see if anyone can help .. Thx in advance Private Sub...
  8. A

    Solved Subform goes blank when add new record is pressed.

    1) I have a form and it has subform in it, 2) When old records are viewed it works fine. 3) The moment add new records is pressed the subform goes non-responsive (shows nothing in it). 4) Tried everything, A) Removed all my codes from both main form and subform, B) Checked...
  9. A

    Solved using dsum in update statement.

    1) Table 1 : TblOrder, 2) Table 2 : SubTblGreyFabricOrder, 3) Common field : "OrderID" in TblOrder and "OrderNumber" in SubTblGreyFabricOrder. 4) TblOrder has field : GreyPOQuantity which is in one to many relation with GreyPurchaseQualtity of Table SubTblGreyFabricOrder. 5) I want sum of...
  10. A

    Hi, I am new here.

    I am self learner and I am using my access database at my work place. I hope I will get my answers here that can boost my knowledge and solve my issues. Thanks, Ashish
Top Bottom