Search results

Thanks for such a quick response! I put the code in accordingly and it pops up a msgbox asking for a parameter value Autop, if I ignore this it shows a blank report, if I type in the value I want here it then shows the correct report. This unique key is a text field, do I need to use single...

I am trying to pass the filtered results of a Form to a Report. The Form has a Combo Box that obtains it's data from the tDept Table which has two fields. tDeptAbbrv and tDeptNm Sample Values: tDeptAbbrv tDeptNm ANC Ancillary Testing Autop Autopsy...

I am trying to pass the filter from my from that I selected from an unbound Combo Box to a Report. The Unbound Combo Box obtains it's data from the tDept Table which Sample Data: The code to select the Department is below: '------------------------------------------------------------ 'Show...

I can do that in another cell, say, cell H1, so that it now contains the value, but then how do I incorporate that "H1" cell reference into the equation ="MWV has "&COUNTA(A3:A307)&" positive COVID Cases."&" Of those cases "&TEXT((COUNTIF(J3:J281,"*Y*")/COUNTA(A3:A307))*100,"###.#")&"% or...

So... i would assign that row value to a variable... then can that variable be referenced in the equation? Or should I just try to do the whole calculation in vba and then paste the answer into the spreadsheet?

So I have an equation that counts the number of Yes, No in a workbook, but the workbook number of rows changes each day. Here is the equation ="MWV has "&COUNTA(A3:A307)&" positive COVID Cases."&" Of those cases "&TEXT((COUNTIF(J3:J281,"*Y*")/COUNTA(A3:A307))*100,"###.#")&"% or...

So I finally got this to work... but when it creates the spreadsheet it creates unusual formating. The rows become 3 lines tall, the background is white and it brings over the borders. Anythoughts on a command I could add to the line to bring it over unformatted? 'Export Custom Report to...

Thanks so much... I copied this code to my database and got an error message.

I'm guessing that the following line is the key line of code oWS.Range("A1")..CopyFromRecordset rs the two periods generate an error. My Form is named fStafflstMSLB it is based on a query named qStaff and the filter string I build is assigned to vSetFilters How do these 3 elements fit into...

i've tried so many different things... I don't even know where to go... wish that it was as simple as sending it to a report like DoCmd.OpenReport "rStfCmpltChkLstSrtd", acViewReport, , vSetFilters vSetFilters is the filter that I build for the user from 5 Multiselect List Boxes, so...

I tinked with this and found some help the web... but I couldn't make it work either

I don't see a place to put the values like in the update query??

So in the append query i would be sure to put the parent key in at the link field and the Date and Time functions for the time etc. Will the query know to add a unique key?

table tStaff with fields tStfID, tStfFulNm, tStfStrt, tStfZip, tStfPh, tStfSort and table tEvent with fields tEvntID, tEvntDay, tEvntTm, tEvntStfLnk (this field is the link to the tStaff table), tEvntType, tEvntDscrpt tStaff Table Records like: 1, "Bunny, Easter", "123 Egg Lane", 12345...

Is it possible to create a query or a VBA code that can read through a list of Parent records that have a Y in the Sort field and then if that is true, create a child record for that Parent record. I was trying to do it with an update query, but when I join the Parent and child tables in the...

Yes it is actually a lookup field and that is the unique key for that record

So I have a form that allows the user to filter by multiple criteria in Multi-Select List boxes. Once the records are filtered, I need to export them to an excel spreadsheet. I have the following code... Private Sub bToExcel_Click() 'Setup SQL Dim strSQL As String strSQL = Me.RecordSource...

I have a query that looks at a list of tEvents it is a child of tStaff so every staff person might have 3 or 5 or more events associated with their name. So I have two tables and the tStaff table is joined to the tEvents table by a linked field tStfLnk. So... I need to see a list of staff that...

I am not familiar with OpenArgs... can you explain further?

I have a button on a form that allows users to create custom reports through the use of multi-select list boxes. Then there are several reporting option buttons on the form. The following code will open the report with the filtered records. Private Sub Command202_Click() 'This Code Handles the...