Recent content by Turps

  1. T

    Using Like"*"&[form]&"*" in a query

    Sorry, slight error in what I was trying to show. Here is the correct version and a version with two comboboxes.
  2. T

    Using Like"*"&[form]&"*" in a query

    Here is a sample of the problem. if you select John (1) from the combo box, the query returns John and Frank, because Frank is (10) and 10 is like 1 I suppose. At first I tried applying the criteria or Is Null; however that only appears to work when there is one field to which you are applying...
  3. T

    Using Like"*"&[form]&"*" in a query

    Hello, I have a form that uses combo boxes to filter a subform. The field in the table associated with the subform is joined to the primary key (autonumber) of another table. The combo box in form is meant for show all, or filter none when the combo box is a null value. I use...
  4. T

    New to this site.. not new new to access, but need some help now and then

    Hello everyone, I am new to this site and previously posted one question which was immediately answered by Dbguy. He solved my problem after being stuck on it for quite some time. I am developing some tools for construction project management. In particular, I am building an access database...
  5. T

    Requery Second of Two Subforms

    Thanks so much for your help. I had tried this before; however I the text box was named "text 7" I changed the name to the correct name associated with the parent and BAM! IT WORKS. Thanks again. I spent so much time trying to figure this out.
  6. T

    Requery Second of Two Subforms

    Requery Second of Two subforms I have an issue with a form with subforms that I have created. The main form contains two subforms. Both subforms are formatted as continuous forms. The database was made to log events and the status of those events. The first subform is called Primary_Log_SF...
Top Bottom