Search results

Yes I have 6 rtables with similar structure, each have 4 of the same fields, but the rest differ. I need the 4 fields to join depending on user defined listbox search criteria. I've tried subreports, but the issue is they error out when one of the listboxes is empty or do not update every...

Thanks but the table names aren't an issue, the search criteria for each table is completely different. and if I choose a value the Union All works just fine, it's when there isn't a value that I want it to skip over and move onto the next. To be honest If then, and or elseif whatever...

What I am trying to do is merge data from several tables into one query, based on user defined options through multiple listboxes. I've figured out the VBA for the union all for the different selections, my problem is I can't determine how to make it dynamic and skip over a select statement if...

Thanks for the help, you put me on the right path.

That didn't quite work, but I found that if I use Forms![Packets]![List10].RowSource = "" on exit it resets the rowsource to empty.

So not saving isn't an option there is no prompt when the query gets closed. I tried setting the listbox default value as null, but that just gave me an error. I have 11 listboxes with different variables depending on calendar criteria, Day of Month Quarter Yearly Seasonal Last Week of the...

It is 1 database, with a limited amount of users. the Form is used to add the parameter filters to fly queries. If that makes sense. I just need the query to revert to blank so that if a user doesn't need that particular report next time it will make that particular sub-report hidden. (which...

I'm in the process of making a database that uses multiple user defined criteries to create reports. I have pulled those reports into one using subreports. I have several issues: 1. How do I clear the contents so they don't save when the user exits, and the next user gets ready to choose...

Hello, I'm from Kansas, and I'm relatively new to Access, as well as most of the programming languages, but as they say you'll never learn unless you try. So here I am, often confused and schleping my way through it with a specific goal in mind. Anyways I'm building a really basic database...