Search results

Thank you. How do I use this with my particular combo box?

I am trying to populate the values of a combo box with all PDF files in a particular windows folder. I don't need it to open the file or anything when selected in the combo; just simply populate the the values with the current PDF files in a specific directory. Any suggestions?

I'm getting a 3075 syntax error on this line. I think I'm missing a quotation or apostrophe somewhere but can't figure it out. Here's the specific line of code. I'm trying to get a field to equal the value of a combobox strTemplate = "TemplateName = '" & Me.comboTemplate I'm getting a syntax...

That worked! Thanks so much!

Terrible title, I'm sorry. I have a form that looks at record one at a time. For whatever record I'm on, I want to use VBA via a command to check if that record's ComplaintNumber is listed at all in a completely separate table (tblEmployees). This table also has a ComplaintNumber field. Here's...

Gotcha! Thanks for the help everyone!

I have two update queries that update two fields in the same table to 'N/A' if the respective field is null. Here they are: Query 1: UPDATE tblComplaints SET Location = "N/A" WHERE Location Is Null; Query 2: UPDATE tblComplaints SET Category = "N/A" WHERE Category Is Null; For simplicity...

I use Access as a front end for data which is stored on SQL Server. The DB has hundreds of queries, reports, forms, etc. and so I use a custom grouping for the side Nav Pane, as it's way easier to find things. For some reason on nearly a daily basis, the sorting of the items in the custom...

Can someone who has UtterAccess access post the latest version here of DB found in the above link? I can't register for UtterAccess (confirmation email is never sent). Sorry if I shouldn't be asking this; just not sure what to do

The issue I've always had is there's thousands of complaints going back years. So it'd be quite a process to convert everything over to a separate table.

Gotcha. I was dreading having to do this but you’re certainly right. I appreciate the help!

See the attached DB. I have really specific DCount question. In the complaintfollowup field, users input dated notes and each note is separated by a line break. I'm trying to figure out a way to capture the number of records via DCount where the very last dated note in any given record is older...

That did the trick! Thanks so much!

I have an unbound form to filter a report. One of the unbound fields lets the user enter a customer last name to filter down to records. I want it so the user can enter multiple names, separated by a semi colon, and pull up records with either last name. The below code works fine if the user...

This worked!! Thanks so much

I dropped in this debug line: Debug.Print "strCriteria: """ & strCriteria & """" When I try to use the employee responsible field with 'John', the immediate window is: strCriteria: "7,9"

@Josef P. Could you take a look at the below? I used your code and it worked, but I added in one more element and I'm getting an error. It's the employee responsible section. This code is intended to select records for the report based on the criteria matching another table. I can't get it to...

This worked perfectly!! Thanks so much!!

See the attached example DB. I'm using a unbound form to filter a report. The form has two text fields and a listbox to filter. I got it working perfectly with only the listbox. When I added in the text fields and associated VBA, I'm now getting a data mismatch error on the openreport line. I...

This worked great! Thanks everyone!!