Search results

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 #" &...

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 #" &...

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

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?

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.

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

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...

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

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...

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

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...

I will try it now. Thank you!

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

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

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...

Hi Uncle Gizmo - Would you please break down the English into VBA for me? And you mean to set the 'Indexed' property on the receiving table for each field that should be unique?

BTW, I do not take credit for the VBA code. A nice gentleman on this forum helped me this morning with it!

Hi - So you are saying in the Import process when I am bringing the recs in from the SQL table check then? Yes, for sure that would make sense. Here's the SQL version of my query that imports recs from the SQL table: INSERT INTO tblClaimsWorkingTableTEMP ( ClaimNumber, AuthNumber...

Hi - This is the last piece of this project I have been working on. I have a Form that allows user to attest to reviewing records by marking each checkbox control and then clicking an Attest button. This will open an Attestation form which allows the user to "attest" to completing the review...

YES!! It works. THANK YOU SO MUCH!!!!!