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 derfloh 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. pachad

    DMAX

    Using the code below, I am trying to get the latest facility info for each facility, based on user input. The facility detail table stores the info, and only has rows for when data changes i.e.: FACILITYCODE MONTHNO YEARNO RATE PLANT_A 1 2006 100 PLANT_A...
  2. pachad

    Vertical page break

    That's what I am looking for. I know similar capability exists when printing Excel spreadsheets that overlap multiple pages...
  3. pachad

    How to ouput PDF formatted report to dir with VBA

    FYI, You can set the default printer used for a report in the Page Setup dialog. Also try PDF Creator on sourceforge: http://sourceforge.net/projects/pdfcreator/
  4. pachad

    Vertical page break

    Thank you for the quick response. I was hoping for an automatic way of doing this similar to the page break control for horizontal breaks. Does such a thing exist?
  5. pachad

    Vertical page break

    Th only method that I am aware of is setting the left and right margins as well as the report width. So I have to know the page size, and manaually set the columns on a new page?
  6. pachad

    Vertical page break

    I have a report with many fields: |-----| A | B | C | .... | xyz | 1 | 2 | 1 | .... | wxy | 4 | 4 | 3 | .... etc. Question: Is there a way I can have access automatically insert a page break between column B and column C? The page break control in access seems to allow...
  7. pachad

    Table conversion problem

    As you only have one value for each PlantID,ProductID pair you may use the First (or Min, Max, Last, ...) aggregate function on ItemCount Once I added in the Year field, I now have more than one value for a PlantID, ProductID pair, and using the Crosstab gives the SUM for ALL of those rows.
  8. pachad

    Table conversion problem

    CrossTab only allows me to do aggregate functions. I added a new field to the new table called year, and want to show actual counts broked down by year. Report would look the same, but would have Year set to 20XX in the Record Source query. I tried using grouping, but that gives me this...
  9. pachad

    Table conversion problem

    Followup question: How do I re-assemble the original data for a report from the new table? The report looks like the orginal table: |---------| Cars | SUV | Trucks | | Plant A | 4 | 5 | 6 | | Plant B | 3 | 4 | 2 | Thanks
  10. pachad

    Max () function question

    Great. Thanks for the quick response.
  11. pachad

    Max () function question

    PH, Your idea worked great, and I still need to do more research on INNER JOIN. I tried the code below, and it also seemed to work (your use of AS keyed me to it). Will this work the same as your solution, since it uses WHERE and IN which I am more familier with. Thanks. SELECT A.Plant...
  12. pachad

    Max () function question

    I have the following info in a table: |---------| Year | Rate | | Plant A | 2005 | 5.00 | | Plant A | 2006 | 4.00 | | Plant B | 2005 | 3.50 | Not every plant has its rate information changed every year. What query can I use to ensure I always get the most current...
  13. pachad

    Table conversion problem

    Perfect! Thanks for the quick response. Note to users: In access, to create a UNION query see this link: www.ehow.com/how_13580_create-sql-query.html Then create a separate append or create table query to insert the data into the required table.
  14. pachad

    Table conversion problem

    Hello all. I currently have the following table: |---------| Cars | SUV | Trucks | | Plant A | 4 | 5 | 6 | | Plant B | 3 | 4 | 2 | I would like to convert this to the following, with PlantID and ProductID as the primary keys. A separate table would contain PlantID and...
  15. pachad

    Error when trying to delete a subform

    No, no and nope. Thanks all, but I guess I'll have to just redo the wizard. I also tried deleting the dependancy from the dependancy window, but i could not delete from there. Thanks again.
  16. pachad

    Error when trying to delete a subform

    No code at all.
  17. pachad

    Error when trying to delete a subform

    I used the Access form wizard to create a form with two subforms on it. Subsequently, I decided to remove one of the two subforms. I did this by selecting the subform in design view, and pressing the 'delete' key. Now, whenever I open the form I get an access error message stating "Microsoft...
  18. pachad

    excel gridlines

    It's 3 years later (Original post from 2002), and I'm having the same issue. Is there a way to show the gridlines without using a border?
  19. pachad

    Resize a Range object

    I have subsequently discovered that I should not use the Resize method to pass a single row... For lngCtr = 1 to Range("namedRange").Rows.Count myFunction namedRange.Rows(lngCtr) Next lngCtr Duh... [hammer]
  20. pachad

    Resize a Range object

    Thanks, but how would I use the resize method if i only wanted to pass a specific row?

Part and Inventory Search

Back
Top