Search results

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...

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...

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")...

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...