Search results

  1. A

    Problem in Query

    When I try update the table and call "open form" again the last record is getting duplicated. Form_Open is working fine. I am not knowing the error in first part(Marked in itallics) Code is: If Forms!frmPipeline("chkResourceOptimizer" & intRow) = False And _ Not...
  2. A

    Duplicate records in Form

    When I try update the table and call "open form" again the last record is getting duplicated. Code is: If Forms!frmPipeline("chkResourceOptimizer" & intRow) = False And _ Not IsNull(Forms!frmPipeline("txtProjectID" & intRow)) Then DoCmd.RunSQL "UPDATE tblProjects SET...
  3. A

    In Query "match projectID in table to project ID in form'

    How to match projectID in table to project ID in form When I run this command I get syntax error DoCmd.RunSQL "UPDATE tblProjects SET ResourceOptimizer=False where ProjectID = forms!frmPipeline("txtProjectID" &intRow)"
  4. A

    record should be deleted from the recordset but not from the main table

    I was trying to run this command. I was trying to uncheck the field in the table but my problem is how to match tables projectID to the forms project ID I having syntax error when I run this command. DoCmd.RunSQL "UPDATE tblProjects SET ResourceOptimizer=False where ProjectID =...
  5. A

    record should be deleted from the recordset but not from the main table

    How to uncheck the field in the table matching with the same ID in the form. strSQL = "SELECT chkresourceOpt from tblProjects WHERE chkresourceOpt=true" Set rstProjects = CurrentDb.OpenRecordset(strSQL) If Forms!frmPipeline("chkResourceOptimizer" & intRow) = False And _ Not...
  6. A

    record should be deleted from the recordset but not from the main table

    I have a form with with ID,title, owner and checkboxe next to it. When I uncheck the checkbox the row with ID,title, owner should be deleted from record set but not from the main table. The problem is the record is getting deleted in the form and in the main table. (The fact should be the...
  7. A

    Problem with the query

    From the previous code example, if I uncheck the checkbox the row should be deleted. Any help of how to code it or any hint.
  8. A

    Problem with the query

    Got it. Thank you for the help
  9. A

    Problem with the query

    I have to populate txtfields on the form from the table. I have table and want to select rows for which the check box (i.e. optimizer) is checked Here is the code: 'Populating the fields strSQL = "SELECT ProjectID, Title, Owner, Optimizer From tblProjects where [Optimizer]=True" Set...
  10. A

    Problem with DateAdd function

    I have this code in the form "frmBars" I am trying to assign dates to the txtfields. txtMonth1 = CDate("1/1/" & Year(Date)) For intMonth = 1 To 11 "txtMonth" & (intMonth + 1) = DateAdd("m", 1, "txtMonth" &intMonth) Next The problem is at this statement "txtMonth" & (intMonth + 1) =...
  11. A

    information from table to the form.

    I am new in using MS Access and VBA. I think i may be asking simple but I would appreciate if any one would help me. I have a table with fields such as id, name, owner, start date, end date..etc. I have get the all the information from the table fields id, name, owner, in to the MS Access...
View older results
Back
Top Bottom