Recent content by abette

  1. A

    Help with Query that is attached to a form

    Using the sample you provided me I have an Event Procedure attached to the Search Button On Click Property Private Sub Command82_Click() DoCmd.OpenForm "frmAnomalyClaimsReviewQueueSUB", , , "dtDateReceived between #" & Format([ReceivedStartDateRange], "dd-mmm-yyyy") & "# And #" &...
  2. A

    Help with Query that is attached to a form

    Using the sample you provided me I have an Event Procedure attached to the Search Button On Click Property Private Sub Command82_Click() DoCmd.OpenForm "frmAnomalyClaimsReviewQueueSUB", , , "dtDateReceived between #" & Format([ReceivedStartDateRange], "dd-mmm-yyyy") & "# And #" &...
  3. A

    Help with Query that is attached to a form

    I am willing to learn VBA if I have to. How do I code the date range entries?
  4. A

    Help with Query that is attached to a form

    So if I use the DoCmd to open the form based on the values entered in the first form, how does it work for a date range value? What would the code look like?
  5. A

    Help with Query that is attached to a form

    By no means was a implying that you couldn't help me. I am not a VBA programmer and I have average Access skills. I joined this group for support since I do not have anyone I can go to on my job. Please do not insult me by referring to the query as 'that mess'. I am trying the best I can.
  6. A

    Help with Query that is attached to a form

    I am not a VBA programmer so I think that would be difficult. Maybe someone else on here can assist. Thanks again!
  7. A

    Help with Query that is attached to a form

    Hi - I have a query that is attached to a 2nd form that open when the user inputs information in a 1st form and then clicks the Search button. So the Search button opens a 2nd form whose record source is based on a query. The 2nd form displays the correct records when using Fund Year and/or...
  8. A

    Solved VBA Code to run a series of queries and to check the record count and based on record count either continue or display message

    I got it working! Thank you for pointing me in the right direction with this. I learned something new. :)
  9. A

    Solved VBA Code to run a series of queries and to check the record count and based on record count either continue or display message

    I modified my Macro 1. Can Dcount reference a Query? If so then every time I run this it appends the records so Dcount isn't > 0. If I run the query independent of the macro is it picking up records. These records should not be appended to the real table since they already exist there...
  10. A

    Solved VBA Code to run a series of queries and to check the record count and based on record count either continue or display message

    Question - instead of a table can the Dcount reference a Query?
  11. A

    Solved VBA Code to run a series of queries and to check the record count and based on record count either continue or display message

    It's a replica table. The TEMP is basically a copy of tblClaimsWorkingTable. The Temp will receive imported records based on a date range entered by user. The temp is like a working table. Once they review the claims they need to attest them. The attested records get appended to...
  12. A

    Solved VBA Code to run a series of queries and to check the record count and based on record count either continue or display message

    I will try it now. Thank you!
  13. A

    Solved Append (unique) records to table without creating duplicates

    Do you mean VBA vs. Macro? I don't understand? I need assistance with VBA coding of this. Thank you!
  14. A

    Solved VBA Code to run a series of queries and to check the record count and based on record count either continue or display message

    But How? Do I put the DCount() directly in my macro? I am asking for assistance with the syntax. Thank you.
  15. A

    Solved VBA Code to run a series of queries and to check the record count and based on record count either continue or display message

    Hi I have this embedded macro that is attached to a command button on my Form. I need this to be VBA code since I have to add a step to execute a select query that checks records against 2 tables to see if the record on my Temp table already has the same records on the "real" table. I also have...
See more
Top Bottom