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. starflt1701

    Summary Function Max or Last

    Hi, I've got a simple one, I think, but I can't figure out the solution. I have a table of data of purchase orders against which I have multiple receipt days. I'm trying to build a query that uses either the Max or Last total function on the date filed to determine the last receipt date. This...
  2. starflt1701

    Printing Sequential Numbers in Excel after Print

    Thanks. I got it now, and it works great! Greatly appreciated.
  3. starflt1701

    Printing Sequential Numbers in Excel after Print

    apparently I need a little more help. I copied both the above subroutines into VBA for the worksheet. Nothing is printing on the copies other than the data on the spreadsheet. I thought perhaps I needed to create a custom header showing the page number, but when I printed, each page showed...
  4. starflt1701

    Printing Sequential Numbers in Excel after Print

    Thanks for the replies. I can't wait to try these out!
  5. starflt1701

    Printing Sequential Numbers in Excel after Print

    I thought I posted this question yesterday, but cannot find it in the list. I apologize if this is a duplicated thread. Anyway, I would like to print multiple copies of a single page worksheet, but incorporate a formula whereby with each copy printed, a unique, sequential number is displayed...
  6. starflt1701

    Summary Function on Non-Recurring Field

    Hey all. I played around with the "whileprintingrecords" function over the long weekend and got it to do what I wanted. It's a thing of beauty! Thanks for your suggestions and inspiration.
  7. starflt1701

    Summary Function on Non-Recurring Field

    OK. I created the formulas as you stated. Put the @AccumScore formula in the details section and the @Display in the group footer. All seem to work well, in that the @Display actually displays the right value for the order based on the criteria. However, I still cannot perform a summary...
  8. starflt1701

    Summary Function on Non-Recurring Field

    Thanks for laying it out for me. I'll let you know how this works.
  9. starflt1701

    Summary Function on Non-Recurring Field

    Can you give me an idea of what that might look like? Will I then be able to perform a summary function on the formula? I'm outside of my comfort zone on this one, so the more specific the help the better. Thanks.
  10. starflt1701

    Summary Function on Non-Recurring Field

    Can't get around this one. I am creating an on-time delivery performance report for my Purchasing Department. They receive large quantities of goods which can, and frequently do, take several days to receive over multiple shipments. It is my job to determine if, at some point over those...
  11. starflt1701

    Linking Access DB to ODBC in Crystal

    Actually, that was my first choice, and I have done that with other, more complex reports. However, the identical tables linked into Access, and the query constructed the same way as the Crystal Report, ran like a dog. Slow as molasses. Actually ran more that 10 times faster in Crystal. I...
  12. starflt1701

    Linking Access DB to ODBC in Crystal

    There is probably a simple solution, but I can't find it. I have linked an Access table to ODBC tables in an existing report. I am using the Access table to feed parameters to the Crystal report. When I did so, a dialogue box told me to go into report options to convert which database drivers...
  13. starflt1701

    Multiple Table Entries from Form

    Unfortunately, I am getting a compile error when I execute the command button. I put both the text box and command button in the report footer. Any ideas?
  14. starflt1701

    Multiple Table Entries from Form

    Thanks. I will try it and let you know how it worked.
  15. starflt1701

    Multiple Table Entries from Form

    I want to use a form to update a table with autonumber. How do I modify a form to create multiple entries into the table, which will have identical information, except for the autonumber, without having to enter the same information into the form repeatedly. In other words, I want to enter...
  16. starflt1701

    Access Overflow

    Thanks. That helps explain what is going on. I will try CLNG.
  17. starflt1701

    Access Overflow

    Can someone please tell me what's going on? I have a rather complicated query which draws information from many tables, including ODBC, and involves some calculations. I recently began getting an "Overflow" error when running the query. After hours of tearing the query apart, I...
  18. starflt1701

    Using PrintDate to Select Records

    Very minimal. Mostly macros in Excel. Do you have any simple models I might study? Thanks,
  19. starflt1701

    Using PrintDate to Select Records

    Never done that before. Do you have any examples?
  20. starflt1701

    Using PrintDate to Select Records

    That would make sense. I'm just trying to find a way to get the report to pick up all data since the last time it was refreshed and printed. Any ideas?

Part and Inventory Search

Back
Top