Search results

Yes. And each style is saved in a different Yes/No field with different field names based on style (march, overture, etc.). So I'm trying to filter the table by what is selected in the combo box.

I'm trying to write an sql statement that switches on a forms combo box text. Here is what I have right now. SELECT tblLMB.Title, tblLMB.March, tblLMB.Overture, tblLMB.Patriotic FROM tblLMB WHERE...

Solved it with putting this in the sql: (IIf(Forms!frmLMBSearch!txtTitle.enabled=True,(tblLMB.Title) Like "*" & Forms!frmLMBSearch!txtTitle & "*")<>False) Looks like I just needed (tblLMB.Title) in the iif statement \= I'm not sure what the <>False is doing, but access automatically puts that...

Still nothing. I enter that in IIf ([Forms]![frmLMBSearch]![txtTitle]<>"",[Forms]![frmLMBSearch]![txtTitle]& "*" ,"*") and I get no results with or without text in the specified text box.

Hello, I'm trying to filter a query depending on what text boxes on a form are enabled. I have it in an iif statement and I'm trying to check if the text boxes are enabled or not then go from there. It doesn't seem to be checking the text boxes correctly or something else is wrong. Not sure. Any...

Exactly. I suppose I should have asked the question in its simplest form. Now how would I go about doing this?

Yes, that worked. Thanks. But now another issue comes up. This second database is closed when I close the first one. Now I know that the database object is gone when the first database is closed. Is there any way to make the object stay? Or any way to make it a permanent object?

I am trying to open a database form from another database and this is the code I have to do that. Dim appAccess As Access.Application Dim strDB As String strDB = "C:\Documents and Settings\dave\Desktop\Music Library.accdb" Set appAccess = CreateObject("Access.Application")...

Mmm. Excellent. Thank you.

The field looks like this: DonorRange: LMBDonorRange(Sum([Donation])) DonorRange being the field name. I understand the Donation field is being added together and put into the DonorRange field, but what I don't get is where is LMBDonorRange coming from? The field output looks similar to this...