Search results

  1. T

    Help with a search routine.

    I already have a crude search setup in my DB using the Access Wizard. It produced the following code: DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70 This canned 'find and replace' dialog defaults to match 'Whole Field'. Is there a way to tweak it so the value defaults to 'Any part...
  2. T

    Is this even possible (Union query question)

    I want to generate monthly reports containing a count of the number of different types of invoices processed during the month. I want the count of invoices of type "A" to end up in a field called "A", the count of type "B" in a field called "B", etc. I tried using a union query, but the counts...
  3. T

    Code to tell if a query name exists?

    I need to write a routine that can tell if a query with a specified name already exists. I've already created something that's functional, albiet very crude. Can anyone show me the better way to do this? (I know there must be one) Here's what I'm using now: Query_Name = "XAQ_" &...
  4. T

    Conditional reporting

    I'm trying to draw a report of a table that has many checkboxes (yes/no). Each checkbox corresponds to text statement (stored in another table). I want to design a report that only prints the text statements corresponding to checkboxes with a value of 'yes'. I've tried using...
Back
Top Bottom