Search results

So I implemented your code onto this sample database and it worked. If i selected say 2020 and 1212, the report showed up as: Agency One 2020 Agency Two 2020 Agency Three 1212 Agency Four 1212 Agency Five 1212 Now I'm guessing it has to do with the report itself. Since there's over 2000...

Sure thing, i'll upload one shortly

In the Immediate window is this: '0869', '1077' The selections I made

This almost worked. I get a filtered report at least, however if I make more than one selection, I only get one selection and not the others.

Yes, ProgramCode is text field. So just to be sure. Dim strWhere As String Dim ctl As Control Dim varItem As Variant 'make sure a selection has been made If Me.lstProgramCodes.ItemsSelected.Count = 0 Then MsgBox "Must select at least 1 program code" Exit...

Sorry not sure what this means exactly but I removed the second comma after acPreview, and put "ProgramCode IN(" & strWhere & ")" And I'm not sure I can because there are over 2000 records and may be sensitive data.

I tried using ProgramCode but I got an error saying: Data type mismatch in criteria expression

Very much however the last part: DoCmd.OpenReport "rptEmployees", acPreview, , "EmpID IN(" & strWhere & ")" I'm having a bit of trouble with, not sure what I should replace EmpID with. I tried CodeID because that was in the query, but i keep getting this Enter Parameter Value CodeID...

Hi thank you for your code but when I tried using it, the report automatically turn into pdf. Which might be helpful later but for now i just need for report to open with all selected records.

Hi thanks for reply. I like this approach however, with an append query aren't I basically adding the same records to the table? Do I turn the AgencyProgramCodes query into an append query?

Hi all So previously I had a form with a combo box that when the user selected an item, a report would open displaying all the records that carried that field item (in this case, agencies that use a particular program code). It worked nicely, however now I need to allow the user to make...

Thanks for your input Mark. I will rethink this whole approach before I present this project later this month. Thank you.

Thanks guys and Paul you were right. I fixed it now. Thanks!

Hi everyone Just out of curiosity, is it possible to change the text in the prompt message? I have a form where users fill things out and I set this particular field as required. If the user forgets to add a value, they are prompted with the message "You must enter a value in the...

Hey guys, I have this query that nicely associates and displays information between two tables (tblAgencyInformationNew and tblProgramCodes). I turned this into a report and now working on a form where a user can select an item via dropdown. At first the user can click on a button and the...

Thanks guys, my solution was having a default value and setting the onclick property to an event procedure followed exactly what CJ London said and did me.txtControl="". Thanks!

Hi So I went into the field Phone Number's format property and did this: @;[Red]"000-000-0000" I like how it goes away but when I go into the table where I entered the record, the field phone number is blank

Sorry but I can't find it. Can you direct me?

Yes im on a continuuous form. You mean "query banner"?

But its linked to a table. Aren't empty values not ideal for data quality?