Search results

Yup, I just learned that MS, in all of its wisdom, decided to replace single-quotes with square-brackets... Which is not SQL standard. That's annoying. Otherwise, SQL isn't a preserved word. But this did fix the problem. Thanks!

Greetings! I have the following sub: Public Sub FilteredQuery() Dim Clauses(2) As String Dim SQL As String 'Add columns here Call AppendClause(Clauses, 0, Me!chkShipped, "Shipped") Call AppendClause(Clauses, 1, Me!chkClosed, "Closed") Call AppendClause(Clauses, 2...

Huh.. Wow, I didn't realize VBA doesn't have an append method. That's unfortunate. But thanks for pointing to a workaround! I've done the Select Case True all over the place. It's the logical equivalent as an If..elseif..elseif..end. Unless Select Case works in some strange way in VBA, that...

I apologize, I'm more familiar with VB than I am VBA. Clauses is a string array, so Append is a inherited array method to place the passed string to a new element at the end of the array. Why would the 2nd case happen every time? Hmm.. Well, if that gives me an issue I'll just wrap the whole...

So I have a sub, here: Public Sub AppendClause(Clauses() As String, Item As CheckBox, Column As String) Select Case True Case IsNull(Item.Value) Return Case (Item.Value = -1) Clauses.Append ("'" + Column + "'" + "=true") Case (Item.Value = 0)...

I apologize. It's a VERY simple setup. The database has one table and one form. The table contains information for deliverables and some tracking thereof (shipped, received, etc.). The form display the contents of the table per record. The goal is to provide the ability to filter the records...

I'm trying to perform a task that I'm absolutely certain is simple to do.. if you know how to do it. I'm trying to add three check boxes in the form header to affect the query related to the form. Each is a simple Boolean, and simply want to apply a "WHERE col1 = val1, col2 = val2, col3 =...

Hi! My name is Jason Adams. I'm a programmer with strong experience in SQL, but mostly using PostgreSQL and MySQL. I'm still very new to Access, and only use it on occasion. I'm also comfortable with VB. I'm sure I'll have a lot of questions as I'm getting familiar with this. Thanks so much in...