Search results

Okay, so I think I figured this out by rethinking things. Now I am using "IIf" statements in the criteria fields for my query such as this going into the criteria field in the query design view for the 'Description' control I was talking about earlier: IIf([forms]![Query Builder...

Yeah, it would be easier to just have the end users know how to make simple queries but my boss thinks that this is the best way to give the client a nice print-out of data that they want without them screwing up the database by fiddling around in it. I don't need "AND " statements for the...

Okay so here is how I tweaked your code: Private Sub RunQuery_Click() Dim strWhere As String Dim opText As String 'get your logic operator If Me.fraAndOr = 1 Then opText = "AND " Else opText = "OR " End If 'construct a where clause If Me.GBSize_1X1X1 Then strWhere =...

Thanks for the advice. I'll give it a try and let you know how it works out. I think I'd rather have the query filters all update when the RunQuery button is clicked so in case someone just halfway clicks a bunch of filters and leaves the database then the query isn't saved like that. Since I...

Ok, so here is my situation...(and bear with me, I don't have that much experience with VBA for Access) I want to make a form that gives my client the ability to select from a bunch of 'check boxes' and when the client hits a command button "Run Query" it will filter a master Query (named...

I tried adding some "[" and "]" brackets around the "Forms" and "Instruments TRM" parts, but I still get the same message. It seems that it almost is working but some little operator is either wrong or not present. Any ideas? Thanks. EDIT: I put in apostrophe marks around IN-1021 in the...

When I paste the line you suggested and click the command button I get a syntax error for a "missing operator". Do I need quotation marks around IN-1021 in the code statement? It says the missing operator is in this statement: Forms!Instruments TRM![Unique Tag] = IN-1021

So do I put that suggested line of code you gave me into the command button's code section or do I have to put it in the VBA console for the form that the command button opens? I was hoping to keep all the filtering code in the form with all the command buttons.

I have tried my hand at the VBA code to fix this, but I admit I am a novice in VBA. Hopefully one of you can help me out. Here is what I want to do: I have a form that only has command buttons that represent pieces of equipment in a laboratory floor plan layout (i.e. one button represents one...