Search results

I know what you're saying and I'm working on it. This is a temporary fix. The core issue is that I don't have a full listing of all employees in a table. Powers that be have not allowed that yet. So I can't make a junction table between complaints and employees because the employees table...

That worked! Thanks so much!

@arnelgp if complaintnumber was a number field, how would you could the me.filter line? Can't seem to figure that out

Okay, so that kind of worked but the same employee could be attributed to multiple complaints. So 'John Smith' shows up multiple times in the combo box. I'm looking for a way to select john smith and then all the complaints attributed to him are shown.

Thank you. For the 'probably wrong' one, is there a way to code the search form so that there's a command to search on click? Rather than it updating from the textbox. I tried to add something in but it's erroring on the 'Dim theSearch As String: theSearch = Me.txtSearch.Text' line

The employees table is not an exhaustive employee list; that is a separate table. It is a storage of when a complaint is attributed to an employee. So an employee could be listed there several times depending on how many complaints are about them.

Thank you. I've attached a revised example off your original, as my situation is a little more complex. I'm hoping to filter the frm_complaints based on a separate table. Both tables have a matching complaint number. So based off what the user inputs for a name, it then filters the...

Would you mind providing a quick example? I'm struggling to think of how to code that

I gave that shot. Still nothing. I input the employee name and it doesn't do anything. No errors either.

I've got a Complaints table and an Employees table. Both tables share a 'ComplaintNumber' field. In the Complaints form, I was hoping to use a input box to allow the user to search an employees name (from the Employees table) and it filters down to matching ComplaintNumber(s) based on that...

@Minty strike that...so I added in your revision (see below) and now I'm getting an 2498 error on DoCmd.OutputTo line. Any suggestions? Private Sub btnExportReport_Click() On Error GoTo btnExportReport_Click_Err Dim fd As Object Dim FileName As String Dim rptCurrentReport As...

Thank you! That worked. I inherited this code so I'm still getting used to it. I appreciate it!

Probably a very stupid question, but I have an export command on a report and I changed it to Option Explicit. When doing so it's saying the bolded 'currentreport' below is not defined. I'm not sure what to define it as. That line identifies the open report's name. Any suggestions? Private...

That worked! Thanks a bunch!

@theDBguy sorry one last question. I was curious if you've seen this issue before. The module and field work perfectly in the form except whenever the form is filtered. If the user filters the form and there's no matching records, a 3075 run time error is shown stating syntax error in the where...

That worked! Thank you!

Actually one issue is I'm having is if it's null, I want the field to display 'N/A'. I tried the below but it still is still blank if null. Any suggestions? =Nz(SimpleCSV("SELECT EmployeeName FROM tblEmployees WHERE [ComplaintNumber] =" & [Forms]![frmComplaintDetails]![ComplaintNumber] & "")...

Thank you! Getting rid of 'me' worked. And I switched to that code instead and it worked flawlessly. The delimiter on the other was given me issues. Thanks so much

I've been using this guide to output a column of data in a table to a single comma separated string in a form's field. It works in general but I can't get the where condition to work. Here's what I put in the control source of the field in the form...

Awesome, thanks so much. I was struggling to find a guide. I was probably searching the wrong way. Thanks again!