Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mdmarney

    Type Mismatch Error

    Mucho gracias amgigo. Trabaja muy bien! (thanks, it works) ************* M. MARNEY www.tgw.com
  2. mdmarney

    If statement not working

    ...debug to check the numbers and conditions are being met, but the update is not happening under the right conditions. Also, there is a difference in the update strings. Notice: Arrival_Verification = FALSE and Arrival_Verification = TRUE are the differences. ************* M. MARNEY www.tgw.com
  3. mdmarney

    Urgent! Object reference problem?

    ...reads: =DCount("[Tee_Shirt_Size]", "tbl_Attendants", "[Tee_Shirt_Size] = 'L'" AND [Parish_Group_ID] = " & [Parish_Group_ID]) How does it know that I want the Parish_Group_ID that corresponds to the current page of the report? ************* M. MARNEY...
  4. mdmarney

    Type Mismatch Error

    ...rs.FindFirst "[Last_Name] = " & Str(Nz(Me!Text62, 0)) If Not rs.EOF Then Me.Bookmark = rs.Bookmark End Sub The following statement gives a type mismatch error... rs.FindFirst "[Last_Name] = " & Str(Nz(Me!Text62, 0)) Help? Thanks! ************* M. MARNEY www.tgw.com
  5. mdmarney

    If statement not working

    See, that's the problem. It never evaluates to false! Is it the After_Update event that is the problem? I tried the on_click, but that did not work either. (The triple property is false.) ************* M. MARNEY www.tgw.com
  6. mdmarney

    If statement not working

    I am running this code on the after_update event of the check box which is named Parish_Group_Arrival and is bound to the same name. ************* M. MARNEY www.tgw.com
  7. mdmarney

    If statement not working

    Paul, That did not work. I have tried TRUE as well here is the code... If Me!Parish_Group_Arrival = -1 Then DoCmd.RunSQL "String Here (Works)" Else DoCmd.RunSQL "String Here (Works)" End If Ideas? ************* M. MARNEY www.tgw.com
  8. mdmarney

    Urgent! Object reference problem?

    ...L' was misplaced. Still having trouble though... =DCount("[Tee_Shirt_Size]","tbl_Attendants","[Tee_Shirt_Size] = 'L' AND [Parish_Group_ID] = [Parish_Group_ID]") This code returns the value as if Parish_Group_ID was disregarded. ??? ************* M. MARNEY...
  9. mdmarney

    If statement not working

    ...Else DoCmd.RunSQL "UPDATE tbl_attendants SET Arrival_Verification = FALSE WHERE Parish_Group_Arrival = TRUE AND Parish_Group_ID = Forms!frm_Check_In_Attendants_by_Group!frm_Check_In_Attendants_by_Group_Subform.Form!Parish_Group_ID" End If Any thoughts? ************* M. MARNEY...
  10. mdmarney

    Urgent! Object reference problem?

    Randy, It is of LONG type. How should it be different? Thanks! ************* M. MARNEY www.tgw.com
  11. mdmarney

    Urgent! Object reference problem?

    Tried what i had above, but got error. I think I am probably referencing the Current_Group_ID wrong. Any thoughts? ************* M. MARNEY www.tgw.com
  12. mdmarney

    Urgent! Object reference problem?

    Randy, Thank you for the code. I need to add another field to the where clause though. Basically... "[Tee_Shirt_Size] = 'L' AND [Group_ID] = '&[Current_Group_ID]'" Will this work? ************* M. MARNEY www.tgw.com
  13. mdmarney

    Urgent! Object reference problem?

    ...answer. Here is the current code: It works great in a form, but not in a report. Dim rs As Object Set rs = CurrentDb.OpenRecordset("Select * from tbl_Attendants Where Tee_Shirt_Size = 'L'") rs.MoveLast Me.tx_L_Count = rs.RecordCount **The error is on the assignment to...
  14. mdmarney

    Object reference in a Report

    ...answer. Here is the current code: It works great in a form, but not in a report. Dim rs As Object Set rs = CurrentDb.OpenRecordset("Select * from tbl_Attendants Where Tee_Shirt_Size = 'L'") rs.MoveLast Me.tx_L_Count = rs.RecordCount **The error is on the assignment to...
  15. mdmarney

    How do I reference an object in a form?

    Nothing, just display it! ************* M. MARNEY www.tgw.com
  16. mdmarney

    How do I reference an object in a form?

    ...what is being acted upon (as the code indicates) and is Unbound. That's about all I know to say. The Recordset for the actual report is different than the one being defined in this code, but I thought since it worked in a form it should work in a report... Help? ************* M. MARNEY...
  17. mdmarney

    Combo box with report below?

    nevermind... Figured out the syntax... :-) ************* M. MARNEY www.tgw.com
  18. mdmarney

    Combo box with report below?

    ...= Me.cbx_Group_ID_Selector Debug.Print Group_Select DoCmd.OpenReport "rpt_Shirt_Distribution_by_Group", acViewPreview, , "Parish_Group_ID = '" & Group_Select & "'" BUT, I think the syntax around Group_Select is wrong. Help??? ************* M. MARNEY www.tgw.com
  19. mdmarney

    Report help - Cannot ref. Object

    No, same error... ************* M. MARNEY www.tgw.com
  20. mdmarney

    Report help - Cannot ref. Object

    Here is the current code: It works great in a form, but not in a report. Dim rs As Object Set rs = CurrentDb.OpenRecordset("Select * from tbl_Attendants Where Tee_Shirt_Size = 'L'") rs.MoveLast Me.tx_L_Count = rs.RecordCount **The error is on the assignment to the text box...

Part and Inventory Search

Back
Top