Search results

Hello, I have a user form with a date range and combo box filter. The user selected filtered results are displayed in a subform. I placed a print report button on the user form, but I'm getting the following error when the button is pressed: Run-time error '3075': Syntax error (missing...

I have a user form with a date range and combo box filter. The user selected filtered results are displayed in a subform. I placed a print report button on the user form, but I'm getting the following error when the button is pressed: Run-time error '3075': Syntax error (missing operator) in...

Hey everyone, I'm trying to implement an example of a date range filter that I found (it uses a start date text box and end date text box), but I'm having a lot of trouble getting the code right. I'm trying to combine the date filter criteria with another combo box filter criteria. Here's...

Hi ya'll, I'm having difficulty getting my combo box filtering working the way I'd like it to. The problem that I'm having is the fact that I'm performing "OR" cases across three columns of data looking for values that match what's selected in those two combo boxes. So then when I go to...

Hello Forum, I have a problem with duplicate records in my query. I know why the duplicate records are occuring and I have spent a ridiculous amount of time trying to fix the problem, but I'm really at a lost and am quite desperate for some help. Here's some background info that shows the...

I’ll just state my question/problem right off the bat: Is there a way (hopefully using query criteria, but VBA code would be fine also) to compare the values of one table with another table by looking for similar/partial text? This problem is kind of complicated to explain, so please bear with...

I’ll just state my question/problem right off the bat: Is there a way (hopefully using query criteria, but VBA code would be fine also) to compare the values of one table with another table by looking for similar/partial text? This problem is kind of complicated to explain, so please bear with...

Hi all, I originally posted the following in the Forms section, but I think it belongs here. My main goal in the project that I'm working on is to have multiple cascading combo boxes to filter the records. Through searching this forum, I was able to put together some cascading combos, but I...

Hi all, I have a combo box with an "All" option, but I'm having trouble figuring out why it fails to return any records. I'm using a search command button to filter the records. I've attached my database and the specific code I'm using is below. I really, really appreciate any help that can be...

I'm getting a Compile Error: "Method or Data Member Not Found", and I'm having trouble figuring how what I'm doing wrong in my code. Below in red is where the error is occuring... Private Sub cmdSearch_Click() Me.subfrmFilter.Form.RecordSource = "SELECT * FROM qryFilterGroup " & FilterIt...

Hi, I've been searching through the forum and I've found a few helpful posts, but I'm still having trouble pulling everything together. Here's the situation: In a user form, a value is selected from a combo box. I then want a search to be done on a query to look for that value and filter down...

I must have read about 30 different threads on cascading combo boxes along with a days worth of google searching and I'm still having trouble setting one up...don't judge me!!! I found one example that I thought would be simple to implement, but I need some outside help in finding my error(s)...

I'm just starting out with Access, and I've been doing a lot of reading in this forum. I haven't found any solutions to this problem, so plz help if you know the answer!! Application info: I'm doing a test project for now to get familiar with Access, and I'm trying to open up Excel by using a...