Search results

Woah - okay - thank you very much JNB!! My first adventure into VBA!! I need to take some time to work through this so I understand the code you put in there. This may take me a few days (sorta bogged down at work this week). I am relatively certain I will have more questions. Thank you...

Thank you both for your help. What do you mean "on the fly" ? I looked at the Database you attached, but I can't get it to work either. Am I missing something? (I did use the "Copy of LenderSearchQuery" instead of my original "LenderSearchQuery".) It does look simpler in the Design View, but I...

No - I answered your questions above that you asked for clarification on... but I was unable to figure it out on my own. (Was in meetings last week and replied a bit late - sorry). Can you take a look? The database was posted on 1-17-2015.

Yes - I entered the following into the form: Company Rev = 100 Company EBITDA = 100 Min Loan Needed = 3000 Loan Type = BLANK/NULL I got loans returned that exceeded the loan MAXIMUM. The other parameters seem to be okay. Recall that I have the loan search parameters set to return loans...

More Parameter Woes... Thanks to you, JNB, I've managed to develop on this theme and have working parameter queries. Now, I've stumbled onto a NEW bug (still in the parameter query vein) - not sure if this should be a new thread. Please pardon my newbie way of trying to explain it - I attached...

This is GREAT, thank you! Question for you... I see the logic to add more and more parameters to the query - though the number of criteria lines increases exponentially with each new parameter. Is there a limit as to how many I can have? I thought I recalled reading that the SQL tops out...

Thank you so much! This helped with the Query - and I can see now how to continue to add more parameters to the query going forward. Can you tell me what you did to "fix" the query - and also - what did you mean by "corrupt in a way." A few questions on the new database you posted... it...

I've attached the database - all of this is "dummy data" anyway. The Queries I'm struggling with are: LenderSearchStruggle - has filters I'm struggling with LenderSearchQuery - simple query with NO filters The form I use (or want to use) to input the parameters is: LoanSearch I...

Another weirdism with the query - if i change what line the criteria are on, I get different results - and often not correct ones. I'm sure that has something to do with AND vs. OR, but I couldn't figure it out. I can explain what I want to have this do, but I can't seem to figure out the...

Hello everyone - hoping someone can help a newbie who has zero VBA experience and very limited SQL knowledge. I created a form that has 3 multiple drop-down selections that is supposed to select records from [TableName_1] based on those selections. I initially created the query using the query...

Hello everyone. I'm a relatively new Access 2013 user developing my first database from scratch. I've fought long and hard to get this far - depending on hours of internet research, Lynda.com tutorials and Access 2013: The Missing Manual. I've read countless posts on this forum and others like...