Search results

  1. J

    Using Me.RecordSource

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

    Array Parameter Invokes "Invalid Qualifier"

    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)...
  3. J

    Adjusting Query in Form

    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 =...
  4. J

    Greetings!

    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...
Back
Top Bottom