Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ComputiVerse

    Shading report rows

    I want to create my own "greenbar" printouts. That is, I want to shade every 5th row of my printout. I'd prefer doing it without using vba... possibly using the conditional formatting feature of my A2000. I was thinking of doing a record number divided by 5 and shading every row that...
  2. ComputiVerse

    MS Access 2000 Batch Reports

    Why not create each unique report that is needed. Then chain them together in a macro that has several steps. Apply the KISS principle here. Create two or three simple reports. Set your reports to PRINT not PReview. Then experiment with chaining them together in a macro. Further Questions...
  3. ComputiVerse

    Keep label and text field on same report page

    Check your Access helps for "Keep Together Reports" JC Johnstown, OH
  4. ComputiVerse

    Selective boxing of items in a detail list

    I'm not much for basic programming so what I once did was create TWO Fields on the report RIGHT ON TOP OF EACH OTHER!! One field uses an IFF statement condition that will show if the with the shaded background. The IFF statement condition will show the data in an unshaded background if it's...
  5. ComputiVerse

    data mismatch in my query

    Make a copy for security of JUST THE QUERY. Then start deleting one QBE field at a time, till the thing quits hanging up. JC Johnstown, OH
  6. ComputiVerse

    access 2000

    You do things backwards from me. I like to create a query and get it working to grab the records I want, then create a form or a report to show the results. Don't try to solve the whole thing all at once. I say again, get the query working then base the form or report on the query. I get the...
  7. ComputiVerse

    How calculate subtotal/grandtotal

    I'm not sure, but maybe you'll need to create a second query that calls the first query. Johnstown, OH
  8. ComputiVerse

    Landscape format for Report

    I hope you get better response than I have. I've had this same problem posted on the reports forum for a long while and no answers. I feel like quitting answers other people's questions. Johnstown, OH
  9. ComputiVerse

    Grouping in reports

    Reports have filter properties that you can play with. I'm chicken though. I like to always create a QUERY first, to get me the DATA I want. Then I create a report based on that query to give me the LOOK I want. More flexibility, less brains... that's me.
  10. ComputiVerse

    Excluding columns of a report.

    I don't think this is a toughie. I create most of my reports by building a query first and then generate the report from that query. This way gives me much more control over my report. I'd just create two different queries based on the different users menu choices available. Then I'd generate...
  11. ComputiVerse

    Report Format: Vertical Shading

    one thing I forgot. You may have to extend the field size down just a bit, and pull the lower border up so that your colored field is continuous and not have little white gaps between colored blocks. Johnstown, OH
  12. ComputiVerse

    Report Format: Vertical Shading

    in the design view of the report, highlight the DETAIL segment and click on one of the fields. In the properties box of that field change BACKGROUND COLOR to anything you want, even color. I would not get to spastic on this, though. If the report needs to be xeroxed, it could get ugly. Maybe...
  13. ComputiVerse

    Formulas needed for report

    can you use the report wizard and group by question and within that group by employee? When you get the group hiaracy like you want, just tell the wizard you want avgs, sums, and all that stuff. I have found the wizard is really powerful, but you have to keep your eye on the ball. Johnstown, OH...
  14. ComputiVerse

    Windows ME

    I don't think the previous "helpers" for Gordon understand his question. Gordon is like me and many others. When the File explorer was revised for ME they changed some stuff having to do with the "my documents" and other stuff. If you right click on start or go to...
  15. ComputiVerse

    Access Landscape Report

    I cannot get an access 2000 application I've created to save the report in landscape with or without additional changes to the margins. I can as long as I stay in the application it stays landscape. Even if I use the report wizard it still goes back to portrait.

Part and Inventory Search

Back
Top