Search results

  1. Y

    Listbox to assign transactions to billing statement

    Yes, as you can see in the debug mode it's pulling the value 18 which is correct.
  2. Y

    Listbox to assign transactions to billing statement

    Iv attach some photos for review.
  3. Y

    Listbox to assign transactions to billing statement

    Now im getting runtime error '2448' You cant assign a value to this object
  4. Y

    Listbox to assign transactions to billing statement

    That's good to know, thanks!
  5. Y

    Listbox to assign transactions to billing statement

    I get a compile error "next without for"
  6. Y

    Listbox to assign transactions to billing statement

    I would like to ultimately hide the statment_id column. Heres a vba code I found, it looks like it adds new rows which is not what I need. can this be modified to work? Dim n As Integer Dim strCriteria As String Dim strSQL As String With Me.lstCourses For n =...
  7. Y

    Listbox to assign transactions to billing statement

    Forgot to mention the subform on the billing statement form only displays transactions with a related statment_id.
  8. Y

    Listbox to assign transactions to billing statement

    Thank you for the response. I'm not understanding the logic here, I don't think this will give me the desired result. What I was expecting was an update record function where the specific record is highlighted as shown in the photo. The statement_id would be passed from the main form behind the...
  9. Y

    Listbox to assign transactions to billing statement

    Yes. If there is no statment_id it will continuously show in the add transaction popup form until it is assigned to a statement.
  10. Y

    Listbox to assign transactions to billing statement

    Those are edited by another form. Only the statement_id on the transaction side.
  11. Y

    Listbox to assign transactions to billing statement

    Currently, I'm setting the statement Id in the table for illustration purposes.
  12. Y

    Listbox to assign transactions to billing statement

    Sorry just noticed the additional options below, was using the insert image above. Those transactions perform other functions such as calculating the daily over/short, if there are excluded then it will throw those numbers off so all transactions need to be inputted, however, if there's a...
  13. Y

    Listbox to assign transactions to billing statement

    I Have a table that stores transactions details that occur during a normal business period. *The Columns on that table are as followed* ID (PK) Date Client_ID (CK) Volume Amount Statement_ID (default is blank) at the end of the cycle, I would like to select which transactions get assigned to...
  14. Y

    Display "Multiple" if parent contains more then 1 subrecords

    This is what ended up working for me, I put this in the field area of the query. Hopefully, this thread can help someone else. Thanks for steering me in the right direction guys! WARNING: Nz(IIf(DCount("*","ISD_LIST_SUB_QRY","[ISD_LIST_SUB_QRY].[ID]=" & [ISD_DETAILS_TBL].[ID])>1,"Multiple...
  15. Y

    Display "Multiple" if parent contains more then 1 subrecords

    If a label is the only way to make this happen how would I set that up?
  16. Y

    Display "Multiple" if parent contains more then 1 subrecords

    I'm sorry, really at a loss, I don't know how to explain it any other way:banghead:. I linked an image attachment from Gdrive because this site doesn't connect or display the image. Anyways please see the additional image. The main form represents my end goal. When the magnifying glass is...
  17. Y

    Display "Multiple" if parent contains more then 1 subrecords

    https://drive.google.com/file/d/1Z0_DIQk9FWBIxQ7_4khg29_mHq9zwrWz/view?usp=sharing What I need is 1 warning to be displayed from the ISD_WARNING Table if the ISD_SUBFORM_DETAILS contain one record. If it contains more than one record I would like to display "Multiple Records". Hope that clears...
  18. Y

    Display "Multiple" if parent contains more then 1 subrecords

    Please see below
  19. Y

    Display "Multiple" if parent contains more then 1 subrecords

    I don't have any normalization errors, once I have 10 Post I can post a pic of table structure.
  20. Y

    Display "Multiple" if parent contains more then 1 subrecords

    I tried playing around with the codes & couldn't get them to work.
Back
Top Bottom