Search results

  1. M

    acExport and a RowCount with one query

    I feel like one of the blind men trying to describe an elephant. I‘ve taken great bits of code (some from this site) to get pieces of what I need, but I’ve created a monster instead of an elephant. The code needs to do ALL of the following: 1) Export memo fields that are greater than...
  2. M

    rs.RecordCount returns 1 s/b 1,007

    This is hopefully a simple error. I run this code and get 1 record from Debug.Print rsCount When I run the query I get 1,007 (I copied the output of "Debug.Print queryNameOrSQL" from the immediate window - so I run the same code.) note: I commenting out "rs.MoveLast" but still got 1...
  3. M

    Hello from the Left Coast USA

    I've lived in the San Francisco Bay area for 30 years. Married with 2 kids. Most of my adult life I've been doing computer work of one type or another. I am a Senior Database Analyst using MS Access 2003 and Crystal Reports 11. (In a past life I used Oracle.) I do lots of queries that...
Back
Top Bottom